[Libreoffice-bugs] [Bug 132065] New: Ease formula editing

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: d_jan at ymail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200412/0ed81300/attachment.htm>