Export: Omniscope Integers being stored as Text in xlsx

Master_Chief · April 1, 2014 4:54AM

Every time I publish the file it formats the integers into text within the EXCEL.

It is very annoying as it requires a manual text to columns in order to fix

paola · April 1, 2014 11:10AM

Please try using Excel direct writer. I tried and integer values were not converted to text.
Do you have tokenised fields, so you have more than value per cell (if you have to use text to columns conversion)?

Master_Chief · April 2, 2014 6:55AM

I deleted the EXCEL sheet and published again and now it is fine. Think it was a corrupt file.

Welcome!

Categories

Ideas Parade

Tagged