<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - There's no way to override the heuristic file type determination."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126955">126955</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>There's no way to override the heuristic file type determination.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>ChristopherLeeUS@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
When choosing a file to open, LibreOffice uses a heuristic to guess the file
type, and choose the correct program. In most cases, it does a pretty good job
of deciding which program (Calc, Writer, etc.) to use to read the file.
However, there are cases where the heuristic fails, and the wrong program is
opened. For instance, IIF is a common format of file for data exchange between
accounting software (particularly QuickBooks). It is a grid-based,
tab-delimited file format that is best edited with a spreadsheet application,
such as Calc. However, trying to open an IIF file in Calc results in the Writer
application opening the file instead.
Changing the file type to "Text CSV" in the open dialog does cause Calc to
behave properly. However, it also has the side effect of hiding any file that
doesn't have a CSV extension, making it impossible to choose the file. You
either have to remember the name and type it in, or remember to choose the file
before choosing the file type. Also note that LibreOffice on certain Linux
installations don't give you the option of typing the name at all.
The above behavior is correct in most situations, and should remain the
default. But there needs to be an easy way to override the automatic file type
detection, separate from the file extension filter, for edge cases such as
this.
Steps to Reproduce:
1. Open Calc.
2. Choose File/Open.
3. Pick an IIF file.
Actual Results:
The file opens in Writer, with no option to change it.
Expected Results:
There should be some *easy* way to force the file to open in Calc, using the
Text CSV import options.
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 6.1.6.3
Build ID: 6.1.6.3-1.fc29
CPU threads: 4; OS: Linux 5.2; UI render: default; VCL: gtk3;
Locale: en-US (en_US.UTF-8); Calc: group threaded
Version: 6.1.3.2
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 1; OS: Windows 6.1; UI render: default;
Locale: en-US (en_US); Calc: group threaded</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>