Re: [PLUG] LO Calc formatting question

2018-06-05 Thread Rich Shepard
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

Re: [PLUG] LO Calc formatting question

2018-06-05 Thread Dick Steffens
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.

Re: [PLUG] LO Calc formatting question

2018-06-05 Thread Dick Steffens
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