[Libreoffice-bugs] [Bug 137147] New: 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

            Bug ID: 137147
           Summary: Provide a way to cancel formula calculation in Calc
                    (e.g., by hitting ESC key)
           Product: LibreOffice
           Version: Inherited From OOo
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

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.

-- 
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/20200930/9fd9ce4d/attachment-0001.htm>