<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 - Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=137147">137147</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</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>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>suokunlong@126.com
</td>
</tr></table>
<p>
<div>
<pre>The main functionality of Calc is to do complex spreadsheet calculations. Some
spreadsheet formulas may take a lot of time to run in case the data source is
large. Although the recent version of LibreOffice enabled Threaded Calculation,
there are still cases when the calculation hangs.
As a result, we should provide a way to let the user decide when to cancel /
terminate the calculation process. Otherwise, the only way to stop the
calculation is to kill the process, which will cause dataloss.
Microsoft Excel already has this functionality, at least in its MSO 2010
version.
Steps to Reproduce:
1. Set complex formulas (vlookup, offset, match, sumifs...) in Calc with large
dataset.
2. Hit ESC key (or other defined keys) should terminate the calculation.
Already calculated results may be kept "as-is", or cleared.</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>