TdxSpreadSheetChange Enum

Enumerates changes made in an opened spreadsheet document.

Declaration

delphi

TdxSpreadSheetChange = (
    sscData,
    sscLayout,
    sscZoom,
    sscStyle,
    sscDimension,
    sscOptionsPrint,
    sscModified,
    sscBiDiMode,
    sscMetadata
);

Members

Name
`sscData`
`sscLayout`
`sscZoom`
`sscStyle`
`sscDimension`
`sscOptionsPrint`
`sscModified`
`sscBiDiMode`
`sscMetadata`

Remarks

Options include:

Value

Description

| | --- | --- | |

sscData

Indicates a cell change (that is, a cell create, delete, or move operation, or a cell value change).

| |

sscLayout

The most common spreadsheet change flag. Indicates a document structure change (that is, worksheet create, delete, rearrange, or rename operation) or a worksheet view/content change (that is, a cell object operation, a change to cell value or formatting, a zoom factor change, etc.).

| |

sscZoom

Indicates a zoom in or out operation.

| |

sscStyle

Indicates a style change in a cell or cell range.

| |

sscDimension

Indicates that a worksheet’s populated area has shrunk or expanded due to a cell create or delete operation.

| |

sscOptionsPrint

Indicates that a print setting was changed in a worksheet’s OptionsPrint property set.

| |

sscModified

Indicates any change in an opened document. This flag always changes a spreadsheet control‘s Modified property to True and raises the OnModifiedChanged event.

| |

sscBiDiMode

Indicates that one of the following property values has changed:

A spreadsheet control’s BiDiMode property.
A worksheet’s Options.RightToLeftLayout property.

| |

sscMetadata

Indicates a manual change in a spreadsheet control’s OptionsMetadata property set. This flag is not present when the spreadsheet control automatically updates metadata when a change in the opened document occurs or when a print operation is performed.

The TdxSpreadSheetChanges type references the TdxSpreadSheetChange type.