[Libreoffice-bugs] [Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=137147

s5t1e3v4e3m11 at hotmail.com <s5t1e3v4e3m11 at hotmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |s5t1e3v4e3m11 at hotmail.com

--- Comment #3 from s5t1e3v4e3m11 at hotmail.com <s5t1e3v4e3m11 at hotmail.com> ---
(In reply to Kevin Suo from comment #0)
> Microsoft Excel already has this functionality, at least in its MSO 2010
> version.

I have no MS Excel, can you please confirm some detail I am curious about?

Assume we have sat through a long formula fill of e.g. 60000 rows.
Then we change the formula on the top, double click the fill handle to change
all already calculated cells to the new formula, but half-way through hit the
designated calculation cancel button (e.g. ESC).

Is the result that half the cells have changed and the other half is unchanged
or is Excel doing a ROLLBACK?

If this is implemented in LO, I would prefer to get a dialog asking what to do:
(1)just abort the calculation and leave the mixed data
(2)clear the remaining cells
(3)ROLLBACK
(4)continue

TBH, I am not sure (2) is really useful, but it is easy to find how far it got.

If I intentionally tried to cancel the calculation, I most likely realized that
the formula was still not right and want the fastest way getting a responsive
spreadsheet again, which probably would be (1)

-- 
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/20210321/384bb56e/attachment.htm>