<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Ease formula editing"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132065">132065</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Ease formula editing
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>All
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>enhancement
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Chart
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>d_jan@ymail.com
</td>
</tr></table>
<p>
<div>
<pre>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",
<a href="https://www.researchgate.net/publication/336187404_XLBlocks_a_Block-based_Formula_Editor_for_Spreadsheet_Formulas">https://www.researchgate.net/publication/336187404_XLBlocks_a_Block-based_Formula_Editor_for_Spreadsheet_Formulas</a>
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)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>