[Solved] It always opens the Text Import

Discuss the spreadsheet application
Post Reply
hwrdmltn
Posts: 2
Joined: Sun Jun 23, 2019 5:32 pm

[Solved] It always opens the Text Import

Post by hwrdmltn »

So I exported a document from an application to .csv format - every effing time I click on it to open it in OO calc, it goes to the text import dialog. How do I set the file permanently so I don't have to deal with this dialog each and every time I open it?
Thanks,
Frustrated in Boston
Last edited by Hagar Delest on Mon Jun 24, 2019 8:20 am, edited 1 time in total.
Reason: tagged solved
OpenOffice 2.3.0
User avatar
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: It always opens the Text Import

Post by RoryOF »

Of course it does - it is a text file, and OO needs to know certain information. If you don't want to supply that, Save the file as an .odt .ods file, using /File /Save As, selecting .odt in the file type dropdown.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
hwrdmltn
Posts: 2
Joined: Sun Jun 23, 2019 5:32 pm

Re: It always opens the Text Import

Post by hwrdmltn »

OMG - Something so simple but soooo obscure - thanks for that, my bad for not catching that - CSV (C)omma (S)eparated (V)alues would indeed be a text file, DUH!
One note, my drop down did not offer .odt, but it did offer .ods, which produced the desired result anyway, I suspect due to the geriatrics of my version - I have the Jurassic Classic version lol...

"Hear ye hear ye, All is well!" the Boston town crier calls out as nighttime ensues.....

Peace! Out!
OpenOffice 2.3.0
User avatar
robleyd
Moderator
Posts: 5082
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: It always opens the Text Import

Post by robleyd »

my drop down did not offer .odt, but it did offer .ods,
I'm pretty sure that RoryOF meant to type .ods - the format for saving spreadsheets - rather than .odt which is the format in which Writer documents are saved.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
User avatar
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: It always opens the Text Import

Post by RoryOF »

@roblyed: thank you - corrected in my original posting.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply