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

Have you tried Alt+O, R, O which sets row height to fit the content. I think it continues to fit 
increased needs such as added lines as well as larger font size.

On March 16, 2014 11:57:44 PM PDT, Brian Barker <b.m.barker@btinternet.com> wrote:
> 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


-- 
Jim


-- 
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