Class BuiltInNumberFormats

A static class providing API for retrieving the built in number formats. Which when exported their formatCode is implied rather that explicitly saved in the file.

Inheritance

System.Object

BuiltInNumberFormats

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Telerik.Documents.SpreadsheetStreaming

Assembly: Telerik.Documents.SpreadsheetStreaming.dll

Syntax

public static class BuiltInNumberFormats

Methods

GetCurrency()

Generates a Currency number format string with no decimal places and positive and negative format patterns and alignment. Example format in en-US culture: $#,##0_);($#,##0).

Declaration

public static string GetCurrency()

Returns

System.String The number format string.

GetCurrency1()

Generates a Currency number format string with no decimal places and positive and negative format with red digits patterns and alignment. Example format in en-US culture: $#,##0_);Red.

Declaration

public static string GetCurrency1()

Returns

System.String The number format string.

GetCurrency2()

Generates a Currency number format string with two decimal places and positive and negative format patterns and alignment. Example format in en-US culture: $#,##0.00_);($#,##0.00).

Declaration

public static string GetCurrency2()

Returns

System.String The number format string.

GetCurrency3()

Generates a Currency number format string with two decimal places and positive and negative format with red digits patterns and alignment. Example format in en-US culture: $#,##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()

Generates the General number format string. Examle format in en-US culture: 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()

Generates a Number number format string. Example format in en-US culture: 0.

Declaration

public static string GetNumber()

Returns

System.String The number format string.

GetNumber1()

Generates a Number number format string with 2 decimal places and no thousand separator. Example format in en-US culture: 0.00.

Declaration

public static string GetNumber1()

Returns

System.String The number format string.

GetNumber2()

Generates a Number number format string with zero decimal places and using a thousand separator. Example format in en-US culture: #,##0.

Declaration

public static string GetNumber2()

Returns

System.String The number format string.

GetNumber3()

Generates a Number number format string with 2 decimal places and a thousand separator. Example format in en-US culture: #,##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()

Generates a Percent number format string. Example format in en-US culture: 0%.

Declaration

public static string GetPercent()

Returns

System.String The number format string.

GetPercent1()

Generates a Percent number format string with 2 decimal places and no thousand separator. Example format in en-US culture: 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.