Bug 126932 - File opened from Calc opens in Writer instead.
Summary: File opened from Calc opens in Writer instead.
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.3.2 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-14 20:58 UTC by Chris
Modified: 2019-08-16 07:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Demonstration of a file that triggers the bug (376 bytes, text/plain)
2019-08-14 20:59 UTC, Chris
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Chris 2019-08-14 20:58:26 UTC
Description:
Trying to open an IIF file in LibreOffice Calc. This is a column-based, tab-separated file format used by financial software such as QuickBooks. When I open the file in Calc, it just assumes that the file is text, and that I must want it opened in Writer.


Steps to Reproduce:
1. Create an IIF file in another application. (A sample file is attached to this bug report.)
2. Open Calc.
3. Select File/Open in Calc, and choose the IIF file created in step 1.


Actual Results:
Writer starts, and opens the file as though it were a text file.


Expected Results:
The file should open in Calc, with the text input filter options dialog.


Reproducible: Always


User Profile Reset: Yes



Additional Info:
Renaming the file to have a "csv" extension causes Calc to open the file properly.

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
Comment 1 Chris 2019-08-14 20:59:48 UTC
Created attachment 153395 [details]
Demonstration of a file that triggers the bug
Comment 2 m_a_riosv 2019-08-14 22:10:07 UTC
LibreOffice always test to find what kind of file is before take in account the extension. In this case nothing in the file and the extension it's not a recognized extension for LibreOffice.

To open with calc, select the file with a single click and the file type like 'Text CSV' and then open it.

The Document Foundation, behind LibreOffice is member of Document Liberation Project https://www.documentfoundation.org/

IMO not a bug, please if you are not agree, reopen it.
Comment 3 Chris 2019-08-15 13:51:21 UTC
Selecting "Text CSV" from the file type box hides IIF files, so you have to be careful to select the file *first*. Not to mention, it only works for the Windows version; the Linux version has a different Open dialog that doesn't keep the selected file when you change the file type.

I understand that having a heuristic file type detection would help in the majority of cases. But there are always going to be edge cases, where trying to make the software easy to use actually makes it more difficult. So there needs to be, at the very least, a way to easily override this type of detection, and make the program just do what I tell it to, rather than what it *thinks* I actually want to do.
Comment 4 m_a_riosv 2019-08-15 15:27:56 UTC
First of all, you can't set your reports as NEW, someone else must confirm and do it.

In any case, the program not complying with your desires it's not a bug.

You can select first the type and then introduce *.iif to find all that kind of files.

Maybe the original program can generate the files with other extension.

Rename the extension of the files after generated prior to be loaded.

If you always permanent link from calc file to a .iif file with the same name use Menu/Sheet/[Insert Link from file] or [Link to external data]. After you can change the linked file Menu/Edit/Link to external files - Modify

Or you can kindly ask for an enhancement (second box of 'Importance') to add that extension for CSV search. Instead of change this, please better report a new one.