#1

I have wrapped cells in the row and I would the row to automatically adjust its height to the highest cell content.

Adjust row height to fit text automatically
Default Optimum Row Height
Set default behavior to automatically set Row/Cell Height 'to fit'
Is there any way to default cells to wrap text & optimize row height?
Set default behavior to automatically set Row/Cell Height 'to fit'
Is there any way to default cells to wrap text & optimize row height?
#4

This does not solve the issue for me in version 24.2.0.3, and the key word is automatically. Has a bug report been filed? This solution makes the row height(s) correct once, but it does not make them automatically responsive to future edits. Here are the steps to reproduce the issue:

  1. In a new spreadsheet, add text on multiple columns of the same row.

  2. Edit the text on multiple columns to increase their number of lines to various lengths. Row height responsively increases repeatedly.

  3. Edit the text on the longer cells to decrease their number of lines.

  4. Row height does not responsively decrease. You must double-click between the row number and the row+1 number to adjust the row height to fit.

Tom

#3

Assuming that the question is about Calc:

See LibreOffice Help on Optimal Row Heights.

EDIT: If the content of the cell is a formula, the height of the row will not be adjusted automatically when there is a change in the referenced cell. You must edit the formula, or un-wrap and re-wrap these cells to make the row height fit the new content.

Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.

Add Answer is reserved for solutions. If you think the answer is not satisfactory, add a comment below, or click edit (below your question) to add more information. Thanks.

Check the mark (Answer mark → Correct answer mark) to the left of the answer that solves your question.

If the answer helped you, you can mark the up arrow (Upvote mark) that is on the left (to vote, you need to have karma of at least 5).