AdvGridExcelIO export in text format

Guenzani_Manuela · January 9, 2019, 11:40am

Hello,

I use AdvStrGrid and in 3 columns I have values numeric by as a text because some values can be start with 0 (zero) (example 001235, 0186922).

I add the grid with: grd1.cells[5,r] := query1.fieldbyname('code').asstring;

I see the grid correctly but when I export with AdvGridExcellIO these columns become without the inizial zero and 001235 -> 1235, 0186922 -> 186922

This is a problem for me because these values are products code and not find to my DB.

How I can export correctly with initial zero?

Thank's

brunofierens · January 9, 2019, 4:48pm

This is because Excel applies its own formatting and default this is without 0 prefix.

To control the format, this is explained in this article & sample: