Comment 2 for bug 238548

Revision history for this message
Romano Giannetti (romano-giannetti) wrote : Re: oocalc give wrong vlookup results with "+" characters on string

Ok, I answer to myself:

Looking at http://www.openoffice.org/issues/show_bug.cgi?id=44295

it seems not a bug. Disabling regexp in expressions it works as expected by me (although going thru Tools->Options->Calc->Calculate does not suffice; you have to close/reload the sheet to have it working).

Nevertheless, it's an unexpected results. I know what a regexp is, but most of people (at least people I know) have no hints. The default is at least a bit dangerous...

Please close the bug if you think that this is the RightWay(tm), nevertheless. That's just an opinion...