[Bug 238548] Re: oocalc give wrong vlookup results with "+" characters on string
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) Status: New => Triaged ** Changed in: openoffice Importance: Unknown => Undecided Bugwatch: OpenOffice.org Issue Tracker #44295 => None Status: Unknown => New ** Summary changed: - oocalc give wrong vlookup results with "+" characters on string + [upstream] [hardy] oocalc give wrong vlookup results with "+" characters on string -- [upstream] [hardy] oocalc give wrong vlookup results with "+" characters on string https://bugs.launchpad.net/bugs/238548 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238548] Re: oocalc give wrong vlookup results with "+" characters on string
** 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 member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238548] 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... -- oocalc give wrong vlookup results with "+" characters on string https://bugs.launchpad.net/bugs/238548 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 238548] Re: oocalc give wrong vlookup results with "+" characters on string
** 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 because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
