Re: Text CSV won't open as a Spreadsheet

2017-10-06 Thread Linda Hull
I slept on it. Really really appreciate all of your help! Tried opening a similar file that I had not processed in OpenOffice, it opened as a .CSV in Calc. I pasted the file from OpenOffice to notepad++ saved as filename.txt. Opened in Calc with 'Text CSV (*.txt *.csv)', and it did open in Calc,

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread John Hart
On 10/5/2017 11:33 AM, Linda Hull wrote: IT still isn't working. That's the bottom line for me. I need to be able to go from a text file to a spreadsheet. Pasting it doesn't do the columns right. Linda It's probably not saved as a text file. I'd suggest opening it with a simple editor to find

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread Linda Hull
IT still isn't working. That's the bottom line for me. I need to be able to go from a text file to a spreadsheet. Pasting it doesn't do the columns right. Linda On Thu, Oct 5, 2017 at 10:30 AM, Linda Hull wrote: > I have Apache Open Office 4.1.2 on Windows 7. > > Yesterday I made several sprea

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread Linda Hull
I have Apache Open Office 4.1.2 on Windows 7. Yesterday I made several spreadsheets, today it won't. Linda On Thu, Oct 5, 2017 at 8:58 AM, Brian Barker wrote: > At 08:07 05/10/2017 -0400, Linda Hull wrote: > >> I feel like I'm in Through-the-Looking-Glass Land. >> > > No, I think you are in th

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread Brian Barker
At 08:07 05/10/2017 -0400, Linda Hull wrote: I feel like I'm in Through-the-Looking-Glass Land. No, I think you are in the real world and I am somewhat distracting you. Apologies that my previous reply was not entirely accurate. You know I do this regularly to manage channel access lists for

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread Dave C
> 5 October is Computers-are-built-to-confuse-you Day. > > I trust this helps. > > Brian Barker In Norwegian (I think it was Norwegian) “computer” translates to “number-witch”. Your helpful tip for the day. (C; Dave - To unsu

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread Linda Hull
Brian, I feel like I'm in Through-the-Looking-Glass Land. You know I do this regularly to manage channel access lists for IRC. It's just not working. I have NEVER had to modify the file name before. I don't think I converted the files to .doc, Writer holds them as .odt. What I have always be

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread Brian Barker
At 05:03 05/10/2017 -0400, Linda Hull wrote: I saved my file as filename.txt in Apache OpenOffice Writer. Trying to open it as .csv in a spreadsheet, to work on it further. Er, your document file cannot have the two different extensions .txt and .csv simultaneously. You mean you want to open

Re: Text CSV won't open as a Spreadsheet

2017-10-05 Thread Martin Groenescheij
Two options: 1. Open a new spreadsheet and insert the txt file. 2. Rename the txt file extension to csv Sent from my mobile device. > On 5 Oct 2017, at 11:03 am, Linda Hull wrote: > > I saved my file as filename.txt in Apache OpenOffice Writer. > > Trying to open it as .csv in a spreadsheet,

Text CSV won't open as a Spreadsheet

2017-10-05 Thread Linda Hull
I saved my file as filename.txt in Apache OpenOffice Writer. Trying to open it as .csv in a spreadsheet, to work on it further. I click Open, and insert filename.txt, and click on .txt CSV in the drop down. It keeps opening as Writer, not Calc. Is this a bug or did I forget a step or what do I