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

Pasteing across multiple columns
Goto page Previous  1, 2
 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
LEJ
General User
General User


Joined: 08 Feb 2012
Posts: 7

PostPosted: Tue Feb 14, 2012 2:25 am    Post subject: Reply with quote

ozzie,

My sheet doesnt work like yours - why - I do not understand
You have values in the statements of 70 75 and 80 - I understand that 80 is the max width - what are 70 and 75?

I have attached my working sheet - it has other working columns for Useby dates etc....

http://www.mediafire.com/?89bed4cbdb1k4qm

What do you think??

LEJ
Sydney
Back to top
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 400
Location: victoria

PostPosted: Tue Feb 14, 2012 9:30 am    Post subject: Reply with quote

LEJ
I've put in my adjusted formula to suit the E column rather than the A column
I have also recopied your info further down and and changed the formula to get rid of the all of the error stuff caused by lack of data
I haven't done anything about the 'INSTRUCTIONS: Eat Cold' as it wasn't about ingredients and therefore didn't seem to require it !?

My formula uses the SEARCH function as the main working engine.
SEARCH(find " " space; text to search; start position)
The start position being important first looking for any spaces after 75 and if its less than 80, then use that, if not, look for a space after 70
If I looked first for a space after 70 there is the possiblity of entire words which could have fitted in this column having to go in the next and having a cumulative effect column wise.

Your worksheet only has 'one' row for me to look at so I hope I've it looks OK

Your sheet is returned at
http://www.mediafire.com/?b4t6b1je660z6xy
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
LEJ
General User
General User


Joined: 08 Feb 2012
Posts: 7

PostPosted: Mon Feb 20, 2012 5:19 am    Post subject: Pasteing across multiple columns Reply with quote

Ozzie,

Hi - back again.

I have now filled in some of the E columns,
E3 to E6, E13, E16 to E18
It seems to be missing the second column, and it starts to get out of whack??

I've posted the filled in work sheet at
http://www.mediafire.com/?6hadptd4719ftb2

Is there a way to force a carriage return - eg. three spaces

This is E13
MICROWAVE: Remove lid, Heat on high for 2 minutes. Based on a 650watt microwave. STOVE TOP: Add soup to pot. Simmer on high for 3 minutes. INGREDIENTS: INGREDIENTS: Water, tomato crush, red kidney beans, chicken, onion, peas, celery, potatoes, carrots, macaroni, sugar, salt, vegetable oil, thickener maize (1422), parmesan cheese, natural flavours, garlic, food acid (330), mineral salt (509), dextrose, maltodextrin, yeast extracts, vegetable protein extracts, pepper, basil, flavour enhancer (627, 631)

Thanks
LEJ
Back to top
View user's profile Send private message
ozzie
OOo Advocate
OOo Advocate


Joined: 29 Jul 2010
Posts: 400
Location: victoria

PostPosted: Mon Feb 20, 2012 2:45 pm    Post subject: Reply with quote

Hi LEJ
missing the second column - I think this happened when I increased the helper column number - my fault, apologies - repaired
out of whack - there is a bad mixture of word wrapping,column width and forced row height that hides rows of text and shows part of this in the top of the cells involved,I have tidied this up for you
with more row samples to work on I can get a better idea on what is wanted/needed,as I can now see that cooking instructions can be mixed in with ingredient list stuff so I have fixed formula to show all contents of 'E' column
E3 has 853 characters - well above the 800 limit that I had catered for so I have amended column 'AA' to take all the remaing characters no matter how many as they are just getting lost otherwise

I have posted the amended sheet at
http://www.mediafire.com/?0wuz08wx5hp4a3d

you mention carriage return (this can be done with =CHAR(10))
BUT when I read this I had this feeling that you don't want or need any formula at all just some advice on formatting your sheet as I have done in column 'E' on the above worksheet
-adjust column width to approx 13cm.
-highlight cells and menu/format/cells/alignment and tick 'wrap text automatically'
-highlight all rows menu/format/row/optimal height and tick 'default value'
If this is what you really want then columns F to AA can be deleted.
_________________
If your problem has been solved please add "[Solved]" to the beginning of your first post title (edit button).
Back to top
View user's profile Send private message
greenorange
Newbie
Newbie


Joined: 14 Feb 2012
Posts: 1

PostPosted: Mon Feb 20, 2012 10:56 pm    Post subject: Reply with quote

This post has been somewhat of a revelation to me.
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
Goto page Previous  1, 2
Page 2 of 2

 
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