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, but all of my columns are 2.48", 2.96", 2.67", 2.27" - this is A: USER, B usernames, C: ACCESS, D blank.. etc. Why so wide? I'm guessing it picked up formatting from the OO. I don't want to do this, will I need to fix each one manually? It really should open as a CSV file, in appropriate width columns not what it did, this time. USER should be 0.54", usernames 1.03", ACCESS 0.74", etc, all a bit wider than the text that opens in that column, empty columns .55" or something. I have to process the file in OpenOffice, then I want to open it in Calc. What format do I need to save the file in? Linda On Thu, Oct 5, 2017 at 2:52 PM, John Hart <jh...@testra.com> wrote: > 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 out. > > jrh > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org > For additional commands, e-mail: users-h...@openoffice.apache.org > >
