As far as I can see, it is impossible to import spread sheets from a text file if the file has not a ".csv" extention.
I consider this a bug because plain text is not a format specific to LibreOffice. Enforcing a certain file name conflicts with other application which either create or use such files.
For example, I have many hundereds of files with ".PRN" extention, (which I did not choose and which I need to keep to work with other software), and the only way I found to open them in Calc is to create a copy with ".csv" extention.
What I wish is to be able to select *any* file, irrespective of its name and extention, and to have the text import dialog shown.
if you select 'File/Open'
and you select a '.txt' or a '.prn' file.
The Text Import wizard is shown.
This is not true, at least in my installation.
If I select File->Open, and then chose e.g. the .prn file, it is opened in Writer instead of Calc.
I think the .prn file is 'recognized' by LO as a doc, which should not happen if it only contains text.
If i rename an odt-file (Writer) to have the extension .prn, than it is also openend by Writer, but a testfile i created meself (with Notepad), opens in Calc.
Is it possible to attach the .prn file here?
(In reply to comment #2)
> If I select File->Open, and then chose e.g. the .prn file, it is opened in
> Writer instead of Calc.
Even if you do it from inside Calc?
Yes, it happens even if I open the file directly from calc. This is in fact
the part that I consider a problem, since opening a file from a specific
application should not open it in another application, I believe.
After some more testing to create a minimal example, I figured out that the
file contained a single latin-1 diacritical character (0x81), in a text
field, between quotes. Replacing this byte with a regular ASCII code using
a hex editor leads to the expected behaviour.
I guess UTF8 was expected so that the file seemed "binary", but even then
I'd prefer to have the file opened in Calc with this character looking
"silly" than having it opened in Writer (Writer, BTW, simply removes the
On Sun, Jun 15, 2014 at 10:29 AM, <email@example.com> wrote:
> Maxim Monastirsky <firstname.lastname@example.org> changed bug 80016
> What Removed Added CC email@example.com
> *Comment # 4 <https://bugs.freedesktop.org/show_bug.cgi?id=80016#c4> on
> bug 80016 <https://bugs.freedesktop.org/show_bug.cgi?id=80016> from Maxim
> Monastirsky <firstname.lastname@example.org> *
> (In reply to comment #2 <https://bugs.freedesktop.org/show_bug.cgi?id=80016#c2>)> If I select File->Open, and then chose e.g. the .prn file, it is opened in
> > Writer instead of Calc.
> Even if you do it from inside Calc?
> You are receiving this mail because:
> - You reported the bug.
Created attachment 101166 [details]
@PN: Thanks for the info. I'm attaching a test-case for this problem.
It opens in Writer because it's detected by libwpd as a WordPerfect 1 file. See Bug 78731 for a similar issue. At Bug 78731 comment 6 there is a comment from Fridrich Strba (the developer of libwpd). It's about WordPerfect 4.2, but probably the same applies to WordPerfect 1.
Forgot to close this one (the reason is the same as in Bug 78731).
*** Bug 82764 has been marked as a duplicate of this bug. ***
*** Bug 85022 has been marked as a duplicate of this bug. ***
How is it 'wontfix'? Why the deeply obsolete and obscure format is allowed to completely screw data interchange people do this day?
*** This bug has been marked as a duplicate of bug 78731 ***
*** Bug 99017 has been marked as a duplicate of this bug. ***