Libreoffice Basic Runtime Error 423
[closed] edit common basic_ide excel vba macros asked 2012-07-14 01:41:29 +0200 Stephen Leibowitz 1 ●1 ●2 ●2 updated 2013-01-28 23:22:26 +0200 qubit 9393 ●18 ●87 ●63 I am trying to convert an Excel 2003 VBA macro to LibO. I have fixed the few basic runtime error 12 syntax problems. The heart of the conversion effort will be in dealing with the two run time error 13 very different APIs. My preference is to Open the Excel xla file and have it run until the first runtime error, which I would then fix. I would repeat the cycle of “run and fix” for the other errors. When I encounter an error, I would also search for and fix similar errors, in order to speed up the conversion effort. My problem is that the Basic processor often does not provide the error information that I need. The first error message says, BASIC runtime error. '420' Invalid object reference. The end of the module’s code is displayed, but there is no code highlighted or arrow pointing to a particular line. I have no idea which object the Basic processor is complaining about. Pressing the Stop Macro button has no effect. When I press the OK or X button on the message, the macro continues to the next error. That error is, BASIC runtime error. '12' xlApplication Event. But even without me dismissing the message, the processor continues to the next error after a few seconds I have placed many breakpoints in the code, but this does not seem to help me in isolating the errors. edit retag flag offensive reopen merge delete Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-21 00:28:38.210630 add a comment 1 answer Sort by » oldest newest most voted 1 answered 2013-01-28 23:37:29 +0200 qubit 9393 ●18 ●87 ●63 Hi @Stephen Leibowitz, First, let me congratulate you on trying to translate macro code. That doesn't sound like the easiest job! It sounds like there are a couple of different pieces to your question/your task: You're trying to convert some code from VBA to LOBasic and would like help You're running into some limitations of the current Basic IDE in LO You might be running into some bugs with LOBasic or the IDE As far as #2 and #3 go, it could be very helpful if you could file a bug (or a few bugs) about these issues. The QA team will be happy to help you triage bugs into errors vs. enhancements. The specific note about breakpoints not helping/working to help isolate errors sounds like something very important to ad
error code. Syntax: Error (Expression) Return value: String Parameters: Expression: Any numeric expression that contains the error code of the error message that you want to return. If no parameters are passed, the Error function returns the error message of the most recent error that occurred during program execution. Error Codes 1 An exception occurred 2 Syntax error 3 Return without Gosub 4 Incorrect entry; please retry 5 Invalid procedure call 6 Overflow 7 Not enough memory 8 Array already dimensioned 9 Index out of defined range 10 Duplicate definition 11 Division by zero 12 Variable not defined 13 Data type mismatch 14 Invalid parameter 18 Process interrupted by user 20 http://ask.libreoffice.org/en/question/3879/basic-runtime-errors/ Resume without error 28 Not enough stack memory 35 Sub-procedure or function procedure not defined 48 Error loading DLL file 49 Wrong DLL call convention 51 Internal error 52 Invalid file name or file number 53 File not found 54 Incorrect file mode 55 File already open 57 Device I/O error 58 File already exists 59 Incorrect record length 61 Disk or hard drive full 62 Reading exceeds EOF 63 Incorrect record number 67 Too many files 68 Device not available https://help.libreoffice.org/Basic/Error_Function_Runtime 70 Access denied 71 Disk not ready 73 Not implemented 74 Renaming on different drives impossible 75 Path/file access error 76 Path not found 91 Object variable not set 93 Invalid string pattern 94 Use of zero not permitted 250 DDE Error 280 Awaiting response to DDE connection 281 No DDE channels available 282 No application responded to DDE connect initiation 283 Too many applications responded to DDE connect initiation 284 DDE channel locked 285 External application cannot execute DDE operation 286 Timeout while waiting for DDE response 287 user pressed ESCAPE during DDE operation 288 External application busy 289 DDE operation without data 290 Data are in wrong format 291 External application has been terminated 292 DDE connection interrupted or modified 293 DDE method invoked with no channel open 294 Invalid DDE link format 295 DDE message has been lost 296 Paste link already performed 297 Link mode cannot be set due to invalid link topic 298 DDE requires the DDEML.DLL file 323 Module cannot be loaded; invalid format 341 Invalid object index 366 Object is not available 380 Incorrect property value 382 This property is read-only 394 This property is write-only 420 Invalid object reference 423 Property or method not found 424 Object required 425 Invalid use of an object 430 OLE Automation is not supported by this object 438 This property or method is not supported by the object 440 OLE automation error 445 This action is no
BASIC: BASIC runtime error '423' OnSheetActivate Summary: BASIC: BASIC runtime error '423' OnSheetActivate Status: https://bugs.documentfoundation.org/show_bug.cgi?id=58541 NEW Alias: None Product: LibreOffice Classification: Unclassified Component: BASIC (show https://bugs.freedesktop.org/buglist.cgi?product=LibreOffice&component=BASIC&resolution=--- other bugs) Version: (earliest affected) 3.6.4.3 release Hardware: Other Linux (All) Importance: medium normal Assignee: Not Assigned QA Contact: URL: Whiteboard: BSA Keywords: Depends on: Blocks: Reported: 2012-12-19 21:54 UTC by Ron Johnson Modified: 2016-09-20 09:41 UTC (History) CC List: 3 users time error (show) lemoyne.castle sbergman serval2412 See Also: Crash report or crash signature: Attachments Spreadsheet that fails. (488.50 KB, application/vnd.ms-excel) 2012-12-19 21:54 UTC, Ron Johnson Details bt with symbols on master (17.98 KB, text/plain) 2014-02-09 16:33 UTC, Julien Nabet Details console+bt with debug symbols (18.60 KB, text/plain) 2015-05-22 23:58 UTC, Julien Nabet Details Show Obsolete (1) basic runtime error View All Add an attachment (proposed patch, testcase, etc.) Note You need to log in before you can comment on or make changes to this bug. Description Ron Johnson 2012-12-19 21:54:04 UTC Created attachment 71827 [details] Spreadsheet that fails. Problem description: Steps to reproduce: 1. Open the relevant xls file Current behavior: 1. The specified error message pop-up box appears. Expected behavior: 1. The script works as expected Operating System: Ubuntu Version: 3.6.4.3 release Comment 1 Ron Johnson 2012-12-29 15:55:17 UTC By marking it as UNCONFIRMED, does that mean that the attached spreadsheet worked for you? Comment 2 LeMoyne Castle 2013-01-01 02:24:59 UTC @ Ron, The bugzilla system starts all bugs as unconfirmed then with multiple reports or qa reproduction the issue goes to New status. I added myself to CC: as someone interested in BASIC implementation: I wanted to know if someone else fixed it and to be able to find the bug later (without assigning myself). On down