Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


That fixed it as I'm now on 3.6.4.3 and it works much better. Thanks :-D. I am not sure what would 
cause such a huge difference but I am glad it works. 

----- Original Message -----
From: "Dan Lewis" <elderdanlewis@gmail.com> 
To: users@global.libreoffice.org 
Sent: Sunday, December 30, 2012 8:23:35 PM 
Subject: Re: [libreoffice-users] Calc Compatibility with xlsm 

On 12/30/2012 07:40 PM, mdovell@comcast.net wrote: 
My apologies if this may have been posted before. I searched back in the archives about four 
months and did not find anything. 
I am currently using LibreOffice 3.6.0.2 and have been trying to use the xlsm files featured here 
https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010.htm I find it 
odd that some xlsm files do open but not these ones. Is there a size limit or compatibility issue 
with xlsm files on some level? If so is there a plugin that can help open them? Thank you for 
your time. 
I was able to open all 3 xlxm files using LO 3.6.4.3 or 4.0.0.0 
(Beta2) on a 32 bit system with 2 GB RAM. The third one contains at 
least one macro. I do note that LO 3.5.7.2 crashed when trying to open 
the third file. All of these were downloaded from the LibreOffice 
website. I also have LO 3.5.4 from the Ubuntu repositories. It opened 
the first and third files; the latter took a long time to load. I 
guessing that there were a large number of macros that had to be 
disabled as the spreadsheet was loading. (I did not try to open the 
second file with LO from Ubuntu.) 
If the large number of macros in the third file are what is 
causing the problem, then you need to reset the security settings for 
your LO. (Tools -> Options -> LibreOffice -> Security) If you know that 
the macros are safe to run, reset your security settings for files 
coming from this particular location. To do this download the files into 
a special folder that will only contain files for this course. Then 
listed the folder as a trusted source. When you do this, macros will run 
in any file in this folder. Just make sure files in this folder contain 
only macros that are safe to run. 

--Dan 

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

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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.