Bug 139617 - Optimal height isn't applied when shrinking word-wrapped cell (nor after entering the cell), only when content changes
Summary: Optimal height isn't applied when shrinking word-wrapped cell (nor after ente...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Anchor-and-Text-Wrap
  Show dependency treegraph
Reported: 2021-01-14 18:56 UTC by Telesto
Modified: 2023-04-19 03:24 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Example file (8.43 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-01-14 18:56 UTC, Telesto

Note You need to log in before you can comment on or make changes to this bug.
Description Telesto 2021-01-14 18:56:11 UTC
Word wrap isn't applied when shrinking cell (nor after entering the cell)

Steps to Reproduce:
1. open the attached file
2. Shrink column F to say 2,80 CM (or 50% or original size)
3. Notice text being hidden
4. Double click the cell -> text visible
5. Exit again.. no size change
6. Right click -> Format cell -> Uncheck Wrap text automatically & recheck again

Actual Results:
Text hidden. Wrap must be re-enabled after resize

Expected Results:
* In comparison with Excel I would expect the resize happening automatically after entering the cell.
* Or even adapting high while resizing. 

If someone decides the current behavior making sense in certain workflows.. consider additional settings. I simply want text adjusting to cells (similar to text in tables in Writer). I don't think this such 'weird request'. See MSO

Reproducible: Always

User Profile Reset: No

Additional Info:
Version: (x64)
Build ID: f2171af6ce3516598d9f8bac8294025a21a5b1a2
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: nl-NL (nl_NL); UI: en-US
Calc: CL
Comment 1 Telesto 2021-01-14 18:56:54 UTC
Created attachment 168886 [details]
Example file
Comment 2 Heiko Tietze 2021-01-19 08:45:12 UTC
Would also expect that when Wrap Text is active the row height is adjusted on changes (whether col size or text length), if set to automatically or optimal. But obviously the row height thing is not a setting but a one-shot function. We should change this, @Eike: Is this possible?.

Of course this request is not new and has been reported in bug 55433 and bug 75305.

*** This bug has been marked as a duplicate of bug 55433 ***
Comment 3 Heiko Tietze 2022-09-19 09:37:45 UTC
Justin resolved the supposed duplicate bug 55433 as NAB and reopened this. My comment 2 is still valid, removing UX.
Comment 4 V Stuart Foote 2022-09-19 14:54:35 UTC
(In reply to Heiko Tietze from comment #3)
> Justin resolved the supposed duplicate bug 55433 as NAB and reopened this.
> My comment 2 is still valid, removing UX.

Yes, but behavior needs to follow what assigned by row/cell style(s). So IMHO *not* auto-adjusting when optimal height is set false is correct handling.
Comment 5 QA Administrators 2023-03-19 03:25:57 UTC Comment hidden (obsolete)
Comment 6 QA Administrators 2023-04-19 03:24:20 UTC
Dear Telesto,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team