To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=114968 Issue #|114968 Summary|Macros not being loaded when spreadsheet opened as a t |emplate Component|Spreadsheet Version|OOo 3.2.1 Platform|Unknown URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|wagafo
------- Additional comments from [email protected] Wed Oct 6 18:03:54 +0000 2010 ------- I have a spreadsheet (test.ods) where I have a macro that I use to open another spreadsheet (indexs.ods). This is part of a large package of macros but I have tried to simplify things as much as I can to present this issue. I open the second spreadsheet (indexs.ods) as a template using the following (Basic) code: arg(0).Name="MacroExecutionMode" ' this argument to always arg(0).Value = 4 ' execute macro in open doc arg(1).Name = "AsTemplate" arg(1).Value = True and then after getting the "url" of the spreadsheet Doc = StarDesktop.loadComponentFromURL(Url, "_blank", 0, arg()) The second spreadsheet opens OK but the macros that I have in there are not read into the file. If I open "indexs.ods" directly (that is, not as a template) the macros are loaded perfectly. I open with this same method a bunch of other spreadsheets with macros (about 8 more) and none of them present this problem. This is happening to me under Ubuntu Linux, if I try these same files with OOo 3.2.1 under Windows this does not happen, the template of "indexs.ods" is opened with all the macros as it should. I have tried to find out the difference between "indexs.ods" and the rest of spreadsheet that could be causing this and by the hell of me I can't find any difference. I also tried to install OOo 3.3.0 (beta) under Ubuntu Linux and a couple of trials showed me this started happening also with the other spreadsheets, the ones that under OOo 3.2.1 where still opening as a template and not loosing the macros. I attach test.ods and indexs.ods. "test.ods" is quite simple, it only includes one macro and a button to trigger it. "index.ods" on the other hand is much more complex, I did not simplified, because its only purpose is to try to open it alone, and see that the macros are there, and open it from "test.ods" and see that the macros are lost. Again this happens to me under Ubuntu Linux and not in Windows, using the same OOo 3.2.1 version. --------------------------------------------------------------------- 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]
