Public bug reported: Binary package hint: openoffice.org
This is a very nasty bug. I will attach two files to this report, but: write a table like that: A+ 10 A 9.5 A- 9 B+ 8.5 then do a vlookup(...; 0) on it. If I enter a value A+, the answer is 9.5 instead of 10. If I rename A+ to AP it works as expected. You have an attached file showing the problem. If you save it as excel, and you open it from MS Excel, it will work ok. ** Affects: openoffice.org (Ubuntu) Importance: Undecided Status: New -- 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