ClassBuiltInNumberFormats
Provides culture-aware factory methods for Excel built-in number formats whose formatCode is implied (not explicitly written) on export.
Definition
Namespace:Telerik.Documents.SpreadsheetStreaming
Assembly:Telerik.Documents.SpreadsheetStreaming.dll
Syntax:
public static class BuiltInNumberFormatsInheritance: objectBuiltInNumberFormats
Methods
GetCurrency()
Returns a currency format with no decimals and standard positive/negative patterns (e.g. en-US: $#,##0_);($#,##0)).
Declaration
public static string GetCurrency()Returns
The number format string.
GetCurrency1()
Returns a currency format with no decimals using red for negative values (e.g. en-US: $#,##0_);Red).
Declaration
public static string GetCurrency1()Returns
The number format string.
GetCurrency2()
Returns a currency format with two decimals and standard positive/negative patterns (e.g. en-US: $#,##0.00_);($#,##0.00)).
Declaration
public static string GetCurrency2()Returns
The number format string.
GetCurrency3()
Returns a currency format with two decimals using red for negative values (e.g. en-US: $#,##0.00_);Red).
Declaration
public static string GetCurrency3()Returns
The number format string.
GetCurrency4()
Generates a Currency number format string. Example format in en-US culture: (*#,##0);(*(#,##0);(* "-");(@_).
Declaration
public static string GetCurrency4()Returns
The number format string.
GetCurrency5()
Generates a Currency number format string. Example format in en-US culture: ($*#,##0);($*(#,##0);($* "-");(@_).
Declaration
public static string GetCurrency5()Returns
The number format string.
GetCurrency6()
Generates a Currency number format string. Example format in en-US culture: (*#,##0.00);(*(#,##0.00);(*"-"??);(@_).
Declaration
public static string GetCurrency6()Returns
The number format string.
GetCurrency7()
Generates a Currency number format string. Example format in en-US culture: ($*#,##0.00);($*(#,##0.00);($*"-"??);(@_).
Declaration
public static string GetCurrency7()Returns
The number format string.
GetDayMonth()
Generates a Date number format with day and month. Example format in en-US culture: d-mmm.
Declaration
public static string GetDayMonth()Returns
The number format string.
GetDayMonthLongYear()
Generates a Date number format with day, month and year. Example format in en-US culture: m/d/yyyy.
Declaration
public static string GetDayMonthLongYear()Returns
The number format string.
GetDayMonthYear()
Generates a Date number format with day, month and year. Example format in en-US culture: d-mmm-yy.
Declaration
public static string GetDayMonthYear()Returns
The number format string.
GetFormatById(int)
Returns built in format with the specified id.
GetFraction()
Generates a Fraction number format for up to one digit. Example format in en-US culture: # ?/?.
Declaration
public static string GetFraction()Returns
The number format string.
GetFraction1()
Generates a Fraction number format for up to two digit. Example format in en-US culture: # ??/??.
Declaration
public static string GetFraction1()Returns
The number format string.
GetGeneral()
Returns the General number format string for the current culture (e.g. en-US: General).
Declaration
public static string GetGeneral()Returns
The number format string.
GetHourMinute()
Generates a Time number format with hours and minutes. Example format in en-US culture: h:mm.
Declaration
public static string GetHourMinute()Returns
The number format string.
GetHourMinuteAMPM()
Generates a Time number format with hours, minutes and AM/PM. Example format in en-US culture: h:mm AM/PM.
Declaration
public static string GetHourMinuteAMPM()Returns
The number format string.
GetHourMinuteSecond()
Generates a Time number format with hours, minutes and seconds. Example format in en-US culture: h:mm:ss.
Declaration
public static string GetHourMinuteSecond()Returns
The number format string.
GetHourMinuteSecondAMPM()
Generates a Time number format with hours, minutes, seconds and AM/PM. Example format in en-US culture: h:mm:ss AM/PM.
Declaration
public static string GetHourMinuteSecondAMPM()Returns
The number format string.
GetMonthYear()
Generates a Date number format with month and year. Example format in en-US culture: mmm-yy.
Declaration
public static string GetMonthYear()Returns
The number format string.
GetNumber()
Returns the basic integer number format (e.g. en-US: 0).
Declaration
public static string GetNumber()Returns
The number format string.
GetNumber1()
Returns a number format with two decimal places and no thousands separator (e.g. en-US: 0.00).
Declaration
public static string GetNumber1()Returns
The number format string.
GetNumber2()
Returns an integer number format including thousands separators (e.g. en-US: #,##0).
Declaration
public static string GetNumber2()Returns
The number format string.
GetNumber3()
Returns a number format with two decimal places and thousands separators (e.g. en-US: #,##0.00).
Declaration
public static string GetNumber3()Returns
The number format string.
GetNumber4()
Generates a Currency number format string with no decimal places, a thousand separator, and positive and negative format pattern and alignment. Example format in en-US culture: #,##0_);(#,##0).
Declaration
public static string GetNumber4()Returns
The number format string.
GetNumber5()
Generates a Currency number format string with no decimal places, a thousand separator, and positive and negative format with red digits patterns and alignment. Example format in en-US culture: #,##0_);Red.
Declaration
public static string GetNumber5()Returns
The number format string.
GetNumber6()
Generates a Currency number format string with two decimal places, a thousand separator, and positive and negative format pattern and alignment. Example format in en-US culture: #,##0.00_);(#,##0.00).
Declaration
public static string GetNumber6()Returns
The number format string.
GetNumber7()
Generates a Currency number format string with two decimal places, a thousand separator, and positive and negative format with red digits patterns and alignment. Example format in en-US culture: #,##0.00_);Red.
Declaration
public static string GetNumber7()Returns
The number format string.
GetPercent()
Returns a percent format with no decimal places (e.g. en-US: 0%).
Declaration
public static string GetPercent()Returns
The number format string.
GetPercent1()
Returns a percent format with two decimal places (e.g. en-US: 0.00%).
Declaration
public static string GetPercent1()Returns
The number format string.
GetScientific()
Generates a cuture dependent Scientific number format string. Example format in en-US culture: 0.00E+00.
Declaration
public static string GetScientific()Returns
The number format string.
GetScientific2()
Generates a culture dependent Scientific number format string. Example format in en-US culture: ##0.0E+0.
Declaration
public static string GetScientific2()Returns
The number format string.
GetShortDate()
Generates a Date number format for short date. Example format in en-US culture: m/d/yyyy.
Declaration
public static string GetShortDate()Returns
The number format string.
GetShortDateHourMinute()
Generates a Time number format with short date, hours and minutes. Example format in en-US culture: m/d/yyyy h:mm.
Declaration
public static string GetShortDateHourMinute()Returns
The number format string.