Ask Your Question
0

Contain text within cell [closed]

asked 2017-03-15 07:41:55 +0100

appreciatethehelp gravatar image

Hey guys. Am just wondering if there is any function in LO that I could use to automatically contain text within a cell…

Usually when you type text into a cell and there is too much text to fit in that cell, the little red arrows appear to either side of the cell right?

I want LO to automatically start a new line of text once the cell is horizontally full, extending the row the text is entered in downward to accommodate the extra text.

Also if possible I would like to be able to set the width of borders on the inside of the cell, meaning that when the line of text encroaches upon the border of the cell, a new line is started automatically.

A good example is the box I am typing in right now, when I get to the right hand edge of this box and keep typing……….. a new line starts automatically.

At the moment I have to enter line breaks manually, which is becoming rather tedious, as when I edit a part of the text I have to rearrange all the other lines to make sure that they fit in the cell.

If any of this is unclear I can post an example pdf.

Many thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2017-03-21 12:59:56.984954

1 Answer

Sort by » oldest newest most voted
2

answered 2017-03-15 07:56:51 +0100

pierre-yves samyn gravatar image

Hi

Have you tried FormatCellsAlignment tab▸PropertiesWrap text automatically ?

Regards

edit flag offensive delete link more

Comments

That's just what I'm after, cheers. Could someone please weigh in on the border adjustment part?:

"Also if possible I would like to be able to set the width of borders on the inside of the cell, meaning that when the line of text encroaches upon the border of the cell, a new line is started automatically".

appreciatethehelp gravatar imageappreciatethehelp ( 2017-03-15 10:37:49 +0100 )edit
1

See Borders tab (same dialog)▸Spacing to contents

pierre-yves samyn gravatar imagepierre-yves samyn ( 2017-03-15 11:57:45 +0100 )edit

Excellent, right on the money as always, Pierre!

appreciatethehelp gravatar imageappreciatethehelp ( 2017-03-21 12:59:14 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2017-03-15 07:41:55 +0100

Seen: 344 times

Last updated: Mar 15 '17