Re: [libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File

H Vinod,

Vinod Nadiadwala wrote (25-09-11 18:31)

> 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,

Well, there is difference indeed. Especially with very large documents. 
(Good news is that devs work on improving that - will take some time of 
course.)

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

Opens in 30 seconds (on my test LibreOffice). But still strange slow 
behaviour...

However, the file turns out to have 41472 empty (?) graphics on the 
second sheet ...
I removed those with a macro (1), and it works fine now, I think.
File size 8,4 MB > 44 KB :-)

I send it to you right away.

Regards,
Cor

1)
Sub RemoveDSortOfGhostGraphics
        Dim oDrawPage, oGraph
        Dim i&, j&

        oDrawPage = ThisComponent.getDrawPages.getByIndex(1)
        j = oDrawPage.Count
        
        for i = j-1 to 0 step -1
                oGraph = oDrawPage.getByIndex(i)
                oGraph.dispose()
        Next
        
End Sub



--
 - Cor
 - http://nl.libreoffice.org


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted