Comment 0 for bug 663110

Binary package hint: openoffice.org

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.

This happens to me using OOo 3.2.1 in Ubuntu, so it started hapenning with Maverick when 3.2.1 started being shipped. I'm not able to reproduce it using 3.2.1 under Windows, or version 3.2.0 in Fedora 13.

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: openoffice.org 1:3.2.1-7ubuntu1
ProcVersionSignature: Ubuntu 2.6.35-22.34-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
NonfreeKernelModules: nvidia
Architecture: i386
Date: Tue Oct 19 08:30:41 2010
ProcEnviron:
 LANGUAGE=en_US:en
 LANG=en_US.utf8
 SHELL=/bin/tcsh
SourcePackage: openoffice.org