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

Calc Range.Find method ?

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


Joined: 10 Dec 2006
Posts: 3

PostPosted: Sun Dec 10, 2006 2:20 pm    Post subject: Calc Range.Find method ? Reply with quote

I was in the process of porting of VBA Excel macro to Calc and everything was going well, until I stumbled upon this one:
In Excel I use:
Code:
Set FoundRange = ThisWorkbook.Sheets("Sheet1").Range("A1:M1").Find(What:="blabla", LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False)

After spending hafl an hour looking for clues in various documentations (including "porting gude")I finally decided to ask here - how do I do the same thing in OO?
Back to top
View user's profile Send private message
Villeroy
Super User
Super User


Joined: 04 Oct 2004
Posts: 10106
Location: Germany

PostPosted: Sun Dec 10, 2006 3:05 pm    Post subject: Reply with quote

Search this forum and the snippets forum for SearchDescriptor and Calc.
_________________
Rest in peace, oooforum.org
Get help on https://forum.openoffice.org
Back to top
View user's profile Send private message
WigBaM
Newbie
Newbie


Joined: 10 Dec 2006
Posts: 3

PostPosted: Sun Dec 10, 2006 4:52 pm    Post subject: Reply with quote

I tried searching in here 1st thing, obviously (and in regards to searching this forum -> search feature is not very advanced, to be honest) And If I search for, lets say '+Find +range' etc. it gives me 42 pages to look through!
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Sun Dec 10, 2006 8:10 pm    Post subject: Reply with quote

SearchDescriptor is a term used in StarBasic.

It seems you lack the Xray tool and the SDK. They are indispensable.

Also, visit Andrew Pitonyak's site. There are some other resources mentioned in this and the following post.

In the meantime, here is the relevant API page.
_________________
search forum by month
Back to top
View user's profile Send private message
WigBaM
Newbie
Newbie


Joined: 10 Dec 2006
Posts: 3

PostPosted: Mon Dec 11, 2006 4:30 am    Post subject: Reply with quote

Thank you, I will look into them!
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