ONLYOFFICE / DesktopEditors

An office suite that combines text, spreadsheet and presentation editors allowing to create, view and edit local documents
https://www.onlyoffice.com
Other
2.64k stars 311 forks source link

Data Validation accross worksheets cause 10s freeze #1556

Open jakobkilian opened 2 months ago

jakobkilian commented 2 months ago

This issue is unique.

Operating System

macOS 10.12 or higher

Version information

8.0.1 (and other versions and systems)

Expected Behavior

I have data validations in cells asking for lists in other worksheets of the same file. When entering data the UI should stay usable and relating cells should update immediately.

Actual Behavior

OnlyOffice however completely freezes for about 10s-20s no matter whether I enter data in the "sending" or "receiving" cell or any other cell relating to those via formulas. Cells with no relation and no data validation still work.

Reproduction Steps

I tried with the latest Desktop app for Mac, on a community server and the official online demo → the problem is reproduceable on any of them. I attach a file that I narrowed down to the core problem for you to try. E.g. enter something in "data" → "name" and it should freeze on all systems. So my best guess would be that the trigger is data validation taking a list from another sheet (that is concatenated by a formula or sth?)

onlyoffice-data-val-example.xlsx

Additional information

I am happy to help with logs etc but didn't know where to start as this seems to affect all systems...