Suppose I enter the following expression into a cell on a Calc worksheet,
say, cell A1 for convenience:
=FIND("[a-c]","abc123")
Cell A1 will now display "1" as you'd expect.
Now I change this to
=FIND("[^a-c]","abc123")
I would expect cell A1 to now display "4" as that's where the first
character that isn't one of a,b, or c is located.
Instead I see: "!VALUE#"
This happens with every [...] pattern that I've tried. (Of course, I haven't
had time to try them all yet. :-D )
I'm using OpenOffice V2.0.1 with OS X V10.3.9. Is this broken, or am I doing
something wrong?
