https://bugs.freedesktop.org/show_bug.cgi?id=35644
--- Comment #5 from [email protected] 2011-11-01 06:05:27 UTC --- I've come across a similar problem with LibreOffice 3.4.3 000340m1 (build 302) for Windows, running on XP. I get 4 of these error messages for every macro function in the module that is in the spreadsheet. For a large spreadsheet with lots of macro calls it quickly becomes unfeasible to keep on dismissing the error dialogs. As the error dialog blocks access to the menu the only option is to use the task manager to kill the process, losing any changes to the file. In my circumstances the problem happens when I've a vbasic function that I'm still writing (and so isn't complete or syntactically correct yet) but isn't used by anything, and where the module has other functions that are used in the spreadsheet. Sometimes if I do a save (or if the autosave runs) I'll get these error dialogs, for a big spreadsheet the only way out is to kill the process and lose the unfinished changes. More reliably this happens if I open a spreadsheet that contains an unused, but unfinished, vbasic function. Consider the following example in the file's module: REM ***** BASIC ***** Public Function test_macro(x As Double, y As Double, c As Double) As Double On Error Goto ErrorHandler test_macro = (x+y)^2 Exit Function ErrorHandler: End Function Public Function test_macro_unfinished(x As Double, y As Double) As Double On Error Goto ErrorHandler test_macro_unfinished = (x+y)^ Exit Function ErrorHandler: End Function The function 'test_macro_unfinished' is incomplete. In the spreadsheet add some calls to 'test_macro'. Save the file. On opening it again I get 4 error dialogs (reporting the incomplete line in 'test_macro_unfinished') for every use of 'test_macro'. I can accept the error being reported once, but for a large spreadsheet repeatedly reporting it makes the file unusable. -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. _______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
