[Solved] Calc is slow with this file

Discuss the spreadsheet application
Post Reply
Ruslan_Smirnoff
Posts: 1
Joined: Tue Mar 29, 2011 9:17 am

[Solved] Calc is slow with this file

Post by Ruslan_Smirnoff »

If i open in calc attached file - the program starts to run slowly.
file is attached in RAR archive.
Attachments
1234567.rar
(53.33 KiB) Downloaded 117 times
Last edited by Hagar Delest on Tue Mar 29, 2011 3:46 pm, edited 1 time in total.
Reason: tagged [Solved].
OpenOffice 3.2.1 on Windows XP SP3
User avatar
Villeroy
Volunteer
Posts: 31319
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc is slow with this file

Post by Villeroy »

There are several hundreds of useless object.
Select the whole used print range.
menu:Edit>Delete Contents... Delete Objects only.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Hagar Delest
Moderator
Posts: 32783
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Calc is slow with this file

Post by Hagar Delest »

Hi and welcome to the forum!

At first sight, there are a lot of Draw lines in this file, I guess it's linked to that. I've tried to remove them from the content.xml file but I have missed a tag in the XML structure it seems.

If the file come from an MS Excel file (as I suppose according to some parts of the content.xml), could you detail what was in the original file (especially the graphics)?

NB: I tried to open your file but indeed, had to kill OOo after several minutes (hardware is a 3 years old laptop with 2GB RAM and 2GHz CPU)!

NB: it may also be linked to the print area indeed, there some strange values for the rows to be repeated it seems.
LibreOffice 24.2 on Xubuntu 24.04 and 7.6.4.1 portable on Windows 10
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Calc is slow with this file

Post by JohnSUN-Pensioner »

The problem was solved by the open in Gnumeric and conservation without unnecessary details.
Сопоставим.JPG
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Post Reply