To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63614
User bmarcelly changed the following:
What |Old value |New value
================================================================================
CC|'hba,ms7777' |'bmarcelly,hba,ms7777'
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Fri Nov 7 17:16:01 +0000
2008 -------
Another example, in the hope that some developer tackles the problem...
Option Explicit
Sub Main
Dim g as double
g = 0
print g, SkipZero(g)
print g, SkipZero(g)
End Sub
function SkipZero(grandeur As Double) As Double
SkipZero = IIF(grandeur=0 , 1, grandeur)
end function
Run the macro Main, the first call to SkipZero is OK but the second call throws
error
"Inconsistent type of data" at the line with the IIF instruction.
If the bug does not appear, change the value of g to 1 and run again. Then
change
the value back to 0 and run again, it will appear.
Once triggered, the error can also appear during evaluation of a cell formula
calling
SkipZero.
I can reproduce the bug on Windows XP with OOo 3.0.0, 2.4.2RC1, 1.1.5
If this instruction cannot be corrected it would be fair to document it as
"discontinued, do not use" in the help (F1).
---------------------------------------------------------------------
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
