Jahn, Ray (R.) wrote:
I have searched both the application help and mail archives (sc-users,
sc-dev) for how to search a cell range of dates, with no success yet.
Please accept my apology if this is a trivial question.
* interactive search
What menu command sequence?
Web page or document of examples?
It's "Find & Replace" from the "Edit" menu, just like any other search.
The text that is searched is the same that is shown in the input line,
that is, it depends on the cell's number format type (date in this case)
and language, but not the format itself.
* programmatic search - OO basic
Web page or document of example code?
The data structure created by sht.createSearchDescriptor() seems to work
mainly for string regular expressions and numbers.
It works just the same way for date values, in all languages.
If you don't want to handle strings with all their problems
(locale-dependencies), you'll have to query for all date cells and
compare each cell's value.
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
