https://bugs.documentfoundation.org/show_bug.cgi?id=132065
Bug ID: 132065
Summary: Ease formula editing
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Chart
Assignee: [email protected]
Reporter: [email protected]
Nested Formulas are hard to read and hard to edit as all content is on one
line. This can lead to errors in the formulas or worse, unnoticed wrong
calculations.
One way to ease to editing would be implementing a view/edit mode which is
compatible with the current behavior but makes understanding and editing
easier. This could use a block-like visualization as known from tools like
scratch.
This approach has been suggested and evaluated by Jansen/Hermans in "XLBlocks:
a Block-based Formula Editor for Spreadsheet Formulas",
https://www.researchgate.net/publication/336187404_XLBlocks_a_Block-based_Formula_Editor_for_Spreadsheet_Formulas
Notes:
- We have a "Structure" view, but this does only cover the nesting of the
function calls as far as I am concerned and has no editing capabilities.
- A good place for this might be the sidebar
- A library for block based programming would be blockly, which is implemented
in javascript. It uses SVG for diagrams and interactions (but there are many
other implementations for block languages)
--
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
