New to Telerik Document Processing? Start a free 30-day trial

FormatStringCategory

Enum

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

Definition

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public enum FormatStringCategory

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

Accounting = 3

Monetary values with currency symbol and negative number formatting.

Currency = 2

User-defined format patterns not matching predefined categories.

Custom = 11

Date values formatted according to culture-specific patterns.

Date = 4

Numeric values displayed as fractions with configurable denominators.

Fraction = 7

Default format with no specific pattern.

General = 0

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

Number = 1

Numeric values displayed as percentages.

Percentage = 6

Numeric values in exponential notation.

Scientific = 8

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

Special = 10

Text values displayed without numeric interpretation.

Text = 9

Time values formatted with hours, minutes, and seconds.

Time = 5