Description: Validity dialog in Calc has too big height. Steps to Reproduce: 1. run Calc 2. go to Data > Validity Actual Results: dialog height is too big Expected Results: decrase dialog height Reproducible: Always User Profile Reset: No Additional Info: n/a
It looks like the height is fixed and is long to show enough text on "input help" and "error text" tabs without scrolling. It would be nice to trim 10-20% height at the bottom for aesthetics so marking as enhancement but this has a good chance of going "WONTFIX".
Now in 7.1 we have ~640px in height for the Validity dialog. But it looks strange anyway. I suggest decrease the height
Yes, let's reduce the height. Code pointers: sc/uiconfig/scalc/ui/validation*.ui maybe also sc/source/ui/dbgui/validate.cxx
(In reply to Heiko Tietze from comment #3) > Yes, let's reduce the height. > > Code pointers: > sc/uiconfig/scalc/ui/validation*.ui > maybe also sc/source/ui/dbgui/validate.cxx Hi! I tried to change the column_spacing property inside ValidationCriteriaPage in validationcriteriapage.ui but no changes occurred. Can you tell me which property tweaks the height of the dialogue box?
In sc/source/ui/dbgui/validate.cxx ScTPValidationValue::ScTPValidationValue() the dialog size is requested per Size aSize(m_xEdList->get_approximate_digit_width() * 40, m_xEdList->get_height_rows(25)); Reduce the number of rows to show to make the dialog smaller.
Roman Kuznetsov committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/9cb1c7e5d7434a64ada279ad264182286f907d7c tdf#131815 Reduce Validity dialog height It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Roman Kuznetsov committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/0037b68dc6c2208af6760a0b86c59f871a2ce80a tdf#131815 Reduce Validity dialog height It will be available in 7.1.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
verified as fixed in: Version: 7.2.0.2 / LibreOffice Community Build ID: 614be4f5c67816389257027dc5e56c801a547089 CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded