Saving Calc files as tab delimited

Discuss the spreadsheet application

Saving Calc files as tab delimited

Postby normantomalin » Sun Feb 17, 2008 1:40 pm

Welcome beginner. Please answer all of the questions below which may provide information necessary to answer your question.
-----------------------------------------------------------------------------------------------------------
Which version of OpenOffice.org are you using? 2.3.1
What Operating System (version) are you using? Vista HOme
What is your question or comment? I'm new to OO and need to save a spreadsheet file as a tab delimited file. In Excel I "Save As" the xls file as a (tab delimited) txt file. How is this accomplished in Open Office?
normantomalin
 
Posts: 5
Joined: Thu Feb 14, 2008 8:28 pm

Re: saving calc files as tab delimited

Postby squenson » Sun Feb 17, 2008 1:54 pm

normantomalin,

Welcome to the forum! To save a file with tab delimited, use Save As, select Text (CSV) and click the Edit box:
f1.PNG
f1.PNG (4.51 KiB) Viewed 18611 times
Then in the new window, select the {tab} option:
f2.PNG
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1879
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: saving calc files as tab delimited

Postby cmikal » Fri May 09, 2008 2:16 pm

In the example screen shot you show a very simple file name (ttt). OK.....no problem....but what if you already have MANY files already saved on your computer and those files all have long, complicated names ending in a TXT extension, and you want to replace one of them with the document you are now editing? What then? Files with the TXT extension do not appear in the dialog box so that you can select it from a list, and you cant leave the file name empty, so you are stuck.

If you dont understand the dilemma, here is the scenario:
We have many relatively small tab delimited documents that get updated or completely changed every day (ie each document may be 90% to 100% different after each save. Each document MUST be saved with the EXACT correct file name, otherwise our computer system wont recognize the file as valid and reject it. Each document may start out as a blank or new-never-before-saved document (ie it is not guaranteed that the original document will be opened, edited, then resaved). So you create/edit a blank document that needs to be saved as Tr5HIl1MMnmD3xXssAsS-T_Q-ys0.txt.

Go ahead. Try it. See how far you get.

Why can't there just be a "save as TAB delimited"? To not have that option, IMHO, is just plain stupid.
cmikal
 
Posts: 1
Joined: Fri May 09, 2008 1:49 pm

Re: saving calc files as tab delimited

Postby Villeroy » Fri May 09, 2008 2:26 pm

Turn off "Automatic file name extension" and save with any suffix or none.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17307
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: saving calc files as tab delimited

Postby fst » Fri May 09, 2008 9:21 pm

Hi,

have you tried to put '*.txt' (without the quotes) into the filename field and pressed the Enter Key ?

No ?

So try it and your problem is solved.

To have an extra filter option for an somewhat seldome used option (for the world not yours!) in an currently overloaded Filter box is counter productive and therefore not done.

frank
Frank
fst
Volunteer
 
Posts: 132
Joined: Wed Nov 28, 2007 2:31 pm

Re: saving calc files as tab delimited

Postby MARIO REIS » Mon Dec 27, 2010 6:56 pm

Please

Where can i report a bug? I strongly beleave i found a bug savig calc files as tab delimited(1.º as CSV then separator {Tab} then fixed column) ;
The result is a file/columns with 1 more byte then it should be.
Can any one help?
Thanks.
Windos7 + openOffice3.2 (portuguese)
MARIO REIS
 
Posts: 1
Joined: Mon Dec 27, 2010 6:49 pm

Re: saving calc files as tab delimited

Postby squenson » Mon Dec 27, 2010 8:15 pm

You can report a bug at http://qa.openoffice.org. You need to register (it's free!) in order to report a bug. Check whether it doesn't already exist.
LibreOffice 4.2.3.3. on Ubuntu 14.04
User avatar
squenson
Volunteer
 
Posts: 1879
Joined: Wed Jan 30, 2008 9:21 pm
Location: Lausanne, Switzerland

Re: Saving Calc files as tab delimited

Postby huasonshine » Fri Sep 28, 2012 4:28 am

I tried several times to save from calc to .txt & .csv maybe I'm tired and frustrated but when I reopened to check spacing, it was garbled code. (blonde geek-speak).
yes, I have tried unchecking the auto ext and typing in my own suffix. I finally gave up and pasted (special) the unformatted text into an .odt; checked spacing, and then pasted into notepad. The long way around but hey, it worked :) and ultimately it transferred properly to my online address book at SOC (which was the point) The odd thing was, that it was inconsistant in the text formatting (adding "quotes" for delimited text) I would love to get feed-back on what causes that. The short cuts are not worth as much if you have to correct 25% of the text to use it, even so it was still faster than re-typng all of the addresses into the individual fields.
OOo 2.4 windows 7
huasonshine
 
Posts: 1
Joined: Wed Aug 31, 2011 7:06 am

Re: Saving Calc files as tab delimited

Postby Villeroy » Fri Sep 28, 2012 9:02 am

csv is not a file format. It is mere convention. There are thousands of valid csv variants and quoted text is pretty much standard. Whatever "SOC" means, if it processes text tables should be able to import any flavour of csv you throw at it.
Is there any reason why you load text data into a numeric calculation program? I know that virtually everybody does that since decades with always the same problems since decades. Spreadsheets are not particularly useful as text editors.
http://csved.sjfrancke.nl/ is a text editor for text tables.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 12.04, Apache OpenOffice 4.x
User avatar
Villeroy
Volunteer
 
Posts: 17307
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: No registered users and 39 guests