To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=84277 Issue #|84277 Summary|Calc crashes if cell uses faulty macro for validation Component|Spreadsheet Version|OOo 2.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|silvercapo
------- Additional comments from [EMAIL PROTECTED] Wed Dec 5 18:30:29 +0000 2007 ------- (Actually this was found on OOo 2.3.1 but can't seem to select that in the Bug Reporting tool yet) Calc crashes when using a macro containing errors to generate list of values. STEPS TO REPRODUCE THE PROBLEM 1. Open a new Calc spreadsheet, and define a macro with some errors in it such as: Sub SubContainingErrors ' Some random text that BASIC won't understand This Is Not Code End Sub 2. Select a cell, and goto Data -> Validity 3. In 'Allow', enter 'Cell Range'; and for 'Source', enter 'SubContainingErrors()'; also ensure that 'Show Selection List' is checked. 4. OK the Validity dialog. 5. Click on the dropdown for the cell. The BASIC Interpreter generates a few errors, then Calc informs the user of an unexpected crash. PROPOSED SOLUTION Instead of crashing, the BASIC Interpreter should just generate the runtime errors then allow the user to continue working on the spreadsheet / fix the macro. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]