To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114968
User wagafo changed the following:
What |Old value |New value
================================================================================
Summary|Macros not being loaded wh|Using match() function mac
|en spreadsheet opened as a|ros are not opened when do
| template |cument is opened as a temp
| |late (in OOo 3.2.1 for Ubu
| |ntu)
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Tue Oct 19 06:20:49
+0000 2010 -------
I've been able to narrow down this issue much more. The problem seems to be
related with the match() function, if I don't include it the macros are opened
when I open the document as a template, when I include it the macros are not
opened (I get an error message of Script could not be ... ).
I create two simple spreadsheets to reproduce.
test1.ods: it just has a macro to open test2.ods as a template, and a button to
trigger the macro.
test2.ods: it has a macro that prints "Hello World", customization to open the
macro both when the file opened as a new document (template) or normally, and a
couple of cells with data and another one with the function match() to read from
these data.
Steps to reproduce:
1) open test2.ods directly, macro is executed.
2) open test1.ods and click the button to open test2.ods as a template, error is
reported and macros are not loaded
3)
a) open test2.ods and erase the cell with the match function, save
b) open test1.ods and click the button to open test2.ods, macro is loaded and
executed without any problem
Including any other function that I tried in test2.ods instead of match() does
not reproduce the problem, as far as I can tell.
1) Open test2.ods di
---------------------------------------------------------------------
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]
