To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=115663
User ab changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |WONTFIX
--------------------------------------------------------------------------------
------- Additional comments from a...@openoffice.org Mon Dec 13 11:09:17 +0000
2010 -------
Hi Greg,
I've found the reason for the problem. You are right, the
behavior concerning missing parameters really has changed,
but it has only changed for VBA mode (Option VBASupport 1).
In VBA missing parameters of type object and string are
handled differently. Objects simply become NULL, strings
become empty, but IsMissing returns false. This has been
fixed for VBA mode.
That's exactly what the VBA mode is for: It allows to chan-
ge the OOo Basic behavior in order to improve VBA compatibi-
lity without breaking old OOo Basic programs *not* using
this mode, but there's no way to avoid breaking non VBA
programs that explicitely activate it. Otherwise it would
be impossible to fix issues concerning VBA compatibility.
I don't know why you use "Option VBASupport 1" in an ods do-
cument without using (?) VBA API, but it's kind of "on own
risk". Activating the VBASupport option actually should al-
low to run original VBA macros from Excel documents. Chan-
ging the runtime behavior in this context is no problem as
long as the compatibility improves. Before it wouldn't have
worked correctly anyway.
So to have a stable API you should not use "Option VBASup-
port 1". If you need it for some reason, you sometimes may
have to change your code. In this case you will have to test
for an empty string instead of using IsMissing.
I hope this is acceptable. :-)
Regards
Andreas
-> WONTFIX for the described reasons
---------------------------------------------------------------------
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...@api.openoffice.org
For additional commands, e-mail: issues-h...@api.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
