TFlxNumberFormat Class
Static class to convert cells to formatted strings. It uses format strings from Excel, that are different to those on .net, so we have to try to reconcile the diffs.
Syntax
Namespace: FlexCel.Core
public static class TFlxNumberFormatMethods
| Name | Description |
|---|---|
| FormatValue | Overloaded FormatValue(Object, String, ExcelFile) FormatValue(Object, String, TUIColor, ExcelFile) FormatValue(Object, String, TUIColor, ExcelFile, Boolean) FormatValue(Object, String, TUIColor, ExcelFile, Boolean, Boolean) FormatValue(Object, String, TUIColor, ExcelFile, Boolean, Boolean, TAdaptativeFormats) FormatValue(Object, String, TUIColor, ExcelFile, Boolean, Boolean, Int32, TAdaptativeFormats) |
| HasDateOrTime | Returns true if the format string has a date or a time. |
| HasDate | Returns true if the format string has a date. |
| HasTime | Returns true if the format string has a time. |
| PercentCount | Returns the number of % sign in a cell. Each % in the format string multiplies the value by 100, so 0.1 formatted as "0%" will display as 10% and formatted as 0%% will display as 1000%%. |
Properties
| Name | Description |
|---|---|
| RegionalDateString | Returns the string used on a standard date on the current locale |
| RegionalDateTimeString | Returns the string used on a standard date and time on the current locale |
Events
| Name | Description |
|---|---|
| CultureCreating | Fires before a culture is created. Read Localized Month Names for more information on how to use it. Note that this event is static and it applies to the whole app. |