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
Created attachment 153395 [details] Demonstration of a file that triggers the bug
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.
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.
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.