Re: [libreoffice-users] Calc: Automatically sizing cells vertically to fit contents

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: users+unsubscribe@global.libreoffice.org
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