[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