To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=97210
User sweigel changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Keywords|needmoreinfo |ms_interoperability
--------------------------------------------------------------------------------
OS/Version|Windows Vista |All
--------------------------------------------------------------------------------
Summary|Error message when startin|Error when opening spreads
|g spreadsheet with basic c|heet with VBA that refers
|ode |to a cell in the spreadshe
| |et
--------------------------------------------------------------------------------
Target milestone|--- |OOo 3.1
--------------------------------------------------------------------------------
------- Additional comments from swei...@openoffice.org Sat Dec 13 16:33:23
+0000 2008 -------
Confirming this Issue with
* Windows 2000, OOo 2.4.0
* Windows 2000, OOo 3.0 (OOO300m9)
* Ubuntu 7.10, OOo-dev 3.1.0 (DEV300m37)
When a spreadsheet uses a user defined function, that is realized by VBA and
this function refers to some data in a cell of the spreadsheet, the function
fails during opening of the spreadsheet. This results in an error message (only
in OOo 3.0 and OOo-dev 3.1.0) and the function returns no value (in OOo 2.4.0 as
well as in OOo 3.0 and OOo-dev 3.1.0).
During opening, when the document´s formulas are recalculated, VBA is running
but has no acces to the model yet.
After having opened the spreadsheet one can again recalculate all formulas
manually by SHIFT+CRTL+F9, which finally delivers correct results by the user
defined function.
The scope of this issue is, that Excel spreadsheets with user defined functions
cannot be used with OOo properly. The same is true for ODS documents that have
been created by converting a former Excel document.
You can reproduce this problem using the spreadsheet, that I will attach. It
contains the following simple VBA code:
Option VBASupport 1
function fktFoo()
dim varFoo as variant
msgbox "Hello"
varFoo = activesheet.cells(1,1)
'...
'...
'...
fktFoo = varFoo
msgbox "Hello again"
End function
The critical statement is "activesheet.cells(1,1)" where the functions refers to
a cell in the spreadsheet.
Cell B1 contains the following formula:
=FKTFOO()
When you open this spreadsheet the formula will be recalculated automatically,
but this fails. See the attached screenshot for the exact error message. After
this try SHIFT+CRTL+F9 and the recalculation will be successful.
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
