** Also affects: openoffice via
http://qa.openoffice.org/issues/show_bug.cgi?id=44295
Importance: Unknown
Status: Unknown
--
oocalc give wrong vlookup results with + characters on string
https://bugs.launchpad.net/bugs/238548
You received this bug notification because you are a
It looks like this bug is probably actually a bug, yes regex is on by
default but it should be treating eg 'A+' not as a function as far as I
can tell, I will forward this as a separate bug to the one that was
previously closed invalid.
Thanks,
Chris
** Changed in: openoffice.org (Ubuntu)
** Attachment added: Example of file where a simple vlookup() fails to give
correct answers.
http://launchpadlibrarian.net/15145123/lookup_no.ods
--
oocalc give wrong vlookup results with + characters on string
https://bugs.launchpad.net/bugs/238548
You received this bug notification
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).
