Calc crash on copy/paste

English
#1

I have a large spreadsheet (master) which I update regularly (over 3 years now), by copying data from two other simple one-worksheet spreadsheets into two worksheets. There are a number of formulas and vlookups across other sheets, which have always taken some time to actually paste.

Details of the master:
8 worksheets including two pivot tables, 2 data sources (1 with 32 columns and ~50000 rows; the other with 56 columns and 50000 rows), 3 small data sheets that are used for lookup (32 columns x 2200 rows; 8 Columns X 300 rows; 2 columns X 3500 rows) and one “Instructions” sheet which is only text, and some constraint variables for other worksheets.

Details of the pastes:
Data1: 14 columns X 50000 rows
Data2: 54 columns X 50000 rows

Recently, when I do one of the pastes, LO crashes. I have gone back to a known working version and moved forward with the same result. It doesn’t matter which order I do the pastes, one works fine and the other does not. It’s always the same data file that fails. I have rerun the report from source with the same result.

My question is have I reached a limit for the paste? Is it possible for there to be some data in the file Data2 that is causing the crash?

Any suggestions on troubleshooting steps would be appreciated.

Platform Ubuntu 20.04 LTS
LO Version: (was 6.4 but when I started having trouble I upgraded to 7.5.1.2)
Computer: Toshiba Satellite (older) with 8G ram

#2

Welcome!
I don’t think you’re running into this long forgotten problem, but I think it’s worth checking out. Your remark

made me suspicious.

Please, go to the File - Properties - General tab and see what values are on the parameters “Total Editing Time” and “Revision Number”. If there are very large values and they are not dear to you as memory, then try resetting them using the Reset Properties button, save the spreadsheet, close it, open it and try inserting the data again.

#3

Total Edit time was 623:03:17 and revisions # was 45. I reset them, saved the document, then opened and pasted the data2 cells. :frowning: same result - crashed after about 45-60 seconds (I did not time it).

I will try an uninstall and reinstall. Do you think that will be worthwhile? I didn’t really consider that because it was a brand new installation of Ubuntu 20.04LTS because of a drieve crash (drive was replaced). This installed LO6.4, then an upgrade to 7.5.

Interestingly I tried the exact same files and process on another box and it worked. Working box was:
OS: Ubunto 20.04 LTS
LO Version: 7.2.7.2
Processor i5 at 3.20
memory 24G
Properties of the working file:
Total editing time: 623:16:24
Revisions: 46

#4

At least we checked. Unfortunately, my experience with such large spreadsheets is limited - if the data exceeds 500-700 rows, I transfer it to the database. Therefore, I can hardly make useful guesses.

#5

appreciate the help

#6

Makes 2700000 cells, size needed for each cell with content is at least 10 bytes or more, strings more, with formula cells much more. Let’s assume 50 bytes per cell on average for little data would be 128MB. Not much. So what’s in it? Does the target range contain data that needs to be copied for Undo? Images? Charts? …?

Both is possible.

Could you provide a sample document and data to reproduce it and file a bug?

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.