[PLUG] LO Calc formatting question

Rich Shepard rshepard at appl-ecosys.com
Tue Jun 5 15:24:24 PDT 2018


   Hope to find an answer here rather than joining the LO mail list.

   Running libreoffice-6.0.4.

   I have a .csv file of precipitation data with 113,500+ rows and loaded it
in LO Calc to format columns. Looking at the modified .csv file I see that
the float values are still in double quotes despite being specified as
numeric.

   Is this a result of not saving the file as .ods before formatting and then
re-saving as a .csv file? Or is it that LO ignores the option of quoting
text only?

Thoughts?

Rich


More information about the PLUG mailing list