[Solved] File is slow to open

Discuss the spreadsheet application
Post Reply
stormygate29
Posts: 6
Joined: Thu Mar 30, 2023 10:04 am

[Solved] File is slow to open

Post by stormygate29 »

Hi all,

Can you Help Me With this. Always slow and Hang when I opening this file.

Attached is the sample file .

Any solution on this. I Already edit and create new file with same format. Still Slow Opening. Same with Libre office. when i Add another row and column or copying.

Thanks In advance
Attachments
test3.rar
(113.97 KiB) Downloaded 41 times
Last edited by Hagar Delest on Wed May 31, 2023 11:52 am, edited 1 time in total.
Open Office 3.4 / Windows 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Help!!When I opening OPen Office. File always hang and Slow to Open

Post by FJCC »

If you look in the Navigator (menu View -> Navigator or click its icon in the Sidebar), you can see that there are entries under OLE Objects and Drawing Objects. The OLE object is named Object3. There are hundreds of Drawing Objects. All of them seem to have a zero display size, though I only sampled from the long list. If you delete the drawing objects and OLE object, I expect your document will behave correctly. The only way I know to delete the objects is to double click on each one in the Navigator and then press the Delete key. It would probably be quicker to reconstruct the spreadsheet.
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.
stormygate29
Posts: 6
Joined: Thu Mar 30, 2023 10:04 am

Re: Help!!When I opening OPen Office. File always hang and Slow to Open

Post by stormygate29 »

Did You tried the attached File?

It is the same in your end?
Open Office 3.4 / Windows 10
User avatar
Hagar Delest
Moderator
Posts: 32628
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: File always hang and Slow to Open

Post by Hagar Delest »

Of course the comments by FJCC apply to your file.
Open the Navigator (F5) and you will see those drawing objects.

I remember such issue in this forum with zero-width drawing objects but can't find that topic.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
stormygate29
Posts: 6
Joined: Thu Mar 30, 2023 10:04 am

Re: File always hang and Slow to Open

Post by stormygate29 »

Hi sir,

Apology,

Thank you for your assistance. Already done. it's work Perfectly.

What is the reason behind that?
Open Office 3.4 / Windows 10
User avatar
Hagar Delest
Moderator
Posts: 32628
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: [Solved] File always hang and Slow to Open

Post by Hagar Delest »

Don't remember. The file may have been converted from a MS Excel file and something may have confused the import filter.
A bug that may have duplicated that object, or it may have been duplicated by you without you knowing it when duplicating cells/rows/columns because it was invisible.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Post Reply