[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

--- Comment #4 from Kevin Suo <suokunlong at 126.com> ---
(In reply to s5t1e3v4e3m11 at hotmail.com from comment #3)
I prepared a excel file with the following contents:

Sheet1:
ID        Value1        Value2    Value3    Value4    Value5
1              1             2         3         4         5
2              2             3         4         5         6
3              3             4         5         6         7
...
890361    890361        890362    890363    890364    890365

Sheet2:
ID        Value5
1              =vlookup(A1, Sheet1.A:F, 6,0)
2
3
...
890361

Then I fill down the formula in Sheet2 and immediately hit ESC.

In Excel, after I hit ESC, it immediately stopped the fill operation, but it
for the cells which were already filled with formula the calculation goes on.

Also, I noticed that when I click the save icon, during the save process I have
an option of hitting ESC to cancel.

Actually, what the ESC do seems to be related to what task is to be canceled,
see:
https://docs.microsoft.com/en-us/office/vba/api/Excel.Application.EnableCancelKey

-- 
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/20210322/bdc76c10/attachment.htm>