Text Import Window suppression when importing CSV Data in LibreOffice Calc

4 replies [Last post]
josephfournier
Offline
Last seen: 2 years 42 weeks ago
Title:
Joined: 8 Aug 2013
Posts: 1
Hi,

In LibreOffice, when one imports a .CSV File within Calc, one obtains a Dialog named “Text Import”, in which one can select several options, including the “Separated By” Option (where one could select “comma” for instance). It appears that the Software does not allow one to suppress the display of this Window, and set the “Comma” option as the default one (similar to what is done in Excel). Thus, how could I set the option to “comma” and suppress the Dialog in code or in any other way?

Thank you.

Regards,

Joseph

oweng
oweng's picture
Offline
Last seen: 5 days 10 hours ago
Title: ==Moderator==
Joined: 26 Jan 2012
Posts: 3281
behaviour changed in v3.5
This behaviour changed in the v3.5 series (from memory). It is now the only method of importing CSV files. I had a brief try at converting a CSV to ODS via headless mode but could not get it to work as expected. There are also problems with locale determination for headless mode (bug FDO#36313).
nbs
Offline
Last seen: 2 years 8 weeks ago
Title:
Joined: 3 Apr 2014
Posts: 1
Still no option?
I’m using 4.1.4.2. I have a calc worksheet that links to a large number of CVS files. There appears to still be no way of either specifying default text import settings, or having it just remember what setting I chose for each particular file. Any time I open the file, or get it to update the linked data, it gives me this dialog for every single file (~50 of them) that it is updating. This essentially makes Libre Calc unusable for this type of simple application. Is there still no fix for this?
oweng
oweng's picture
Offline
Last seen: 5 days 10 hours ago
Title: ==Moderator==
Joined: 26 Jan 2012
Posts: 3281
how are the links created?
nbs wrote:
I have a calc worksheet that links to a large number of CVS files.
How are you creating these links? The Insert > Link to External Data… facility is expressly designed to only work with HTML tables. CSV is not supported. The enhancement request to get this facility extended to support CSV is FDO#35040.
madymax
Offline
Last seen: 3 days 7 hours ago
Title:
Joined: 27 May 2016
Posts: 1
In LibreOffice, when one
In LibreOffice, when one imports a .CSV File within Calc, one obtains a Dialog named “Text Import”, in which one can select several options, including the “Separated By” Option (where one could select “comma” for instance). It appears that the Software does not allow one to suppress the display of this Window, and set the “Comma” option as the default one (similar to what is done in Excel).

Cute relationship quotes

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.