OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Cell address range in Basic function

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API
View previous topic :: View next topic  
Author Message
rharris51
Newbie
Newbie


Joined: 22 Feb 2005
Posts: 1

PostPosted: Tue Feb 22, 2005 1:02 pm    Post subject: Cell address range in Basic function Reply with quote

I'm trying to determine exactly what kind of object is being passed when you pass an array of cells into a Basic function under OpenOffice Calc.

For example, if you were to write a function call like this:

=crossproduct(A1:C1;A2:C2)

and if the function header looked like this

function crossproduct (vec1 as object, vec2 as object) As Variant

What kind of objects would vec1 and vec2 be?
Back to top
View user's profile Send private message
Cybb20
Super User
Super User


Joined: 02 Mar 2004
Posts: 1569
Location: Frankfurt, Germany

PostPosted: Tue Feb 22, 2005 4:25 pm    Post subject: Reply with quote

I suppose it would be :: com :: sun :: star :: table :: XCellRange objects.

Christian
_________________
- Knowledge is Power -
Back to top
View user's profile Send private message Send e-mail
pitonyak
Administrator
Administrator


Joined: 09 Mar 2004
Posts: 3655
Location: Columbus, Ohio, USA

PostPosted: Wed Feb 23, 2005 9:21 am    Post subject: Reply with quote

Search the list for the word "FunctionAccess" for examles. Perhaps, also look at http://www.oooforum.org/forum/viewtopic.phtml?t=14096&highlight=functionaccess
_________________
--
Andrew Pitonyak
http://www.pitonyak.org/oo.php
Back to top
View user's profile Send private message Send e-mail Visit poster's website AIM Address
DannyB
Moderator
Moderator


Joined: 02 Apr 2003
Posts: 3991
Location: Lawrence, Kansas, USA

PostPosted: Sat Feb 26, 2005 10:30 am    Post subject: Reply with quote

Do any of these help? (Especially the t=2929 link?)

Macro functions, multiple parameters, multiple return values
http://www.oooforum.org/forum/viewtopic.php?t=5479
explanation of arrays of cells...
http://www.oooforum.org/forum/viewtopic.php?t=2929
http://www.oooforum.org/forum/viewtopic.php?t=9622

Call Calc built in functions from Macro
http://www.oooforum.org/forum/viewtopic.php?t=3942
http://www.oooforum.org/forum/viewtopic.php?t=5534
http://www.oooforum.org/forum/viewtopic.php?t=5897
Answer given....
http://www.oooforum.org/forum/viewtopic.php?p=21948#21948
http://www.oooforum.org/forum/viewtopic.php?t=1350
How to use callFunction() ?
http://www.oooforum.org/forum/viewtopic.php?t=14096
_________________
Want to make OOo Drawings like the colored flower design to the left?
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Macros and API All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group