Export selection to text in Calc

Well, it’s so dumb and simple that that it’s strange I am asking this here. How can I export selection to text in Calc?

Yes, simply to plain text.

Under selection I mean column, or row, or range or whatever. OK, let it be CSV for the sake of simplification.

I researched all forums, tried plenty of options but without success. I tried:

  • Export
  • Export to
  • Save
  • Save as
  • Format->Range to print

and etc.


It’s so funny that honoured open-source lacks such simple things which can be done in Word as easy as pissing.

Select the range, copy and paste it into Notepad in windows or gedit on linux