Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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:

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.

See Also