How do I get dynamic change of height in rows or cells?

Question

How to get dynamic height in a cell? If I put too much text in a cell it will not show all the info since it's not room for it. I want my calcsheet to dynamically change the height in the entire row when needed.

score 4 · Answer 1 · edited Jun 04 '14 at 08:24

4

Select all the cells
go to Format->Row->Optimal Height
Check Default Value and click OK

edited Jun 04 '14 at 08:24

Paresh Mayani

127,700
71
241
295

answered Jun 04 '14 at 08:23

Balaji

850
7
15

score 1 · Accepted Answer · answered Dec 17 '13 at 16:34

1

Highlight the cells you want to format in this way.
From the Format menu, select Cells... (keyboard shortcut Ctrl+1).
Go to the Alignment tab.
Check Wrap text automatically.
Click OK.

answered Dec 17 '13 at 16:34

JBentley

6,099
5
37
72

Thanks for that fast reply JBentley. I was trying that just before I posted but couldn't get it working. Still can't. :-/ – AndersBrontosaurus Dec 17 '13 at 16:44
@user3112008 It works for me in a fresh spreadsheet. There is one caveat: cells won't automatically decrease their height when you remove text from them. That has to be done semi-manually by selecting the rows, and double clicking on one of the lines which separate the row labels on the left had side. Every row you selected will then have their heights recalculated. I'm not sure why it behaves like this, but it is the same in Microsoft Excel. – JBentley Dec 17 '13 at 16:46
Ah. good to know. Just realized It's because I'm trying to perform it in merged cells. Any workarounds for this? Assume not. Just have to redo the entire shubang. I'm on Libre office 3 btw. – AndersBrontosaurus Dec 17 '13 at 16:50
@AndersBrontosaurus I'm not sure. When I create a fresh spreadsheet, merge two cells, enter enough text for it to be truncated, and then perform the steps above, it correctly adjusts the height. My version is 3.6.3.2 – JBentley Dec 17 '13 at 17:54
Strange JBentley. I made a new spreadsheet and got it working at the start but suddenly it doesn't any longer. Avoided all merging. Have done some changes to the cells but nothing special. I will have to examine deeper just when it stops working and post back. Thanks for helping. – AndersBrontosaurus Dec 17 '13 at 19:43

score 1 · Answer 3 · edited Jun 20 '16 at 20:09

1

Select all the table.
Go to Format > Cells and check Wrap Text.
Also "Filled" in the drop-down under Text Alignment.

That worked for me after trying all the other things. :)

edited Jun 20 '16 at 20:09

cavpollo

4,071
2
40
64

answered Jun 20 '16 at 19:23

Molly

11
1

How do I get dynamic change of height in rows or cells?

3 Answers3