Re: Re: Trouble with Calc

2017-05-17 Thread Bill Dillinger
Thanks to all who responded! I now have an .ods file I can work with. After I learned to edit the tabs out of my original .csv file I got a good result. Now it seems that when I reported that leading blanks in numeric fields were causing me a problem I was mistaken, it was the tabs. Brian's su

Re: Trouble with Calc

2017-05-15 Thread Alan Pearce
t, if anything, I did differently. Regards, Alan. Sent from Samsung tablet Original message From: Bill Dillinger Date:15/05/2017 15:21 (GMT+00:00) To: mar...@groenescheij.com,users@openoffice.apache.org,Brian Barker Subject: Re: Trouble with Calc Hello, I have received he

Re: Trouble with Calc

2017-05-15 Thread Brian Barker
At 10:21 15/05/2017 -0400, Bill Dillinger wrote: One suggestion was to click the "Detect special numbers" option when opening the file. I did try this and it didn't work. I think it should. The problem is probably the tab characters that you have only now referred to. It was suggested to use

Re: Trouble with Calc

2017-05-15 Thread Rory O'Farrell
On Mon, 15 May 2017 10:21:21 -0400 Bill Dillinger wrote: > Hello, > I have received helpful suggestions from Brian and Martin and very much > appreciate them. Thanks for the help and any additional notes that may > yet come in. I realize now my original message was not completely clear > becau

Re: Trouble with Calc

2017-05-15 Thread Bill Dillinger
Hello, I have received helpful suggestions from Brian and Martin and very much appreciate them. Thanks for the help and any additional notes that may yet come in. I realize now my original message was not completely clear because I did not fully understand my problem. As was suggested by both

Re: Trouble with Calc

2017-05-15 Thread Martin Groenescheij
On 14/05/17 5:22 AM, Bill Dillinger wrote: Hello, I can't seem to manage Calc with even a simple problem. I am trying to read and work with a spreadsheet made from a .csv file with columns of numbers. I really have tried to read and work with the HELP file. First I could not add 4 numbers b

Trouble with Calc

2017-05-13 Thread Bill Dillinger
Hello, I can't seem to manage Calc with even a simple problem. I am trying to read and work with a spreadsheet made from a .csv file with columns of numbers. I really have tried to read and work with the HELP file. First I could not add 4 numbers but with lots of tries found that it seemed to