Enum FormatStringCategory

Defines the category of a cell value format string, determining how values are interpreted and displayed.

Namespace: Telerik.Windows.Documents.Spreadsheet.Formatting.FormatStrings

Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public enum FormatStringCategory

Accounting

Monetary values with currency symbol alignment and zero display as dash.

Currency

Monetary values with currency symbol and negative number formatting.

Custom

User-defined format patterns not matching predefined categories.

Date

Date values formatted according to culture-specific patterns.

Fraction

Numeric values displayed as fractions with configurable denominators.

General

Default format with no specific pattern.

Number

Numeric values with optional decimal places, thousand separators, and negative number handling.

Percentage

Numeric values displayed as percentages.

Scientific

Numeric values in exponential notation.

Special

Culture-specific formats such as postal codes, phone numbers, and social security numbers.

Text

Text values displayed without numeric interpretation.

Time

Time values formatted with hours, minutes, and seconds.