| View previous topic :: View next topic |
| Author |
Message |
WigBaM
Newbie
Joined: 10 Dec 2006
Posts: 3
|
 Posted: Sun Dec 10, 2006 2:20 pm Post subject: Calc Range.Find method ? |
 |
|
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 |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Dec 10, 2006 3:05 pm Post subject: |
|
|
Search this forum and the snippets forum for SearchDescriptor and Calc.
_________________
Rest in peace, oooforum.org
Get help on http://forum.openoffice.org |
|
| Back to top |
|
|
WigBaM
Newbie
Joined: 10 Dec 2006
Posts: 3
|
| Posted: Sun Dec 10, 2006 4:52 pm Post subject: |
|
|
| 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 |
|
|
noranthon
Super User
Joined: 07 Jul 2005
Posts: 3318
|
|
| Back to top |
|
|
WigBaM
Newbie
Joined: 10 Dec 2006
Posts: 3
|
| Posted: Mon Dec 11, 2006 4:30 am Post subject: |
|
|
| Thank you, I will look into them! |
|
| Back to top |
|
|
|
