At 14:39 17/03/2014 +1100, Hedley Finger wrote:
On 17/03/2014 1:43 PM, Steve Edmonds wrote:
On 2014-03-17 15:29, Hedley Finger wrote:
I'm sure that I could set automatic sizing of cells to fit their
contents in Excel. I want them to increase in height as more text
is typed into them. Does anybody know how to do this? I searched
Nabble and Help but couldn't come up with any answers.
In LO here the cell automatically re-sizes. I turn on wrap
automatically in Format>cells>Alignment. Ctl-Enter produces a new
line in a cell.
I have Wrap Text Automatically turned on but the cells are not
increasing in height as more text is typed.
The "Wrap text automatically" setting appears to control only that:
whether text beyond the right edge of a cell continues on the same
line (the default) or is wrapped to a new line - and not whether any
such new lines affect the row height. If you have set a specific
height for the row, this is maintained irrespective of the contents;
only if you have not done this will the row height adjust
automatically if new lines are created in a cell, either manually or
automatically.
If your row height is not responding to changes in the cell contents,
you must have set a specific row height, I think. You can reset this
by double-clicking the divider below the row header for that
row. (You can do this for multiple rows by selecting them and
double-clicking any divider.) Yes: that's a manual act rather than
the automatic effect you are seeking, but once you have done it, the
row will respond automatically to future changes - as you wish. If
instead you drag the lower row edge to expand a cell manually, you
will be setting a row height and spoiling the effect you desire.
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
