@squidcloud/client
    Preparing search index...

    Interface SpreadsheetSheetInfo

    Structural information about one sheet of a spreadsheet file.

    interface SpreadsheetSheetInfo {
        columnCount: number;
        disconnected?: boolean;
        formulaCellCount?: number;
        formulaSample?: string[];
        hidden?: boolean;
        inboundRefCount?: number;
        mergedRangeCount?: number;
        name: string;
        outboundRefCount?: number;
        refErrorCount?: number;
        rowCount: number;
    }
    Index

    Properties

    columnCount disconnected? formulaCellCount? formulaSample? hidden? inboundRefCount? mergedRangeCount? name outboundRefCount? refErrorCount? rowCount

    Properties

    columnCount: number

    Number of columns in the sheet.

    disconnected?: boolean

    Present and true when the sheet is hidden AND exchanges no formula reference with any visible sheet in either direction, i.e. it takes no part in the workbook's live dependency graph.

    Deliberately conservative on three counts. It is never asserted for visible sheets, which are orphaned by design far more often than not (cover pages, chart tabs, mapping tables). It requires the OUTBOUND half too, so a hidden staging or print sheet that merely reads the live model — downstream of it, not orphaned from it — stays unflagged. And it remains a heuristic for "legacy", not a proof: INDIRECT(), defined-name and VBA/Power Query references are all invisible to a formula scan, so a hidden sheet reached only that way is a false positive. Consumers should present it as the evidence it is, never as a verdict.

    formulaCellCount?: number

    Cells whose value is computed by a formula. Omitted when zero, keeping the stored JSON compact.

    formulaSample?: string[]

    Up to a few representative formulas ("C5=SUM(B2:B4)") for the summary preview. NOT persisted in the bounded inventory JSON — preview-time only.

    hidden?: boolean

    Present and true when the sheet is hidden (or very-hidden) in the workbook. Hidden sheets are extracted like visible ones; the flag lets downstream surfaces say so. Omitted for visible sheets to keep the stored inventory JSON compact.

    inboundRefCount?: number

    Sheet-qualified references to this sheet from formulas on OTHER VISIBLE sheets. Omitted when zero. References from hidden sheets are excluded on purpose: a sheet only an orphan reads is itself orphaned.

    mergedRangeCount?: number

    Merged ranges declared on the sheet. Omitted when zero.

    name: string

    The sheet name.

    outboundRefCount?: number

    Sheet-qualified references from this sheet's formulas to other sheets. Omitted when zero.

    refErrorCount?: number

    Formulas on the sheet containing a #REF! error, the signature of deleted precedents. Omitted when zero.

    rowCount: number

    Number of data rows in the sheet (excluding the header row).

    Settings

    Member Visibility

    On This Page

    Properties