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 <[email protected]> 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: [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 -- Jim -- 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
