Ask Your Question
0

How to generate Calc tab delimited output?

asked 2015-09-03 18:49:19 +0100

NickSteel gravatar image

updated 2015-09-04 11:51:53 +0100

Alex Kemp gravatar image

I use MS Excel 2007 to produce a tab delimited output file. Which settings should I use for Calc to do this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
2

answered 2015-09-04 10:30:34 +0100

Regina gravatar image

Use File > Save a Copy.
Goto the place, where you want to save the file.
Choose the file type Text CSV (.csv) form the drop down list.
Uncheck Automatic file name extension and enter the file name including the correct filename extension. CheckEdit filter settings. Click Save. Now you get a dialog for the settings.
In the drop-down list field delimiter select the item {Tab}.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-09-03 18:49:19 +0100

Seen: 12,045 times

Last updated: Sep 04 '15