Trailing zeros in column values

[th1988]

Is there a configuration option which we can use to ensure that the trailing zeros will be stored in the xlsx file ?

My database field is a string field.

[randym]

Hi th1988 Sorry for the long delay, I've been working on some different projects in my open source time.

Can you send me an example of your data please? I would not be surprised if leading zeros (e.g. 001234) were getting crunched by excel as it is going to interpret that as a number as we have all seen with CSV.

I think it is possible to make some alterations so that you can specify styles and formatting for specific attributes but I'd like to confirm if this is leading or trailing zeros.