Low performance when open xlsx file with many formulas

ONLYOFFICE / DocumentServer

ONLYOFFICE Docs is a free collaborative online office suite comprising viewers and editors for texts, spreadsheets and presentations, forms and PDF, fully compatible with Office Open XML formats: .docx, .xlsx, .pptx and enabling collaborative editing in real time.

https://www.onlyoffice.com

GNU Affero General Public License v3.0

4.48k stars 1.04k forks source link

Low performance when open xlsx file with many formulas #2683

Open fz0000 opened 2 months ago

fz0000 commented 2 months ago

I have an Excel file which has many fomulas. It would cost 1-2 seconds to select an item from the list. I tried on both my local server and the official DocSpace online and there's no difference.

https://github.com/ONLYOFFICE/CommunityServer/assets/5061311/d94ddaaf-37ac-4ff5-9555-0e5e0ab3218b

Is it expected?

The test file is attached. performance-test.xlsx

rsnegirev commented 1 month ago

Hi @fz0000

I can confirm, this is the bug number 49009. When some fixes will be done we'll text you here in this issue.

Thank you for the report!