I spend last 30 minutes reading all posts about this issue, some dating from 2014 but I cannot find a solution.
How do I save the csv import preferences so that libreoffice calc doesn’t ask me everytime which format is my csv.
This issue would not be that bad if the prompt would not show up hidden behind other windows, if you have another csv already open. That way at least, I would just have to type enter and be done, but the prompt doesn’t show on top of my windows (this is on linux).
Thank you in advance.
EDIT: it’s a long lasting issue which seems unresolved as of today.
For the record:
Why can’t we save the settings for a file type?
I’d like csv’s to always be one way without the dialog all the time.
This should not be marked resolved. The program behaviour ignores a significant use case.
The use case ignored is where an office has a program which generates many csv files per day, which need to be opened in Calc. I work in such an office now and have at another in the past.
For such a use case, Calc is seriously deficient, particularly compared with Excel. The deficiency is worse than Knocks has described, partly because of another closely related bug/misfeature, which I am about to report.
This is a common issue. Often I have many windows open (multiple Writer’s multiple Calc’s) and then when opening a CSV file, the “import” dialog appears, but only in one window and sometimes it can take some time to find the right one. Trying to import another CSV while one import dialog is open does not work.
This seems like a minor issue, but when you open .csv files one after another all day, this makes Calc pretty unusable.
I need to do recurring import of text files with the same format into Calc, but every time I got to specify their fields format; is there a way to get them saved and reusable?
I came to this site after looking for a way to disable the ‘text import’ dialogue that pops up EVERY TIME I open a CSV file in Calc.
I do not generally use office/productivity software, and I use spreadsheets even less but even for me, this annoyance is enough to make me not want to use the software.
I’m looking to a way to “save” the setting I do for some csv file
I have a few number of csv file which are used by some process, and I need to edit them several time per day
There is more than that, and these topics have thousands of views, more than any other question here.
When making a user interface, reacting to users’ feedback is the most important skill one must have.
Now, libreoffice is free, allright. But it is not like this software is being used by a couple dudes somewhere: libreoffice is shipped in with linux. Linux !!
This is millions of people, which are affected by these limitations.
I know how annoying it can be to answer to users’ feedback. But here; the fault is not from the users, because the issue is an important one (opening tables with calc) and because adding the option to auto-load the csv files would take literally 2 hours to program, maximum. And, it’s been more than a decade…
Finally, here are some of the answers from others users and devs which were given to the requests I have quoted above:
I hate to sound simplistic, but I would suggest you ask yourself why you are opening multiple CSV files in Calc in the first place.
It remembers the last choice. so Enter (OK) is enough.
Never use csv files. They only save one sheet, don’t save formulae or formatting - they only save names and numbers.
Always get the data into Calc and save as a .ods file.
Thanks for the devs for making this program. But, Hence the uncompetence term. please, give a bit of care to this feedback.