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 been doing is: Look up the filename in 'open'. Open the dropdown, "All files (*.*)", scroll down to where it says: "Text CSV (*.csv *.txt)", click that and it should show me a "do you really want to open all this stuff in a spreadsheet?" .. click yes. Get Calc. ONLY IT'S NOT WORKING! I'll be happy to send you any number of files privately, but I'm wondering if something is bugged in my Apache OpenOffice? I need it. Linda On Thu, Oct 5, 2017 at 6:55 AM, Brian Barker <b.m.bar...@btinternet.com> wrote: > 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 it "as CSV", not "as .csv", > I think. > > I click Open, and insert filename.txt, and click on .txt CSV in the drop >> down. >> > > That drop-down menu has no effect on how the document file is handled. All > it does is restrict the list of files in the current folder that are > displayed in the panel above. In other words, once you have got the > required file name in the "File name" box, it has no effect at all. > > It keeps opening as Writer, not Calc. >> > > It will. OpenOffice selects the appropriate input filter depending on the > extension to the file name and the actual contents of the file. Your file > name extension .txt tells it you want this considered as a text file, so it > thinks you will want to edit it as that. > > Is this a bug or did I forget a step or what do I need to do? >> > > Change the file name from filename.txt to filename.csv. You can do this > outside OpenOffice, in your operating system, of course. Then open it in > OpenOffice. Voilà! > > I've tried opening a similar file.txt made in notepad++, it's still Writer >> not Calc. >> > > That would fit the facts. > > I believe this just started today, and that I opened similar files with >> this technique yesterday. >> > > 5 October is Computers-are-built-to-confuse-you Day. > > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
