| View previous topic :: View next topic |
| Author |
Message |
jmorrow
Blue Pill
Joined: Mar 26, 2007
Posts: 2
|
 Posted: Mon Mar 26, 2007 11:58 am Post subject: tab delimited format in calc |
|
| Does anyone know how to save a spreadsheet in tab delimited format? I see comma delimited, but no tab. |
|
| Back to top |
|
 |
Lorinda
Captain Mifune
Joined: Jun 20, 2006
Posts: 2051
Location: Midwest, USA
|
| Posted: Mon Mar 26, 2007 12:06 pm Post subject: |
|
The CSV setting is somewhat miss-named; it can be used for tab-delimited format, too.
Under File, choose Save As
In the Save dialog, choose "Text CSV (.csv)" from the "File Type" drop down.
Click on the Save button
A dialog will appear where you can specify Encoding, File delimiters and text delimiters. Tab is one option for File delimiters. |
|
| Back to top |
|
|
valterb
The Anomaly
(earlier version)
Joined: Sep 23, 2005
Posts: 463
Location: San Giuliano Terme, Pisa, Italy
|
| Posted: Mon Mar 26, 2007 12:08 pm Post subject: |
|
Save it as "csv" text. You will be asked to choose the character you want to use as fields delimitation.
Valter
Edit: Lorinda wins for 2 minutes... |
|
| Back to top |
|
|
UnConundrum
Blue Pill
Joined: Apr 15, 2007
Posts: 2
|
| Posted: Sun Apr 15, 2007 5:13 pm Post subject: |
|
| For some reason I'm not getting the dialog that offers various delinmiter options. Is there a setting somewhere? |
|
| Back to top |
|
|
UnConundrum
Blue Pill
Joined: Apr 15, 2007
Posts: 2
|
| Posted: Sun Apr 15, 2007 5:27 pm Post subject: |
|
| Finally found my own answer. It's the "Edit filter settings" check box. |
|
| Back to top |
|
|
|
