SheetXL - v0.8.0-beta.9+sites.210.e2d420901
    Preparing search index...

    Variable ContentConst

    Content: {
        Comments: "comments";
        DataValidations: "dataValidations";
        Formats: "formats";
        Formulas: "formulas";
        Hyperlinks: "hyperlinks";
        Notes: "notes";
        Tables: "tables";
        Values: "values";
    } = ...

    Represents the types of content that can be associated with a cell or range.

    Type Declaration

    • ReadonlyComments: "comments"

      Represents comments attached to the cells, notes included.

      Excel offers a single Clear Comments and Notes, and this is it. Content.Notes is the narrower one, for the notes alone.

    • ReadonlyDataValidations: "dataValidations"

      Represents the data validations covering the cells.

      A clear cuts the cells out of every validation covering them; a validation left covering nothing is deleted, and one that also covers other cells keeps them. Office Scripts' range.getDataValidation().clear().

    • ReadonlyFormats: "formats"

      Represents the formatting and styling applied to the cells (fonts, colors, borders, etc.).

    • ReadonlyFormulas: "formulas"

      Represents the formulas contained within the cells.

    • Represents hyperlinks associated with the cells.

    • ReadonlyNotes: "notes"

      Represents notes associated with the cells.

      A note is a comment carrying asNote — the two share one store — so this selects the notes out of a range rather than naming a store of its own. Displaying a note as Excel's simple yellow box, rather than as a comment, is NOT IMPLEMENTED.

    • ReadonlyTables: "tables"

      Represents tables associated with the cells.

    • ReadonlyValues: "values"

      Represents the actual values stored in the cells (numbers, text, booleans, etc.).

    This is the paste/clear vocabulary — what clear and copyFrom operate on, aligned to Office Scripts (ClearApplyTo / RangeCopyType). It is deliberately not a union view over Feature: its members name behaviors, not subsets — Values pastes a formula's computed result (a transform), and Formats carries merge state as Excel's format painter does. The read path (getCounts, isContentful, getRegions) selects by ICellRange.Feature.

    Errors, Warnings and Merges left this enum with the getCounts realignment — they were query vocabulary riding along (nothing pastes an error); querying is ICellRange.Feature.Error / .Merge (warnings return with evaluated-state support).

    Settings
    Member Visibility