[upstream] [hardy] oocalc give wrong vlookup results with "+" characters on string

[Romano Giannetti]

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.

[Romano Giannetti (romano-giannetti)]

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

[Chris Cheney (ccheney)]

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

[Romano Giannetti (romano-giannetti)]

No news here? Thanks

[Björn Michaelsen (bjoern-michaelsen)]

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.