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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs