It seems I want to set “Optimal Row Height” as the default. I thought that’s
what I had and for some reason certain rows or certain cells weren’t following
that setting. If I have the trouble again, I’ll check if the affected cell has
a different row height setting for some reason. If so, it sounds like Girvin’s
trick is the easy solution.
Thanks.
Eric Beversluis
Short fiction at www.ericbeversluis.com
On April 6, 2021 at 16:20:46, Girvin Herr (ghe...@fastmail.com) wrote:
>
> On 4/6/21 1:04 PM, Brian Barker wrote:
> > At 14:11 06/04/2021 -0400, Eric Beversluis wrote:
> >> I've got a spreadsheet with all cells formatted to auto-wrap, yet
> >> when I enter stuff into certain cells, it doesn't autowrap. And
> >> sometimes the cell just shows the last bit of what I've entered. When
> >> I right-click and check the cell, it does show it's set to auto-wrap.
> >
> > I think the answer may be simple: that you have set the row height for
> > the relevant cells to be insufficient to allow wrapping to happen. In
> > this case, the last line of wrapped text is indeed what will appear in
> > the cell. You need to tinker with row height to enable Calc to expand
> > the row sufficiently to accept all your text.
> >
> > I trust this helps.
> >
> > Brian Barker
> >
> >
> Double-click on the bottom line of the far left column (the row number
> column, not column "A") of the row needing enlargement. If you are on
> the line, the mouse pointer will change to the up-down arrow icon. Doing
> so should increase the row height to accommodate the text. (It will also
> decrease the row height if the text will allow it.)
>
> Girvin
>
> --
It seems I want to set “Optimal Row Height” as the default. I thought that’s
what I had and for some reason certain rows or certain cells weren’t following
that setting. If I have the trouble again, I’ll check if the affected cell has
a different row height setting for some reason. If so, it sounds like Girvin’s
trick is the easy solution.
Thanks.
Eric Beversluis
Short fiction at www.ericbeversluis.com
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
