exporting to xls,ods broblems with exporting integer columns
Greetings.
Am using Fastreport 4.12.1 version
when exporting integer columns to ods format, cell values contain opening quote - apostrophe, meaning cell contains unknown type value. which is, well, odd. [img]style_emoticons/<#EMO_DIR#>/unsure.gif" style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" /> Odd, Because its a common problem exporting data to xls for years, yet still not fixed. I presume that data to cell is saved as a variant type, is there anyway to force it to store as a text type? maybe a formating string not documented yet ... . Column contains simple EAN13 barcode number, may contain letters too, exported report may be used in data exchange, so its vital to have those cell values as a text type. Thanks for any help.[/img]
Am using Fastreport 4.12.1 version
when exporting integer columns to ods format, cell values contain opening quote - apostrophe, meaning cell contains unknown type value. which is, well, odd. [img]style_emoticons/<#EMO_DIR#>/unsure.gif" style="vertical-align:middle" emoid=":unsure:" border="0" alt="unsure.gif" /> Odd, Because its a common problem exporting data to xls for years, yet still not fixed. I presume that data to cell is saved as a variant type, is there anyway to force it to store as a text type? maybe a formating string not documented yet ... . Column contains simple EAN13 barcode number, may contain letters too, exported report may be used in data exchange, so its vital to have those cell values as a text type. Thanks for any help.[/img]
Comments