OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Convert selected cells from sheet to formatted text file.

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
qolio
Newbie
Newbie


Joined: 24 Jun 2007
Posts: 3
Location: Southern Sweden

PostPosted: Sat Jun 30, 2007 10:05 pm    Post subject: Convert selected cells from sheet to formatted text file. Reply with quote

OK so what I want to do is select certain cells from a spreadsheet and save them as a formatted text file. By formatted, I mean that some of the cells should be joined together (concatenated?) into a string, while other cells should have a simple line break after them and if there are null values, these should be ignored. This last because the amount of data in the sheet will not always be the same from example to example.

I know I can us the concatenate function to make a string of the sort that I want so thats not a problem, its the line breaks and ignoring null values that I need answers on.

Anyone got any ideas how I might do this? Please if you do, keep it simple because I need ste by step instructions (just stupid I guess Wink )
_________________
They always say time changes things, but you actually have to change them yourself.
Andy Warhol
Back to top
View user's profile Send private message
squenson
Super User
Super User


Joined: 09 Mar 2007
Posts: 690
Location: Nis, Serbia

PostPosted: Sat Jun 30, 2007 10:27 pm    Post subject: Reply with quote

qolio,

I am not sure that I understand what you mean by a line break. If you want to insert a Ctrl-Alt-Enter in a cell, I don't know whether it is possible with a formula. What you can do is add to a cell the Enter character with CHAR(13). It will not be visible on the screen, but if you copy/paste that cell in a text editor, a blank line will be inserted.

If you want to ignore blank cells, you can use the function: =IF(ISBLANK(A1;...;...)

If it does not help, please give me more information. You can even post a sample of what you want to achieve at http://www.mediafire.com (free, no registration required) and post the link to this forum so we can have a look at the file.
_________________
Help us to help you: Add [Solved] to the title of the thread if you agree with the answer
>>> Do you know the new OOo support forum http://user.services.openoffice.org/en/forum/index.php? <<<
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group