Bug 151330

Summary:	Add option for Optimal row height to ignore hidden columns
Product:	LibreOffice	Reporter:	Timur <timur>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---
Severity:	enhancement	CC:	andreas.heinisch, erack, heiko.tietze, sdc.blanco, stephane.guillou
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=131073
Whiteboard:
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	108364

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.