To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=102970
Issue #|102970
Summary|Inconsistent casting of an empty variant in a mathemat
|ical formula
Component|Spreadsheet
Version|OOO310m9
Platform|Unknown
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|squenson
------- Additional comments from squen...@openoffice.org Sat Jun 20 16:59:00
+0000 2009 -------
Please execute the following macro:
Sub Test
Dim v(3) as Variant
Dim w as Variant
v(1) = 3
v(3) = 3
w = v(1) + v(2) + v(3)
msgbox w
w = v(1)*1 + v(2)*1 + v(3)*1
msgbox w
End Sub
In the first case, v(2) is evaluated to 0 and w is equal to 6. In the second
case, v(2) is evaluated to 1 as w is equal to 7, this is an inconsistent
behavior.
I suggest that empty variants are always evaluated to 0 in a mathematical
formula or to "" (empty string) in a formula involving strings.
---------------------------------------------------------------------
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
