ICheckingOutput

Defines the public contract for the CheckingOutput class, exposing worksheet binding, diagnostic entry rendering, and interactive filtering for severity and title criteria.

Elements

Wksh #

Retrieve the worksheet backing this output writer

Signature:

Public Property Get Wksh() As Worksheet: End Property

Worksheet binding and output metadata. Returns the worksheet that receives the checking output.

Returns: Worksheet. Target worksheet reference.


Name #

Name of the output session

Signature:

Public Property Get Name() As String: End Property

Returns the label assigned during creation.

Returns: String. Output session label.


Operations

PrintOutput #

Write checking values to a worksheet

Signature:

Public Sub PrintOutput(ByVal checkTable As BetterArray): End Sub

Rendering and filtering of diagnostic entries. Implementations must write the supplied check results to the bound worksheet, initialising formatting and filters as needed.

Parameters:

  • checkTable: BetterArray. Collection of IChecking instances to print.

FilterWorksheet #

Apply the active filter on the output worksheet

Signature:

Public Sub FilterWorksheet(Optional ByVal selectionValue As String = vbNullString, _
                           Optional ByVal titleSelection As String = vbNullString): End Sub

Re-evaluates the drop-down filter to hide or reveal rows matching the requested severity and/or title.

Parameters:

  • selectionValue: Optional String. Severity filter token (All/Errors/Warnings/Notes/Infos).
  • titleSelection: Optional String. Title limiting rows to a specific checking topic.

EnsureWorksheetChangeHandler #

Inject the worksheet change handler for interactive filtering

Signature:

Public Sub EnsureWorksheetChangeHandler(): End Sub

Installs VBA code in the worksheet module so filter drop-down changes trigger row visibility updates automatically.