Bug 38310 - FILEOPEN .txt files by default in Calc
Summary: FILEOPEN .txt files by default in Calc
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected)
3.4.0 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
: 41707 (view as bug list)
Depends on:
Reported: 2011-06-14 11:33 UTC by 12o
Modified: 2012-08-21 11:55 UTC (History)
9 users (show)

See Also:
Crash report or crash signature:

test text file (3.48 KB, text/plain)
2011-11-12 12:39 UTC, NoOp

Note You need to log in before you can comment on or make changes to this bug.
Description 12o 2011-06-14 11:33:19 UTC
Text files (.txt) created using Notepad.exe in Windows or using Nano in Linux seem to open in LibreOffice Calc by default; either when opened from the command line "> libreoffice filename.txt" or using the Open menu item in LibreOffice. I am presented with an import box that requests Calc-related information (e.g. delimiter usage). No matter what options are selected, Calc imports the file automatically with one word per cell.

Steps to replicate:
1) Create a new file in MS Windows or using 'nano' in Linux
2) Write multiple paragraphs of text or copy/paste text into the editor
3) Save file as .txt
4) Open file in Linux using LibreOffice
5) OpenOffice automatically imports into Calc

Once the file is created with the .txt extension, use the cp command to copy to a new file using the .odt extension:

> cp whatever.txt whatever.odt

and open the file. LibreOffice opens the text file in Writer correctly.

Reference information:
Arch Linux 2.6.38-ARCH #1 x86_64
LibreOffice 3.4.0 OOO340m1(Build:12)
jdk 6u25-1
Comment 1 tester8 2011-06-16 13:52:17 UTC
NOT reproduced with

Ubuntu 10.04.2 x86
LO 3.4

libreoffice3.4 --writer file.txt

Arch or x86_64 specific?
Comment 2 NoOp 2011-11-12 12:38:16 UTC
Reproducable in LO 3.4.4 final (linux - deb builds):
LibreOffice 3.4.4 
OOO340m1 (Build:402)
Defaults to opening the text file in Calc.

In LO 3.3.4 (linux - deb builds):
LibreOffice 3.3.4 
OOO330m19 (Build:401)
tag libreoffice-
Properly opens the text file in Writer.
Comment 3 NoOp 2011-11-12 12:39:03 UTC
Created attachment 53465 [details]
test text file
Comment 4 Cor Nouws 2011-11-18 14:22:17 UTC
Testing with 3.4.3 and 3.4.4

when I create a txt file in gedit, Unix/Linux line end, there is no problem.

When I open an old text file from Windows Notepad, I have to select file format "Text coded Witer/Web  - txt".
Brings up a dialog to selct text encoding and line end, but opens in Writer.
Comment 5 Björn Michaelsen 2011-12-23 12:28:52 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 6 tester8 2011-12-29 14:46:06 UTC
LOdev 3.5.0beta2 
Ubuntu 10.04.3 x86
Linux 2.6.32-37-generic Russian UI

Still NOT reproduced. Can anyone test with Arch?
Comment 7 sasha.libreoffice 2012-01-26 03:22:12 UTC
Linux specific bug
reproduced in LibO 3.3.4, 3.5.0 beta 2 and 3.6.0 master on Fedora 64 bit
with text from attachment (from other text not reproducible)
Comment 8 sasha.libreoffice 2012-04-12 03:18:34 UTC
*** Bug 41707 has been marked as a duplicate of this bug. ***
Comment 9 Joel Madero 2012-08-20 22:33:19 UTC
I've added Erik to the list to see if he can take a look at this one since he knows quite a bit about the code relating to importing txt/csv files.
Comment 10 Rainer Bielefeld Retired 2012-08-21 04:10:42 UTC
I doubt that there is a narrow relation, but may be this one can be handled together with "Bug 53570 - FILEOPEN unknown file type brings up Spreadsheet CSV import dialog instead of filter list".
Comment 11 sasha.libreoffice 2012-08-21 06:12:18 UTC
in reply to comment 9 : hi is Eike
Comment 12 Joel Madero 2012-08-21 06:31:38 UTC
my mistake. thanks for the correction
Comment 13 Eike Rathke 2012-08-21 10:57:27 UTC
I can reproduce in 3.4.5 and 3.5.5, but not anymore in current 3-7 master or 3.6.0. There have been various changes in filter detection, I'm closing this bug as 'worksforme'.
Comment 14 Rainer Bielefeld Retired 2012-08-21 11:55:28 UTC
At least there is some progress. Due to my own test results With Master and  with "LibreOffice  German UI/Locale [Build-ID:  4db6344] on German WIN7 Home Premium (64bit) a textdocument.txt will be opened in Writer except I try from Calc.

That's some progress, even might be intended (because often useful).

But I would like to be able to force LibO to open such plain text contents documents with the application I want. So, for example, I could use Writer as a .svt source text editor. I will submit an enhancement request for this problem later.