Re: [libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File
Hi Bill, Bill Gradwohl wrote (25-09-11 23:59) On 09/25/2011 12:37 PM, Cor Nouws wrote: However, the file turns out to have 41472 empty (?) graphics on the second sheet ... This creation of objects is earily similar to the problems I encountered where I would have numerous hidden buttons on a spreadsheet that I never created. My document was created and used only under OO / LO, never Excel. Could the interpretation of the Excel document involve an internal conversion to LO xml and then a read of that xml to actually load the spreadsheet? Yes, I think so. I'm convinced the xml writing/reading is the source of many of the issues I've seen. Thanks for your comments. Looking at the findings of various people here, I think this spreadsheet is a good candidate for bugzilla, so that the devs can find out the source of the problem.. Cheers, -- - Cor - http://nl.libreoffice.org -- For unsubscribe instructions e-mail to: users+h...@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
[libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File
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) Vinu -- For unsubscribe instructions e-mail to: users+h...@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
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+h...@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
Re: [libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File
On 09/25/2011 12:37 PM, Cor Nouws wrote: However, the file turns out to have 41472 empty (?) graphics on the second sheet ... Cor: This creation of objects is earily similar to the problems I encountered where I would have numerous hidden buttons on a spreadsheet that I never created. My document was created and used only under OO / LO, never Excel. Could the interpretation of the Excel document involve an internal conversion to LO xml and then a read of that xml to actually load the spreadsheet? I'm convinced the xml writing/reading is the source of many of the issues I've seen. -- Bill Gradwohl -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File
With the navigator [F5] you can see that there are a lot of drawing objects. Regards Miguel Ángel El 25/09/11 18:31, Vinod Nadiadwala escribió: 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) Vinu -- For unsubscribe instructions e-mail to: users+h...@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
Re: [libreoffice-users] LibreOffice / OpenOffice Calc very slow with Excel File
Hi I suggest you to do this (I did and it was good with your sample.xls file)(But I did with OpenOffice 3.2 but I supposed it will be good too with LO): 1) Open file with LO. 2) Save file in format microsoft excel 5.0 (xls) with Save As Menu I did and the file was opened fast and well. Then I used that file to save as .ods and all was well too. Regards, Jorge Rodríguez ___ El dom, 25-09-2011 a las 22:01 +0530, Vinod Nadiadwala escribió: 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) Vinu -- Atentamente, Jorge Rodríguez -- For unsubscribe instructions e-mail to: users+h...@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