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.
Related topics
Topic
Replies
Views
Activity
TFlxFormat.Format String
TMS FlexCel for VCL & FMX
2
1124
March 9, 2015
Date format
TMS FlexCel for VCL & FMX
4
1687
January 19, 2016
Components of a Numerical Format...
TMS FlexCel for VCL & FMX
0
603
December 18, 2013
Determine TCellType for empty cell
TMS FlexCel Studio for .NET
1
1279
August 16, 2016
Format Col
TMS FlexCel for VCL & FMX
5
623
December 3, 2015
© tmssoftware.com