Class BuiltInNumberFormats
Provides culture-aware factory methods for Excel built-in number formats whose formatCode is implied (not explicitly written) on export.
Inheritance
Inherited Members
Namespace: Telerik.Documents.SpreadsheetStreaming
Assembly: Telerik.Documents.SpreadsheetStreaming.dll
Syntax
public static class BuiltInNumberFormatsMethods
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
The number format string. |
GetFormatById(Int32)
Returns built in format with the specified id.
Declaration
public static string GetFormatById(int id)Parameters
|
System.Int32
id
The searched format id. |
Returns
|
System.String
The format string. |
GetFraction()
Generates a Fraction number format for up to one digit. Example format in en-US culture: # ?/?.
Declaration
public static string GetFraction()Returns
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
The number format string. |
GetNumber()
Returns the basic integer number format (e.g. en-US: 0).
Declaration
public static string GetNumber()Returns
|
System.String
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
|
System.String
The number format string. |
GetNumber2()
Returns an integer number format including thousands separators (e.g. en-US: #,##0).
Declaration
public static string GetNumber2()Returns
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
The number format string. |
GetPercent()
Returns a percent format with no decimal places (e.g. en-US: 0%).
Declaration
public static string GetPercent()Returns
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
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
|
System.String
The number format string. |