[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 bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 13 02:30:19 UTC 2019


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

--- Comment #51 from Gareth <gareth.adamson at gmail.com> ---
To set up the workaround described in Comment 47 so that it works in Windows,
you need to edit the file association. Windows makes this unreasonably
difficult to do, but luckily there is a freeware tool, Nirsoft's FileTypeMan,
which you can download at:

https://www.nirsoft.net/utils/file_types_manager.html

First, make sure CSVs are already opened with LibreOffice. If not, open a CSV
using "Open with..." and "Always use this app" to choose LibreOffice.

Unzip and run FileTypeMan, and navigate to the CSV extension. I recommend
maximising the window for ease of use.

In the top half of window, click on the entry for CSV.
There should now be one line in the bottom half, called "open" with a command
line pointing to LibreOffice.
Select this line and choose Edit Selected Action (f3).
Now edit the command line, by adding between the app name and "%1", the
following parameter:

--infilter="Text - txt - csv (StarCalc)":44,34,0,1

with a space either side, so in the end the command line should look like:

"C:\Program Files\LibreOffice\program\scalc.exe"  --infilter="Text - txt - csv
(StarCalc)":44,34,0,1 "%1"

(May vary slightly depending where LibreOffice is on your PC.)

Click OK, and try double clicking a few CSVs. If it worked, you'll see no more
pesky dialogs.

For more details see Comment 47 and Comment 49

-- 
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/20191113/519dd74c/attachment.html>


More information about the Libreoffice-bugs mailing list