activeadmin-axlsx icon indicating copy to clipboard operation
activeadmin-axlsx copied to clipboard

Published 20 hours ago • verified publisher icon randym

Trailing zeros in column values

Open th1988 opened this issue 12 years ago • 1 comments
trafficstars

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.

th1988 avatar Jul 30 '13 14:07 th1988

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.

randym avatar Oct 12 '13 06:10 randym