To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=91693
------- Additional comments from npo...@openoffice.org Tue Apr 7 10:49:58
+0000 2009 -------
I am struggling to understand the corrolation between the images attached and
any concerns raised. But I'll attempt to do that.
Before doing that though I would say that it pays to actually run the test
document, unfortunately the test document is a little misleading, you press the
button and it says fail. It doesn't seem to be pointed out anywhere that this is
the expected result. If you then modify the macro code and uncomment the line
'Set rg = Range("A1")
you will get "True" result
these are the expected results and reflect what happens when you run the same
example and do the same steps in Excel.
so, back to the images
i91693_1.jpg:
looks like a macro run in non vba compatibility mode trying to define a
variable as the Range type. But.. without vba compatibility it knows nothing
about the range object, that would be the expected result
i91693_2.jpg:
is this not the same thing, attempting to access the Range object? again this
fails as expected
i91693_3.jpg:
this is what the bug is about right? that line causes an error in "NON" vba
mode, and afaic the macros here are running in "NON" vba mode and still cause
the same error, again expected result
i91693_4.jpg:
I can't actually work out what this is about, it just seems like the same
picture as before.
it seems to me you are confused about compatibility, vba mode really only works
when running macros imported from an xl documents, there is the 'Option
VBASupport 1' directive that you can use to trigger that mode, but you mileage
may vary when using that ( especially in non document basic or non xl documents
)
---------------------------------------------------------------------
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...@script.openoffice.org
For additional commands, e-mail: issues-h...@script.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
