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