Available for: UI for ASP.NET MVC | UI for ASP.NET AJAX | UI for Blazor | UI for WPF | UI for WinForms | UI for Xamarin | UI for WinUI | UI for ASP.NET Core

New to Telerik Document Processing? Download free 30-day trial

Culture Spescific Predefined Formats

Starting with R3 2021, SpreadStreamProcessing exposes the BuiltInNumberFormats static class. This class contains several methods that allow you to get a set of predefined formats. These formats are culture-specific. This means that they depend on the current culture of the operating system. And for example, if you set a currency format you will get the currency symbol for the current culture. Currently, the following methods are exposed:

Method Format in en-US culture Description
GetGeneral General Generates the General number format string.
GetNumber 0 Generates a Number number format string.
GetNumber1 0.00 Generates a Number number format string with 2 decimal places and no thousand separator.
GetNumber2 #,##0 Generates a Number number format string with zero decimal places and using a thousand separator.
GetNumber3 #,##0.00 Generates a Number number format string with 2 decimal places and a thousand separator.
GetCurrency $#,##0_);($#,##0) Generates a Currency number format string with no decimal places and positive and negative format patterns and alignment.
GetCurrency1 $#,##0_);[Red]($#,##0) Generates a Currency number format string with no decimal places and positive and negative format with red digits patterns and alignment.
GetCurrency2 $#,##0.00_);($#,##0.00) Generates a Currency number format string with two decimal places and positive and negative format patterns and alignment.
GetCurrency3 $#,##0.00_);[Red]($#,##0.00) Generates a Currency number format string with two decimal places and positive and negative format with red digits patterns and alignment.
GetPercent 0% Generates a Percent number format string
GetPercent1 0.00% Generates a Percent number format string with 2 decimal places and no thousand separator.
GetScientific 0.00E+00 Generates a culture dependent Scientific number format string.
GetFraction # ?/? Generates a Fraction number format for up to one digit
GetFraction1 # ??/?? Generates a Fraction number format for up to two digit.
GetShortDate m/d/yyyy Generates a Date number format for short date.
GetDayMonthYear d-mmm-yy Generates a Date number format with day, month and year.
GetDayMonth d-mmm Generates a Date number format with day and month.
GetMonthYear mmm-yy Generates a Date number format with month and year.
GetHourMinuteAMPM h:mm AM/PM Generates a Time number format with hours, minutes and AM/PM.
GetHourMinuteSecondAMPM h:mm:ss AM/PM Generates a Time number format with hours, minutes, seconds and AM/PM.
GetHourMinute h:mm Generates a Time number format with hours and minutes.
GetHourMinuteSecond h:mm:ss Generates a Time number format with hours, minutes and seconds.
GetShortDateHourMinute m/d/yyyy h:mm Generates a Time number format with short date, hours and minutes.
GetDayMonthLongYear m/d/yyyy Generates a Date number format with day, month and year.
GetNumber4 #,##0_);(#,##0) Generates a Currency number format string with no decimal places, a thousand separator, and positive and negative format pattern and alignment.
GetNumber5 #,##0_);[Red](#,##0) Generates a Currency number format string with no decimal places, a thousand separator, and positive and negative format with red digits patterns and alignment.
GetNumber6 #,##0.00_);(#,##0.00) Generates a Currency number format string with two decimal places, a thousand separator, and positive and negative format pattern and alignment.
GetNumber7 #,##0.00_);[Red](#,##0.00) Generates a Currency number format string with two decimal places, a thousand separator, and positive and negative format with red digits patterns and alignment.
GetCurrency4 (*#,##0);(*(#,##0);(* "-");(@_)
GetCurrency5 ($*#,##0);($*(#,##0);($* "-");(@_)
GetCurrency6 (*#,##0.00);(*(#,##0.00);(*"-"??);(@_)
GetCurrency7 ($*#,##0.00);($*(#,##0.00);($*\"-\"??);(@_)
GetScientific2 ##0.0E+0

Working with the BuiltInNumberFormats class

Example 1 demonstrates how you can get specific format and set it when exporting a cell.

Example 1: Using BuiltInNumberFormats class

SpreadCellFormat format = new SpreadCellFormat(); 
format.NumberFormat = BuiltInNumberFormats.GetFraction(); 
 
using (ICellExporter cell = row.CreateCellExporter()) 
{ 
    cell.SetValue(0.5); 
    cell.SetFormat(format); 
} 
In this article
Not finding the help you need? Improve this article