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:jsloz...@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 jsloz...@gmail.com -- For unsubscribe instructions e-mail to: users+h...@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+h...@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