Geek Answers Handbook

Change default import options for import text in Gnumeric

I use the Gnumeric table to import, update, and then export csv files limited to channel "|" delimiter. Gnumeric by default saves files as xml via the .gnumeric extension. Therefore, the user needs to import files through Data> Get External Data> Import Text file. Then the user must go to the wizard to select the import options. These default settings are not remembered the next time a user logs on to a file. This process is supposed to be similar for export (via Save As> Text (Configurable), but I have not seen the export wizard.

Is there a way to change the settings of Gnumeric DEFAULT so that it imports / exports CSV files with channel separator and treats all the data as text (not shared)?

+4
source share
2 answers

There is currently no way to do this. The easiest way to implement this feature could be a new plugin.

+1
source

I solved this problem by writing a wrapper script gnumeric.sh that converts - in my case - a comma to a comma (and before that a comma - :: , wrote this to a temporary file and opened this file using gnumeric (csv was obtained from server data saved / opened from the browser)

Turns out I was still facing the same or similar trap because gnumeric does not automatically format dates correctly ... something that could be customized, but not from the command line.

0
source

More articles:


All Articles