ICrossTableFormula

Defines the public contract for the CrossTableFormula class. Exposes a validity check and a method to write all computed formulas into the cross-table cells on the analysis output worksheet. Formula scope for linelist vs analysis formulas

Methods

AddFormulas #

Write all formulas to the cross-table on the worksheet

Signature:

Public Sub AddFormulas(): End Sub

Iterates through the cross-table cells and writes the appropriate Excel formula into each data cell. Handles column formulas, row formulas, percentage formulas, and total formulas based on the table scope and specification flags. Skips writing when Valid returns False.

Properties

Valid #

Whether the formula object is valid for the analysis context

Signature:

Public Property Get Valid() As Boolean: End Property

Returns True when the underlying formula definition and cross-table reference are both properly initialised. Callers should check this before calling AddFormulas to avoid writing incomplete output.

Returns: Boolean. True when the formula object is ready to write.