[users] Searching a spreadsheet...

[Johnny Andersson]

Hi!
Can anyone provide me with a link to where I can find ALL properties for  
the Search/Replace descriptor for searching/replacing stuff in a  
spreadsheet?

All I found was this:
http://api.openoffice.org/docs/common/ref/com/sun/star/util/SearchDescriptor.html
However, this seems to be the text document search. The following  
properties are mentioned:
SearchBackwards
SearchCaseSensitive
SearchWords
SearchRegularExpression
SearchStyles
SearchSimilarity
SearchSimilarityRelax
SearchSimilarityRemove
SearchSimilarityAdd
SearchSimilarityExchange

When searching a text document manually, I can verify that these  
properties above are the same as those checkboxes in the Writer  
Seach/replace dialog.

The Calc Search/Replace dialog has a few more features, which are not  
mentioned above. Since I run the Swedish version of OOo 1.1.4 I have to  
make some wild guesses about the English names of those radiobuttons and  
checkboxes of the Calc Search/Replace dialog:

The SearchWords property seems to be replaced by something that could be  
called SearchWholeCells or something like that.

There's a "More >>" button, and when I click it the following stuff are  
available:
Search in:
	Formulas
	Values
	Notes

Search direction:
        Rows
        Columns
Additions:
        Search in all spreadsheets (or something like that)

Those are not mentioned at  
http://api.openoffice.org/docs/common/ref/com/sun/star/util/SearchDescriptor.html,  
so where can I find information about it?

Maybe you wonder what I want to do, so here it is:
I want to write a Macro which search a selected range for a specific  
string or value. I want the following settings:
Search whole cells only
Case sensitive
Search in Values
Search direction: Columns (for example C10, C11, C12, C13,......, C53,  
D10, D11 and so on, until end of selected CellRange).

I know that I can search one cell at a time, but I thought that using the  
built in search thing might give me a little faster macro.

Is it possible, when using Search/Replace, to get the cell address from  
the cell in which a match was found? Or at least any kind of information  
which I can use to find other stuff in the same row easily.

Any suggetions will be appreciated!
Thanks!
--
Johnny Andersson
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]