OOo 3.2.1 - Using match() function, macros are not opened when document is opened as a template

Bug #663110 reported by Walter Garcia-Fontes
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenOffice
Unknown
Unknown
openoffice.org (Ubuntu)
Invalid
Undecided
Unassigned

Bug Description

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

Revision history for this message
Walter Garcia-Fontes (walter-garcia) wrote :
Revision history for this message
Walter Garcia-Fontes (walter-garcia) wrote :
  • test1.ods Edit (10.8 KiB, application/vnd.oasis.opendocument.spreadsheet)

test1.ods to reproduce this issue

Revision history for this message
Walter Garcia-Fontes (walter-garcia) wrote :
  • test2.ods Edit (9.2 KiB, application/vnd.oasis.opendocument.spreadsheet)

test2.ods to reproduce this issue

Revision history for this message
Walter Garcia-Fontes (walter-garcia) wrote :

I reported this bug also in the OpenOffice but system (qa: Issue 114968, http://qa.openoffice.org/issues/show_bug.cgi?id=114968)

description: updated
Changed in openoffice.org (Ubuntu):
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.