SpreadSheet Takes Forever to Open

Issues with installing under all versions of MS Windows

SpreadSheet Takes Forever to Open

Postby blu99 » Sat Oct 20, 2018 4:54 am

I've been using the program for several years and lately it can take up to 5 minutes to open up a saved Spreadsheet. I only have about 200 lines with 6 columns. Nothing fancy and opened up quick all these times and then suddenly slow as can be! I'm using 4.1.5 and even went back to an older version but it didn't make a difference.

Any ideas I would greatly appreciate it!
blu99
 
Posts: 3
Joined: Sat Oct 20, 2018 4:47 am

Re: SpreadSheet Takes Forever to Open

Postby RoryOF » Sat Oct 20, 2018 10:50 am

Check /Edit /Links to see if there are internet links you don't know about.
Apache OpenOffice 4.1.7 on Xubuntu 18.04.4 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31212
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: SpreadSheet Takes Forever to Open

Postby John_Ha » Sat Oct 20, 2018 3:00 pm

A bad Windows 10 update was reported to cause problems like this.

Upload the file for it to analysed.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 7760
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: SpreadSheet Takes Forever to Open

Postby blu99 » Sat Oct 20, 2018 3:18 pm

How do I upload the file John?

Am waiting for it to open now to check the LINKS
Windows 10..........OpenOffice 4.1.5
blu99
 
Posts: 3
Joined: Sat Oct 20, 2018 4:47 am

Re: SpreadSheet Takes Forever to Open

Postby jrkrideau » Sat Oct 20, 2018 3:56 pm

LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3785
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

Re: SpreadSheet Takes Forever to Open

Postby John_Ha » Sat Oct 20, 2018 5:14 pm

Use the Upload attachment tab below where you type (128 kB max) or use a file share site, Dropbox or Google Drive for a larger file.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 7760
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: SpreadSheet Takes Forever to Open

Postby blu99 » Sun Oct 21, 2018 3:29 am

John,

I don't want to upload the file because it's a spreadsheet with my sales on a certain website, costs, fees, etc.

Guess I'll just have to put up with it taking forever to open up.
Windows 10..........OpenOffice 4.1.5
blu99
 
Posts: 3
Joined: Sat Oct 20, 2018 4:47 am

Re: SpreadSheet Takes Forever to Open

Postby robleyd » Sun Oct 21, 2018 3:40 am

The link How to upload a file jkrideau provided above also contains information on how to anonymise your document if it contains confidential information.
Cheers
David
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 3389
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: SpreadSheet Takes Forever to Open

Postby John_Ha » Sun Oct 21, 2018 12:00 pm

You can obscure the contents without affecting the structure too much (lines will spill differently because different characters have different widths) by changing every alphabetic character to an " x " with

Edit > Find and Replace
Tick Regular expressions (under More ...)
Find box [:alpha:]
Replace box x
click Replace all

Now type random values in the cells if you are paranoid about security ...
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 7760
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: SpreadSheet Takes Forever to Open

Postby karlespy » Tue Dec 03, 2019 12:17 am

This may or may not help but when I ran into this problem I found that for some reason my spreadsheet data/formulas had extended to a maximum row in the millions. I discovered this by pressing Cntrl-End and found myself at a location far beyond any actual data I had entered. Note: I had formulas that were invisible unless certain evaluation criteria were met so there was not a visual cue to the fact that these formulas had somehow been extended far beyond the originally set limits.

So... try pressing Ctrl-End and see when you end up. If it takes you to a location off the charts of what you expect then look for the offending rows/columns and do a bulk delete of the offending data/formulas... and be prepared to wait a while while the deletion takes place and completes. In my case, these were spreadsheets originally created in Excel then loaded into either OpenOffice or Libre Office and then saved as ods files. The load times for the original Excel formatted files remained fine, but the ods file loads extended up to 5 minutes for very small spreadsheets, albeit with multiple graphs which I had wrongly assumed to somehow be the culprit.

Hope this helps someone
OpenOffice 4.1.7 on Windows 10
karlespy
 
Posts: 1
Joined: Tue Dec 03, 2019 12:00 am


Return to MS Windows

Who is online

Users browsing this forum: No registered users and 3 guests