In the File->Open file picker, if the "Spreadsheets" file type is selected, it shows CSV files, including .txt CSV files. But if I pick a .txt CSV, it will open in Writer. (.csv ones open in Calc) I would expect the .txt ones to open in Calc, as the filter is "Spreadsheets". (I'm setting version as 3.3.3, because that's the only one I tested.)
Reproduced with LO 3.4.1 (OOO340m1 (Build:101)) Ubuntu 10.04.2 x86 Linux 2.6.32-32-generic Russian UI
NOT Reproducible with "LibreOffice 3.4.1RC1 – WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:101)]" and an own sample. Sample.txt and sample.csv (with identical contents) will both be opened in CALC from file picker (LibO) dialog. OS related? Currently I only see it for Linux and unknown OS Related to or DUP of "Bug 37972 - .xls file with HTML table should be load in Spreadsheet instead of Writer"? @nunojsilva@ist.utl.pt @tester8: Can you please attach a sample document? @nunojsilva@ist.utl.pt Please contribute information concerning your OS in a comment?
Created attachment 48200 [details] Example of CSV file which reproduces the bug. I'm attaching a CSV file I created to test this bug. So far I only tested with LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 With en_US interface (although pt_PT is installed, I'm not using it). OS is Gentoo GNU/Linux, amd64.
As Rainer didn't see it in Windows, I fired up the Windows Virtual Machine I keep around for (sigh) university stuff, and ... first, as a curiosity: the VM has Go-oo installed, so I tried with it, and I could reproduce the bug: OpenOffice.org 3.2.1 OOO320m19 (Build:9505) ooo-build 2010-07-18 ... then I installed LibO 3.4.1 so I could test this, and I was still able to reproduce the bug: LibreOffice 3.4.1 OOO340m1 (Build:101) The VM is running Windows XP (NT 5.1) x86 (that is, 32-bit), with SP3. @Rainer: You selected "Spreadsheets" as the file type? (I ask because the "Text CSV (*.txt;*.csv)" file type option is working, the bug only happens with "Spreadsheets".) I was also able to reproduce this in another Gentoo GNU/Linux amd64 with: LibreOffice 3.3.1 OOO330m19 (Build:8) tag libreoffice-3.3.1.2
[Reproducible] with reporter's and own sample.txt tables and "LibreOffice 3.4.1RC1 – WIN7 Home Premium (64bit) German UI [OOO340m1 (Build:101)]". Problem visible with LibO file open dialog and OS file open dialog. And I am pretty sure that this one is not related to Bug 37972. @ Nuno J. Silva (aka njsg): I'm sorry, my mistake, I understood you wrong in the original report and never rechecked my opinion how to open. In File open dialog / file type picker I selected "TEXT CSV (*.csv, *.txt)", not simply "Spreadsheets" from the first selection group. With file type "Spredsheet" a "sample.csv" will be opened with CALC correctly, but a "sample.txt" with identical contents will be opened with WRITER. Thank you for your endurance! @Kohei: Please feel free to reassign if it’s not your area.
Since all new unconfirmed bugs start in state UNCONFIRMED now and old unconfirmed bugs were moved to NEEDINFO with a explanatory comment, all bugs promoted above those bug states to NEW and later are automatically confirmed making the CONFIRMED whiteboard status redundant. Thus it will be removed.
I fixed this one for 3.6.0.