Re: [libreoffice-users] Re: MS Excel file macros cause infinite loop of errors

On 02/12/2013 01:34 AM, e-letter wrote:
> On 11/02/2013, todd.e.moore <todd.e.moore@gmail.com> wrote:
> > Originally I posted under my todd.moore@dynamicsystemsinc.com
> > account.Unfortunately, I need the macros enabled.  The spreadsheet is
> > developed by another company and includes features/functions that we must
> > use to properly submit requests.The behavior I observe is that after
> > changing security settings to allow the macros to run, I receive a macro
> > execution error that pops up on the screen.  Clicking on the equivalent of
> > "ok", "ignore", "cancel" just displays another error message.  This
> > continues for what seems about 30 clicks.  Then the boxes no longer appear.
> >
> > Trying to do anything in the UI, even closing the file, starts the error
> > message deluge again.I noticed the issue in v3.x.x and hoped that with
> > v4.0.0 there may have been changes that would cope with the macros in this
> > file.  Unfortunately, the problems persist.Attaching file (1MB zip file
> > containing a single MS Excel ) that causes this issue to occur.
> > File_with_Bad_Macro.zip
> > <http://nabble.documentfoundation.org/file/n4036499/File_with_Bad_Macro.zip>
> Amazed that a private company receives a proprietary file from another
> private company and asks the libre software community to solve a
> proprietary problem.
>
> LO is not an m$ clone. A business that can't afford to pay m$
> licences, most probably shouldn't be in business.
>
> How does odf benefit from LO being used to solve your problem?
>
> Have you contacted the source of the document and asked them to
> re-format the document to ods?
>
> What did they say? ;)
>
> Have you contacted m$ and asked them to make their software easier to
> use with non-m$ products? Did you get a reply ? ;)
>
> How much company time have you wasted, compared to the cost of buying
> a legitimate copy of m$? Is your MD aware?
e-letter

The issue is macro conversion which is tricky at best. As budgets 
tighten many are looking for less expensive or free options for software 
and these issues are important to address in a polite manner not snide 
comments about the validity of their license or how they should use MSO. 
MS does not by their choice have versions of MSO for all OSes so 
depending on your OS you may not even have an option to use MSO.

In previous post, it was noted that the macro may be buggy because it 
apparently does not always run correctly in Excel (2003). So there may 
have two independent problems: a buggy macro and macro 
conversion/interoperability.

Macros are the hardest area to convert because of differences in the 
APIs between MSO and LO.

--
Jay Lozier
jslozier@gmail.com


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