[Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
https://bugs.documentfoundation.org/show_bug.cgi?id=137147 Stéphane Guillou (stragu) changed: What|Removed |Added Blocks||151167 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=151167 [Bug 151167] [META] Make long operations cancellable -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
https://bugs.documentfoundation.org/show_bug.cgi?id=137147 BogdanB changed: What|Removed |Added CC||buzea.bog...@libreoffice.or ||g Blocks||109324 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=109324 [Bug 109324] [META] Calculate bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
https://bugs.documentfoundation.org/show_bug.cgi?id=137147 --- Comment #5 from Kevin Suo --- Created attachment 170616 --> https://bugs.documentfoundation.org/attachment.cgi?id=170616&action=edit Screencast in Win10 with Excel 2019 -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
https://bugs.documentfoundation.org/show_bug.cgi?id=137147 --- Comment #4 from Kevin Suo --- (In reply to s5t1e3v4e3...@hotmail.com from comment #3) I prepared a excel file with the following contents: Sheet1: IDValue1Value2Value3Value4Value5 1 1 2 3 4 5 2 2 3 4 5 6 3 3 4 5 6 7 ... 890361890361890362890363890364890365 Sheet2: IDValue5 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
https://bugs.documentfoundation.org/show_bug.cgi?id=137147 s5t1e3v4e3...@hotmail.com changed: What|Removed |Added CC||s5t1e3v4e3...@hotmail.com --- Comment #3 from s5t1e3v4e3...@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. 6 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
https://bugs.documentfoundation.org/show_bug.cgi?id=137147 Xisco Faulí changed: What|Removed |Added Status|UNCONFIRMED |NEW CC||xiscofa...@libreoffice.org Ever confirmed|0 |1 --- Comment #2 from Xisco Faulí --- as an enhancement, it makes sense, not sure whether it will ever be implemented though -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 137147] Provide a way to cancel formula calculation in Calc (e.g., by hitting ESC key)
https://bugs.documentfoundation.org/show_bug.cgi?id=137147 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #1 from m.a.riosv --- Meanwhile, you can disable Menu/Data/Calculate/Autocalculate. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs