tmssoftware.com
TMS Support Center
TFlxFormat.Format
FLX
TMS FlexCel for VCL & FMX
1114
(Гаврилин Михаил)
July 11, 2019, 4:41pm
1
How to determine the format of the cell.
What values can return TFlxFormat.Format.
adrian
(adrian)
July 11, 2019, 7:35pm
2
Hi,
TFlxFormat.Format returns a string with the numeric format of the cell. the string is always in English, and it is a standard Excel formatting string.
The format is defined here:
https://support.office.com/en-us/article/number-format-codes-5026bbd6-04bc-48cd-bf33-80f18b4eae68
But remember that you can always use APIMate to find out what a given format is. Just format the cell as you want in Excel, save the file, open it in APIMate, and it will tell you the numeric format you used.
© tmssoftware.com