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, 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
RegionalDate​Time​String	Returns the string used on a standard date and time on the current locale