Re: [PLUG] LO Calc formatting question
On Tue, 5 Jun 2018, Dick Steffens wrote: You're welcome. I remember that I found that trick, but I don't remember how I found it. So, I'm glad it works for you, but I can't explain why. Dick, Seeing that my LO formatting did nothing I used emacs (as I should have in the first place) and quickly cleaned up the file for insertion in a postgres database. I appreciate your suggestion. Best regards, Rich ___ PLUG mailing list PLUG@pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug
Re: [PLUG] LO Calc formatting question
On 06/05/2018 03:46 PM, Rich Shepard wrote: On Tue, 5 Jun 2018, Dick Steffens wrote: 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. Dick, No, I didn't. I selected a new spreadsheet and opened the .csv file. No importing of data. I selected all text columns and formatted them as text, the selected all numeric columns and selected the floating point numeric format. When I saved it I checked the box to quote text fields and specified double quotation marks. Thanks, You're welcome. I remember that I found that trick, but I don't remember how I found it. So, I'm glad it works for you, but I can't explain why. :-) -- Regards, Dick Steffens ___ PLUG mailing list PLUG@pdxlinux.org http://lists.pdxlinux.org/mailman/listinfo/plug
Re: [PLUG] LO Calc formatting question
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