To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=110821
Issue #|110821
Summary|extensions: automation bridge/ooo-basic doesn't unders
|tand com default method
Component|framework
Version|DEV300m76
Platform|PC
URL|
OS/Version|All
Status|NEW
Status whiteboard|
Keywords|
Resolution|
Issue type|PATCH
Priority|P3
Subcomponent|code
Assigned to|ab
Reported by|npower
------- Additional comments from npo...@openoffice.org Mon Apr 12 17:23:22
+0000 2010 -------
COM objects can have default members, those members can be properties or
methods, already for vba support in basic we have a concept of default members &
default properties ( exposed via XDefaultMethod & XDefaultProperty ) this
loosely maps to the COM concept of default members ( note: we have a default
method to fake use of properties that take parameters which of course is an
alien concept for uno )
The automation bridge though cannot tell basic about these default members, the
(tobe attached) patch exposes the missing information about the default member
to basic. This allow constructs like
Sheets(1).Cells(L, 1) = rs.Fields("PartNo#")
to work. In the example line above rs is a ADODB.Recordset object ( returned
from the automation bridge )
Fields("PartNo#") calls a default member called 'Item' ( the collection iterator
method ) with the index "PartNo#" this returns a 'Field' object which has a
default 'property' value which is assigned to the Range returned from
"Sheets(1).Cells(L, 1)" - I will attach a sample document containing the above
example. Naturally when running on windows ( without the patch ) the test
document fails miserably, with the patch you should get a message box telling
you "looped 9 times" and the cells A1:B9 should contain values like those below
A | B
=========================
20090324 073237 | M0103A
20090324 033719 | M0104A
20090324 033733 | M0104A
20090324 033740 | M0104A
20090324 033757 | M0104A
20090324 033757 | M0104A
20090324 033757 | M0104A
20090324 033803 | M0104A
20090324 033810 | M0104A
---------------------------------------------------------------------
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...@framework.openoffice.org
For additional commands, e-mail: issues-h...@framework.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
