When work wrap is enabled for a cell (or cells), the row height is automatically increased or decreased to fit the content. However, if the column width is modified (increased / decreased), the row height of filled cells does not update automatically. Becomes a problem when the column width is reduced and the contents gets hidden. Issue reported in a wiki post @ ask.libreoffice.org http://ask.libreoffice.org/question/8225/cannot-wrap-text-in-cells-in-calc/
Confirmed the behavior for LO 3.5.7 up to LODev 3.6.5.
(In reply to comment #1) > Confirmed the behavior for LO 3.5.7 up to LODev 3.6.5. Therefore 'NEW'. Is it still reproducible using LibreOffice 4.0? Kind regards, Joren
(In reply to comment #2) > Is it still reproducible using LibreOffice 4.0? Sorry for my change, but therefore I'll set Bug Status to NEEDINFO. I know there are made some changes in 4.0 quite related to this issue. Therefore I ask this to retest. Thanks for your time. Kind regards, Joren
reproduced on Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) on WinXP. Recalculation of row height is not done until a new line wrap (forced by a word passing the right border of the cell) is done. Steps to reproduce: 1. in Calc select a cell and format it with automatic word wrap (Format - Cells - Tab:Alignment - wrap text automatically: Check). 2. Add text that floats over the right border of the cell. 3. Result: Text is wrapped to fit cell width, row height is adapted to fit the content. 4. Reduce the width of the cell (just move the right border of the column header a bit to the left) until word wrap forces a new line of text. 5a. Expected result: Similar to 3. 5b. Present result: Text floats to a new line in the cell, but row height stays the same. The new line is not visible, but a red triangle on the right border of the cell indicates that there is more text in the cell. 6. Add more text to the cell without forcing a new word wrap. 7a. Expected result: Similar to 3. 7b. Present result: Similar to 5b. 8. Add more text, so a new line is necessary. 9. Result: Similar to 3. HTH - if this info is sufficient, please change status. Thanks Bernhard
(In reply to comment #4) > reproduced on Version 4.0.0.3 (Build ID: > 7545bee9c2a0782548772a21bc84a9dcc583b89) > on WinXP. Well done Bernhard! Thanks for your clear steps. I didn't test them yet, but because you can reproduce it I mark this as NEW for now. I'm currently building, so I'll test later. Kind regards, Joren
Just to add: Still the same behavior in version 4.0.1.2 (Build ID: 84102822e3d61eb989ddd325abf1ac077904985) on Win XP. And we could include the lack of reducing the height when you broaden the cell in order to reduce the number of text lines: In this case the row stays too high and the text is positioned according to the standard vertical alignment (in my case: at the bottom of the cell). (if you want me to, I'll probably can provide a step-by-step description for this case too)
Being triggered by http://ask.libreoffice.org/en/question/38096/wrap-is-inconsistent/?comment=38100#comment-38100 I confirm the bug still exists in Version: 4.2.6.2 Build ID: 185f2ce4dcc34af9bd97dec29e6d42c39557298f running on XP Pro / SP3 It is actually a pretty annoying bug when task lists need to be created. It slows down productivity a lot.
(In reply to comment #4) > 5b. Present result: Text floats to a new line in the cell, but row height > stays the same. The new line is not visible, but a red triangle on the right > border of the cell indicates that there is more text in the cell. Reproduced in LO 4.3.1.1, 3.3.0.4 - Ubuntu 12.04 x86 Also in AOO 4.1.0, looks inherited from OOO
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.