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...
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...