Bug Hunting Session
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: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium minor
Assignee: Not Assigned
Depends on:
Blocks: Function-Wizard
  Show dependency treegraph
Reported: 2016-09-03 12:24 UTC by m.a.riosv
Modified: 2019-10-11 21:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

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

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

Arch Linux 64-bit, KDE Plasma 5
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 (obsolete)
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 (obsolete)
Comment 5 m.a.riosv 2019-06-01 11:15:29 UTC
Version: (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
Version: (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.