Hello,
I’m trying to format a currency column in TeeGrid, but the DataFormat.Float property seems to have no effect.
Environment:
- Delphi 10.3.3 / TeeGrid 1.19
- Database: SQL Server
- Field Type: Money (mapped to TBCDField)
- Column Name: ‘Amount’
Code tested:
TeeGrid1.Columns['Amount'].DataFormat.Float := '0.';
TeeGrid1.Columns['Amount'].DataFormat.Float := '0.##';
TeeGrid1.Columns['Amount'].DataFormat.Float := '0.00';
TeeGrid1.Columns['Amount'].DataFormat.Float := '#,##0.0000';
teeDataFormat.7z (51.6 KB)
None of these format strings change the display format. The column still shows the default format.
Question:
What is the correct way to format currency/money fields in TeeGrid? Should I use a different property or approach?
Thank you!