Bug 101876 - UI: resizing function wizard only resize the formula field, not the structure and parameter fields width
Summary: UI: resizing function wizard only resize the formula field, not the structure...
Status: VERIFIED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Heiko Tietze
URL:
Whiteboard: target:7.6.0
Keywords: difficultyInteresting, easyHack, skillDesign, topicUI
: 155106 156422 (view as bug list)
Depends on:
Blocks: Function-Wizard
  Show dependency treegraph
 
Reported: 2016-09-03 12:24 UTC by m_a_riosv
Modified: 2023-07-22 12:23 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot before and after resize (72.88 KB, application/vnd.oasis.opendocument.graphics)
2016-09-03 12:24 UTC, m_a_riosv
Details
Example narrow structure panel (34.49 KB, image/jpeg)
2019-09-21 14:06 UTC, aristocompasso
Details

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2016-09-03 12:24:11 UTC
Created attachment 127135 [details]
Screenshot before and after resize

resizing formula wizard only resize the formula field, not the structure and parameter fields width, that's imply that most of the times structure formulas and values are only partially visible, forcing the use of the slider to view them, similar with parameters fields.
Comment 1 Buovjaga 2016-09-24 16:39:29 UTC
Repro.

Arch Linux 64-bit, KDE Plasma 5
Version: 5.3.0.0.alpha0+
Build ID: cd72269a6a2c85ae9dd4552aa4808ef4fd1f6c0e
CPU Threads: 8; OS Version: Linux 4.7; UI Render: default; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group
Built on September 21st 2016
Comment 2 Commit Notification 2017-09-06 14:38:48 UTC Comment hidden (off-topic)
Comment 3 Andreas Brandner (CIB) 2017-09-06 17:01:31 UTC
The comment one above me is invalid, I falsely linked this bug in the commit-message, instead of the correct one (which would have been https://bugs.documentfoundation.org/show_bug.cgi?id=106967).
Sorry for the confusion!
Comment 4 QA Administrators 2018-09-07 02:44:16 UTC Comment hidden (noise)
Comment 5 m_a_riosv 2019-06-01 11:15:29 UTC
Still
Version: 6.3.0.0.alpha1+ (x64)
Build ID: 837c9e35ef4795cec63ac8e953e58a870e8d02bc
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@62-TDF, Branch:master, Time: 2019-05-31_06:21:53
Locale: es-ES (es_ES); UI-Language: en-US Calc: CL
Comment 6 m_a_riosv 2019-06-01 11:22:00 UTC
Still
Version: 6.4.0.0.alpha0+ (x64)
Build ID: 7272b9f752cb74757d6ed504202eefccc589f804
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-06-01_03:59:41
Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded
Comment 7 aristocompasso 2019-09-21 14:06:48 UTC
Created attachment 154343 [details]
Example narrow structure panel
Comment 8 aristocompasso 2019-09-21 14:23:00 UTC
The function wizard is a good tool for editing long, nested and complex formulas, but the navigation is cumbersome due to a fixed size structure panel.

Complex formulations are a requirement for keeping some spreadsheets set of data compact (a lot fewer helper columns/rows), but are very hard to read and edit by the same person given a period of time, or a different person who has to work on the same set of data.

Several options come to mind to improve the usability of said tool:
1) the panel should have an adjustable width;
2) the layout of the structure could be different (horizontal panel, instead of vertical)
3) clicking the panel could provide a text editor like capability of editing the formulas directly, as in the formula bar, but with the structured layout; 
4) The formula bar drop down could implement both styles/views (continuous and structured).

Said functionality/ies would vastly improve productivity with formula based spreadsheets to the point of replacing simple macros and externally created software tools like console applications.
Comment 9 m_a_riosv 2019-10-11 21:05:20 UTC
Seems partially solved with 6.3.

Partially because now the structure change their wide with the window's wide.

But in my opinion their proportion on the change should be less than the formula box.

The change doesn't involve the functions fields, what in my opinion should change in the same proportion than formula box.
Comment 10 m_a_riosv 2019-10-11 21:06:23 UTC
In any case thanks for the improve, it's an step.
Comment 11 QA Administrators 2021-10-11 03:31:41 UTC Comment hidden (noise)
Comment 12 m_a_riosv 2021-10-11 08:15:39 UTC
Still there.
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 21b2c6b7d8f4661dcbd40df4f8b9126d331cbd7f
CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL
Comment 13 m_a_riosv 2023-05-01 16:19:03 UTC
*** Bug 155106 has been marked as a duplicate of this bug. ***
Comment 14 m_a_riosv 2023-05-01 16:21:05 UTC
Still
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: a1acc2f46cc499631d66b1d7a923ed15ab4f28de
CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US Calc: CL threaded
Comment 15 Heiko Tietze 2023-05-02 07:26:13 UTC
I suggest to add a splitter between the left part (Functions/Structure) and the right part with all parameters. And to fill the space for the (dynamically created) input controls.

Might be a somewhat tricky easyhack.
Comment 16 m_a_riosv 2023-05-02 13:01:11 UTC
Looks fine, good idea. Thanks, @Heiko.
Comment 17 Commit Notification 2023-05-03 04:56:19 UTC
Heiko Tietze committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/a21e151508918c39189a18d46fcba490100e5890

Resolves tdf#101876 - Resizing function wizard content

It will be available in 7.6.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.
Comment 18 m_a_riosv 2023-05-03 06:31:57 UTC
Thanks^3
Comment 19 BogdanB 2023-05-03 15:49:23 UTC
Fill the space now.

Verified with
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: bb198176684c3d9377e26c04a29ec66deb811949
CPU threads: 16; OS: Linux 5.19; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Calc: threaded
Comment 20 m_a_riosv 2023-07-22 12:23:55 UTC
*** Bug 156422 has been marked as a duplicate of this bug. ***