TFlxNumberFormat Record
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
Unit: FlexCel.Core
TFlxNumberFormat = record;
Methods
Name | Description |
---|---|
FormatValue | Overloaded FormatValue(TCellValue, string, TCoreExcelFile) FormatValue(TCellValue, string, TUIColor, TCoreExcelFile) FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean) FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean, Boolean) FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean, Boolean, TAdaptativeFormats) FormatValue(TCellValue, string, TUIColor, TCoreExcelFile, Boolean, Boolean, Integer, 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. |