[Libreoffice-bugs] [Bug 74580] FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=74580

--- Comment #47 from John <john_orr at yahoo.com> ---
+1 for addressing this.  I too have to open lots of CSV files, and am trying to
transition from Windows/Excel to Ubuntu/LO.  I was happier running a Windows VM
just to keep using Excel, due to this issue.

Thanks to a few posts on the subject however, I've set up a custom csv opening
option for when I double-click on csv files in a file-browser, which appears to
work for me.  In case it helps anyone else:

# cat ~/.local/share/applications/defaults.list 
[Default Applications]
application/csv=libreoffice-calc_csv.desktop
text/csv=libreoffice-calc_csv.desktop

And added an infilter to the Exec line:

# cat ~/.local/share/applications/libreoffice-calc_csv.desktop | grep -v '#' |
head -n7
[Desktop Entry]
Version=1.0
Terminal=false
Icon=libreoffice-calc
Type=Application
Categories=Office;Spreadsheet;
Exec=libreoffice --calc --infilter="Text - txt - csv (StarCalc)":44,34,0,1 %U

I think I needed to delete the application/csv and text/csv entries in
/usr/share/applications/defaults.list - time will tell if they get added back
in again automatically (but dpkg-reconfigure didn't).

As for many others, for me, Excel gets this right - make the common use case
quick and easy (open with default, or saved, options - as configured by the
user) and make the rare use case possible (support opening with options via the
File|Open dialog).

It's a shame that only tech nerds can fix this deficiency for now, apparently.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191022/13143ad0/attachment.html>