Text Import Window suppression when importing CSV Data in LibreOffice Calc
Thu, 08 Aug 2013 - 10:58 AM
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
Sat, 10 Aug 2013 - 5:21 AM
#1
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).
Thu, 03 Apr 2014 - 12:43 PM
#2
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?
Fri, 04 Apr 2014 - 3:53 AM
#3
how are the links created?
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.
Fri, 27 May 2016 - 2:28 AM
#4
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).