Hi Johnny,
* Johnny Andersson <[EMAIL PROTECTED]> [090405, 03:16]:
> 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?
> [...]
> 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.
>
When I choose Edit -> Find & Replace (CTRL*F) in my OOo-1.1.4 (English)
the window shows the following items:
Search for -------------------- Find All Find
Replace All Replace
Replace with ------------------ Close
Help
More >> [*]
Options:
Entire cells Match case Similarity search
Backwards Current selection only
Regular expressions Search for Styles
[*] _________________________________________________________________
SEARCH IN SEARCH DIRECTION OPTIONS
Formulas Rows Search all sheets
Values Columns
Notes
I searched one of my spreadsheet for a value which occurs in almost all
the rows, first selecting a particular row and checking the small box
before 'Current selection only' did evidence the value in the selected
row only.
Then I repeated the same steps with the Macro recorder on and was able
to save the steps in a macro. Mind you: I had to press repeatdly the
Find button until it reached the end row, otherwise the macro would stop
at the first occurrence of the value.
May some Macro experts can suggest a better way to attain that, as I
realize it's not very practical: you must know in advance how many times
the Find button must be pressed ;)
HTH
Regards,
Ennio
[OT] Thanks for voting my issue #47012 (I added my 2 votes: I thought I
couldn't not vote for my issue :-) )
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
