Re: Re: Trouble with Calc

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

Re: Trouble with Calc

, if anything, I did differently. Regards, Alan. Sent from Samsung tablet Original message From: Bill Dillinger <cjb...@his.com> Date:15/05/2017 15:21 (GMT+00:00) To: mar...@groenescheij.com,users@openoffice.apache.org,Brian Barker <b.m.bar...@btinternet.com> Subject:

Re: Trouble with Calc

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

Re: Trouble with Calc

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

Re: Trouble with Calc

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

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