Description: Hi, A simple spreadsheet used to take 1-2 seconds to save. After I created a few new spreadsheets in the same document that reference a "master spreadsheet" i.e. create abstractions in several smaller spreadsheets, saving takes 3-4 minutes or longer. The fact that it takes a long time is not a factor for me but I'm afraid that one day it will stop completely. Steps to Reproduce: I would like to send the document that is the problem but I have no idea how to post it to you Actual Results: Saving takes very long time (3-4 minutes or longer) Expected Results: Saving should take less time (1-2 sec) Reproducible: Always User Profile Reset: No Additional Info: n/a
Use 'Add an attachment' just above your report description. Please paste here the information on Menu/Help/About LibreOffice (There is an icon to copy)
Created attachment 202631 [details] Test document that shows the problem
It is not possible to upload the document due size. It takes about 2 minutes to open. The spreadsheet "Master" is tiny: 79 rows 15 columns Three spreadsheets in the document 79 rows 1-3 columns These spreadsheets does not contains any but reference data via this type formula: {=Master.B2:B1000} The size is about 12 MB When I remove the extra "read only" spreadsheets the size is 36 KB I have just made a stripped version. calctest.ods that shows the problem: 1. Master called S1 with 4 rows and 3 columns Col1 Col2 Col3 1 1 1 2 2 2 3 3 3 The document size is 10 KB 2. Added a new spreadsheet called S2 with 4 rows and 1 columns Col1 1 2 3 These are references from S1 {=S1.A1:A100} The document size is now 827 KB
The cause is the array formula covering the entire column, not just the first 100. Setting up the array for 100 rows, there is no issue.
Silly me. Sorry about the misstake