[Libreoffice-bugs] [Bug 101876] UI: resizing function wizard only resize the formula field, not the structure and parameter fields width

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Sep 21 14:23:00 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=101876

--- Comment #8 from aristocompasso <bastos.ar at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190921/5204f14d/attachment-0001.html>


More information about the Libreoffice-bugs mailing list