[Libreoffice-bugs] [Bug 35639] "Insert > Sheet From file" cannot open text files without .txt extension on filename

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=35639

--- Comment #4 from delcypher at gmail.com 2011-03-25 02:56:27 PDT ---
Here is some additional information:
OS: Arch Linux (Linux 2.6.37-ARCH #1 SMP PREEMPT) 32-bit
Desktop: Xfce 4.8.0
LibreOffice version: LibreOffice 3.3.2 OOO330m19 (Build:202) 3.3.2.2 ArchLinux
build-1
Arch Linux package: extra/libreoffice
glibc Locale: en-gb
Document Language: English (UK)
User Interface: English (USA)

See attachment ("Screenshots and the offending text file") for screenshots (png
files) and ASCII text file "125-125-times.log"

Steps to reproduce (more thorough)
1. Start LibreOffice Calc through desktop's program menu (see screenshot-1)
2. You will now be in a blank spreadsheet document in LibreOffice Calc. Now
click the following menu "Insert -> Sheet From file" (see screenshot-2)
3. You will be presented with a file browser. Select the file
"125-125-times.log" and press the "Open" button (see screenshot-3).
4. You will now see an "Insert Sheet" window. Notice that the white box beneath
the "From File" radio button is blank, i.e. nothing was imported. Consequently
the "Ok" button is greyed out (see screenshot-4).

If now the text file is renamed to "125-125-times.log.txt" and steps 1 & 2 are
repeated then do.
5. You will be presented with a file browser. Select the file
"125-125-times.log.txt" and press the "Open" button (see screenshot-5).
6. You Will now see a "Text import" window (see screenshot-6). Press the "Ok"
button.
7. You will now see an "Insert Sheet" Window (see screenshot-7). Notice how the
whitebox below the "From File" radio button is no longer blank and that the
"Ok" button is no longer greyed out.

-- Why the behaviour is unexpected.
LibreOffice should be able to recognise that the file "125-125-times.log" is an
ASCII text file and do a "Text import". At the very least it should inform the
user that it doesn't recognise the file "125-125-times.log" instead of just of
doing absolutely nothing!

-- how I created your sample.log
The file is produced by a bash shell script, the details are not important. The
ASCII text file is a UNIX text file and NOT a 
DOS text file.

@Rainer Bielefeld 
I've tried your test kit.
source.csv -> "Text Import" window appears and imports successfully.

source.log -> No "Text Import" window appears and I'm left with the "Insert
Sheet" window as in screenshot-4. So Importing fails!

source.ods -> "Insert Sheet" window shows the sheets of the file "source.ods"
and imports them successfully.

source.sxc -> "Insert Sheet" window shows the sheets of the file "source.xsc"
and imports them successfully.

source.txt -> "Text Import" window appears and imports successfully.

source.xls -> "Insert Sheet" window shows the sheets of the file "source.xls"
and imports them successfully.

sourceiwthblankseparator.log -> No "Text Import" window appears and I'm left
with the "Insert Sheet" window as in screenshot-4. So importing fails!

sourcewithreals.csv -> "Text Import" window appears and imports successfully.

sourcewithreals.log -> No "Text Import" window appears and I'm left with the
"Insert Sheet" window as in screenshot-4. So importing fails!

sourcewithreal.ods -> "Insert Sheet" window shows the sheets of the file
"source.xls" and imports them successfully.

So as you can see every file with a ".log" file extension failed. This isn't
very good behaviour.

Thanks.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.