[Solved] Spreadsheet loads very slowly

Discuss the spreadsheet application
Post Reply
leeelson
Posts: 24
Joined: Mon May 20, 2013 12:20 am

[Solved] Spreadsheet loads very slowly

Post by leeelson »

 Edit: Split from [Solved] Loading a spreadsheet since new person needs new topic. 
I have the same problem. I tried the solutions mentioned here. Copy and paste failed with various fatal errors (4.10). Here is a link to the (rather large) file:
https://drive.google.com/file/d/1m0Q-WS ... sp=sharing
Any help is appreciated.
Last edited by MrProgrammer on Sun Jun 06, 2021 11:04 pm, edited 1 time in total.
Reason: Tagged ✓ [Solved]
OpenOffice 4.1 on Windows 8.1
Top
User avatar
RoryOF
Moderator
Posts: 34613
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: [Solved] Loading a spreadsheet

Post by RoryOF »

It opened for me in 27 secs.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Top
FJCC
Moderator
Posts: 9274
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: [Solved] Loading a spreadsheet

Post by FJCC »

The problem is that the data range for the chart includes all of column E, more than 1 million rows. If I remove that part of the chart's data range, the file size drops to 28 KB. What are you trying to include in the graph?
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Top
Post Reply

Return to “Calc”