https://bugs.documentfoundation.org/show_bug.cgi?id=101876
--- Comment #8 from aristocompasso <[email protected]> ---
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
