On 06/05/2018 03:24 PM, Rich Shepard wrote:
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?
Did you try, in the Text Import options, Other Options, [x] Quoted field
as text along with [x] detect special numbers? I have to do this when I
import .csv data from the credit union.
--
Regards,
Dick Steffens
_______________________________________________
PLUG mailing list
PLUG@pdxlinux.org
http://lists.pdxlinux.org/mailman/listinfo/plug