Date: prev next · Thread: first prev next last
2021 Archives by date, by thread · List index


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 (gherrl@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+unsubscribe@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.