LibO / OOo Calc very slow with Excel File

[thinwala]

Hi, there
I am using LibreOffice 3.4.3 on Windows 7, i am moving my ogranization office suite to LibreOffice from ms-office, but having some issues with large excel files, most of the excel files works very very slow with libreoffice, i have searched google but unable to find the solutions, you can download sample file from the following URL which i have uploaded to my organization website.

http://www.bhushitech.com/downloads/sample.xls
(File Size: Around 8 MB )

This is lowest size which i have, if i open this file in excel it works well, but when i try to open it with LibreOffice Calc application it works very slow, i have also tried it with OpenOffice 3.3 but still the issue is same.

I have also tried converting it to the .ODS using fileconverter.com, file size dramatically reduced (Around 300kb only) but still it takes around 15 min to open the file, and after opening if i move cursor it take lot of time to move from one screen to another screen.

(MY PC Configuration is enough good, so the configuration is not an issue, as i have also tried it on IBM X3400 SERVER's with 16 GB Memory)



Flame icon removed. That icon means 'Tagged to a known issue' (TheGurkha, Moderator)

[Villeroy]

Activate sheet #2
Select all cells (Ctrl+A)
Delete contents...
Uncheck all options except "Objects"
Save
The resulting file is 34kB small.

[pnunes]

I have the exact same problem.

I use various excel files witch are 5MB or more in size.

In excel, these files open instantly, while in LibreOffice Calc, they take a lot of time to load or to save.

Is there a way to work around this?

Thanks
PNunes

[mriosv]

There are a lot of hidden object, to see it, F5 (navigator), select drawing object, it's plenty of them.

Open the file,
Menu/Tools/Cell contents - unmark autorecalculate
Go to the first sheet.
Click on the top-right corner to select all the sheet.
Push Backspace
Select only objects.
Ok

The file have now 44Kb.

sample.xls

(44 KiB) Downloaded 265 times

[xbay]

Dear all,

I was facing the same problem, when my network printer was unavailable. Solution was to disable
Tools > Options > Load/Save > General > Load printer settings with the document

Hope that helps.

Alexander