Bug 151330 - Add option for Optimal row height to ignore hidden columns
Summary: Add option for Optimal row height to ignore hidden columns
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Cell-Management
  Show dependency treegraph
 
Reported: 2022-10-04 13:00 UTC by Timur
Modified: 2023-05-09 12:13 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Timur 2022-10-04 13:00:26 UTC
Bug 131073 shows there are different user expectations how to make Optimal row height when there are hidden columns. 
Solution is an option in Optimal Height dialog, named "Ignore hidden", default unchecked. 

Open attachment 158312 [details] and see that most populous B column is hidden.
Mark row 1 and do Optimal height. 

Actual Results:
The row 1 height does not change, calculates also B.

Expected Results:
To have an option that row 1 height is adjusted to C, not B, so height more decreased.
Comment 1 Stéphane Guillou (stragu) 2023-04-28 22:18:22 UTC
Thanks Timur, sounds sensible.
Same in OOo 3.3 and:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 2e57755f72907e4bb604a8ba32edbd6c253ee57c
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

UX team, what would be the best UI for that?
Comment 2 Heiko Tietze 2023-05-02 07:50:21 UTC
Sounds like a good compromise. Any objection, Eike?

Btw, this "Default Value" option is hard to understand and the documentation not informative.

(The option would be added to the "Optimal Row Height / Column Width" dialog. If checked, the hidden row/col remains hidden resp. zero.)
Comment 3 Heiko Tietze 2023-05-09 12:13:44 UTC
No objection, let's do it.