SheetXL - v1.0.2
    Preparing search index...

    Variable ContentConst

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

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

    Type Declaration

    • ReadonlyComments: "comments"

      Represents the threaded comments attached to the cells.

      Notes are not included; they are Content.Notes. Excel for the web's Clear Comments and Clear Notes. Clearing everything (no content) removes both.

    • 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.

      Clearing formulas keeps the values they show, as copying and pasting values in place would; a dynamic array anchored in the range keeps every value it spilled. A cell still waiting on an asynchronous result keeps what it shows while waiting. To clear the values too, clear Content.Values.

    • 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.

    • ReadonlySparklines: "sparklines"

      Represents the sparklines drawn in the cells.

      A clear takes the cells out of their sparkline groups; a group left with no cell is deleted. Excel's Sparkline > Clear. Clear Contents and Clear Formats leave a sparkline, as in Excel; Clear All removes it.

    • 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