TdxSpreadSheetFormatSettings Class

Stores spreadsheet format settings for parser routines.

Declaration

TdxSpreadSheetFormatSettings = class(
    TdxSpreadSheetCustomFormatSettings
)

Remarks

Format settings allow you to define locale-dependent characters and formatting patterns for use in formula expressions.

Main API Members

The list below outlines key members of the TdxSpreadSheetFormatSettings class. These members allow you to configure parser-related settings.

Formula Parser-Specific Settings

ArraySeparator | DecimalSeparator | ListSeparator

Allow you to replace array, list, and decimal separator characters in formula expressions (individual characters).

BreakChars

Specifies a line break character sequence (a string).

CurrencyFormat

Specifies the currency format pattern.

R1C1Reference

Allows you to switch between A1 and R1C1 cell reference modes.

System Locale-Specific Settings

Data

Stores system locale settings.

DateTimeSystem

Allows you to switch between available spreadsheet-specific date/time formats.

UpdateSettings

Initializes or updates Data and DateTimeSystem settings using the system locale as a source.

General-Purpose API Members

Assign

Copies compatible spreadsheet format settings from a specified source.

GetFunctionName

Obtains a localized function name from a resource string.

Direct TdxSpreadSheetFormatSettings Class References

The following public API members reference a TdxSpreadSheetFormatSettings object:

TdxSpreadSheetCustomFormula.FormatSettings

Provides access to the formula expression’s source text string parsing format settings.

TdxSpreadSheetCustomFormulaController.FormatSettings

Provides access to format settings used to parse formula expressions.

Terminal TdxSpreadSheetFormatSettings Class Descendants

TcxDataControllerConditionalFormattingFormatSettings

TcxDataControllerSpreadSheetFormatSettings

Inheritance

TObject

TdxSpreadSheetCustomFormatSettings

TdxSpreadSheetFormatSettings