TAdvGridExcelIO Export Format (Boolean Values)

VCL TMS VCL UI Pack
1

Hi!

I have a DBAdvGrid connected to an AdvGridExxelIO.
The table contains some boolean fields (in the grid columns are set to "Checkboxfield" and in the Grid everything is fine).
When I export the grid, the boolean field values are exported as "False" and "True" in the Excel file.
Where can I change the output, e.g. to "1" and "0" or "x" and ""?
In OnCellFormat or OnExportCellFormat the vakue itself can't be changed as the parameter is a const.

Many thanks in advance and kind regards
Andreas

2

That should be possible by returning and "1" or "0" from the grid.OnSaveCell() event.

1 Like
3

Perfect!
Many thanks

4

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.