Re: Trouble with Calc

2017-05-15 Thread Alan Pearce
Hi Bill, I had a similar problem with CSV i.e. with the apostrophie turning the numbers to text. I simply downloaded the file again and it came in correctly without the apostrophie and the numbers behaved as numbers, not text. I had never had this pronlem before and I don't know what, if anythin

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: How to alphabetize a simple list of words?

2017-05-15 Thread Regina Henschel
Hi John, I assume, that the words are one below the other, each in its own paragraph. Then select the entire list and use menu Tools > Sort… Kind regards Regina johncasey...@gmail.com schrieb: Please respond noting how I can alphabetize a simple list of words in OpenOffice Writer? The only

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

Re: How to alphabetize a simple list of words?

2017-05-15 Thread Martin Groenescheij
On 15/05/17 12:59 PM, johncasey...@gmail.com wrote: Please respond noting how I can alphabetize a simple list of words in OpenOffice Writer? The only thing I can compare it to is the A/Z looking symbol on the toolbar of MS Word that allows a person to sort from A-Z or Z-A. It may be a filter