Re: [libreoffice-users] .xlsx file open very slow in OO

Hi :)
I guess you mean LibreOffice rather than OpenOffice?  

Before opening the file try changing the "memory" settings in LibreOffice
Tools - Options - Advanced (or might be "Memory" straight-away)
Boost all these by quite a lot.  If you have over 1Gb of Ram then you could easily boost them so 
that files can have lots of images over 10-15Mb each.  The file might open faster now.  


As people keep pointing out the formats that end in X are MS proprietary formats and change a bit 
with each release of MS Office.  it's far better to get people to use the older formats that don't 
have an X on the end or FAR better is to use Ods.  Have you tried opening the file in a different 
version of MS Office?  if it was fast in MSO 2007 is it still fast in MSO 2010?  

The file probably contains tons of heavy images or something.  We can have a sneaky look without 
even opening the file! :)  Without opening the XlsX can you just 
1.  create a copy of it
2.  rename the copy so instead of being .XlsX it's .Zip
3.  double-click the zip-file to open it
You will see various folders and one should be "images", "photos", "pictures" or something like 
that.  There's only about 4 folders so you could have a look in each one quite quickly.  When you 
find the images you can probably see their sizes.  Are any close to 1Mb or over?  I am not sure but 
i think you can drag them out of the zip-file's folder and then use Gimp to scale them and then put 
them back in top replace the heavier versions.  If it works the copy of the file should now open 
faster.  


On the other hand it might be the file contains some bad macros trying to connect with things.  I 
don't know much about macros or if they would slow the thing down but malware has often been spread 
by MS macros or the macros themselves have been malware and just opening the file has infected 
machines.  Many places block macros nowadays.  LibreOffice uses different languages for it's macros 
and so far i've not heard of any containing malware.  

Good luck with this!  Hopefully someone else here might be more helpful than me!
Regards from 
Tom :)  




________________________________
 From: Satish Srivastava <satish.srivastava@fosteringlinux.com>
To: "users@global.libreoffice.org" <users@global.libreoffice.org> 
Sent: Saturday, 31 August 2013, 8:05
Subject: [libreoffice-users] .xlsx file open very slow in OO
 

Dear Friends,

When i am opening .xlsx file in OO it is taking long time to open in every
time.
Why this happen in OO if here some need in changes in configuration So
please suggest me. this file is open very quickly in MSO.


*Thanks & regards*
Satish Srivastava
--

-- 
To unsubscribe e-mail to: users+unsubscribe@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
-- 
To unsubscribe e-mail to: users+unsubscribe@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