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

There's also the ever-popular testing for an exact floating-point value
[;<).

The OP mentions there being an *exception* loop, so it sounds like LO is
throwing a script error exception message and somehow there is no way out of
it.  

It looks like two things are needed:

 1. The complete, exact exception message about what is wrong.

 2. Opening the document with macros disabled (if that is possible when
conversion from .xls is happening) and extracting the resulting script.

(An alternative is to open the document in Excel, which should allow macro
disabling, and extract the original VBA there.)

Speculating further, it may well be that the VBA has a dependency that can't
be resolved on the users system from LO.  Either way, the script
error/failure behavior of LO needs to be looked into.

 - Dennis

-----Original Message-----
From: Jay Lozier [mailto:jslozier@gmail.com] 
Sent: Monday, February 11, 2013 10:15
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] MS Excel file macros cause infinite loop of
errors

On 02/11/2013 12:52 PM, Todd E. Moore wrote:
> Trying to determine where
>        best to request help.A file sent to me includes VB macros created
in MS Excel.The
>        macro handler in LibreOffice (both 3.6 and 4.0) end up in an
>        exception loop which cannot be stopped unless I kill the process
>        from the system command line.Is there a specific way to address the
Subject line or a different
>        forum/mailing list I should use for requesting help?I wanted to
make sure I send to the correct place before
>        cluttering up folks' Inbox with a hefty file.
Todd

Either upload the file to Nabble or post the file some and provide a link.

I am not expert on macros but infinite loops are caused by a serious 
logic error - not providing a loop exit condition that tests correctly. 
I would expect the problem to in a WHILE/DO loop where there most be an 
exit condition that terminates the loop.

For example

i = 10
While i  > 1 do
     loop body
     i = i + 1

This above will always test TRUE and never exit. I have explicitly shown 
i incrementing.

But the following will exit because the loop condition will eventually 
evaluate to false:

i = 10
While i  < 1000 do
     loop body
     i = i + 1

Another error is for the above examples is to forget to increment i

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


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