<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=74580#c51">Comment # 51</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - FILEOPEN: Add option to disable import dialog when opening a CSV file (see comment #13)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=74580">bug 74580</a>
from <span class="vcard"><a class="email" href="mailto:gareth.adamson@gmail.com" title="Gareth <gareth.adamson@gmail.com>"> <span class="fn">Gareth</span></a>
</span></b>
<pre>To set up the workaround described in <a href="show_bug.cgi?id=74580#c47">Comment 47</a> 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:
<a href="https://www.nirsoft.net/utils/file_types_manager.html">https://www.nirsoft.net/utils/file_types_manager.html</a>
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 <a href="show_bug.cgi?id=74580#c47">Comment 47</a> and <a href="show_bug.cgi?id=74580#c49">Comment 49</a></pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>