Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I often need to open pipe delimited .txt files in LibreOffice Calc. However, once I have Calc running, if I do File > Open and select a spreadsheet with the extension .txt, it opens it in Writer instead.

Is there a way to tell the file I'm trying to open using whatever program instead of trying to pick which one to use?

Barring that, is there a way I tell it to always use Calc for .txt files (when I open them from the open dialog in Calc)? I still want them to open in GEdit like they currently do if I double click them from Thunar.

share|improve this question
up vote 1 down vote accepted

I finally got the functionality I need by removing LibreOffice Writer all together. Now when I open a text file, it pops up a "what kind of file" is this dialog.

share|improve this answer

Select "Text CSV" in the file type list in the open dialog, and it should open in Calc.

share|improve this answer
by default is an important part of this question. I do know how to manually override it. – David Oneill Apr 5 '12 at 21:41
Is there a way to tell LibreOffice to do that by default when opening a txt file? – David Oneill Apr 5 '12 at 21:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.