[PLUG] LO Calc formatting question
Dick Steffens
dick at dicksteffens.com
Tue Jun 5 22:30:54 UTC 2018
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
More information about the PLUG
mailing list