Enum
FormatStringCategory

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

Definition

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

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

cs-api-definition
public enum FormatStringCategory

Fields

Accounting

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

Declaration

cs-api-definition
Accounting = 3

Field Value

FormatStringCategory

Currency

Monetary values with currency symbol and negative number formatting.

Declaration

cs-api-definition
Currency = 2

Field Value

FormatStringCategory

Custom

User-defined format patterns not matching predefined categories.

Declaration

cs-api-definition
Custom = 11

Field Value

FormatStringCategory

Date

Date values formatted according to culture-specific patterns.

Declaration

cs-api-definition
Date = 4

Field Value

FormatStringCategory

Fraction

Numeric values displayed as fractions with configurable denominators.

Declaration

cs-api-definition
Fraction = 7

Field Value

FormatStringCategory

General

Default format with no specific pattern.

Declaration

cs-api-definition
General = 0

Field Value

FormatStringCategory

Number

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

Declaration

cs-api-definition
Number = 1

Field Value

FormatStringCategory

Percentage

Numeric values displayed as percentages.

Declaration

cs-api-definition
Percentage = 6

Field Value

FormatStringCategory

Scientific

Numeric values in exponential notation.

Declaration

cs-api-definition
Scientific = 8

Field Value

FormatStringCategory

Special

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

Declaration

cs-api-definition
Special = 10

Field Value

FormatStringCategory

Text

Text values displayed without numeric interpretation.

Declaration

cs-api-definition
Text = 9

Field Value

FormatStringCategory

Time

Time values formatted with hours, minutes, and seconds.

Declaration

cs-api-definition
Time = 5

Field Value

FormatStringCategory