I have a document that among other things takes a string from one cell, looks it up in another sheet, and returns the corresponding number value. for some reason, some of the values seem to match incorrectly. the search vector is quite long, but there are no doubles. e.g. when searching for "molle05", the value for "marked20" is returned. I have sorted the search vector, and the function should be correct, since mostly the return values are correct.

the function looks like this: 'LOOKUP($D58;$priser.$A$3:$A$577;priser.C$3:C$577)'

It's been a few years since I did spreadsheet lookups. My suspicion would be the use of absolute cell addresses may be causing the problem.

the problem is that the wrong returns only show up for certain items, most items work fine.

I'm also seeing something like this. It appears to be the behaviour described in https://bugs.launchpad.net/ubuntu/+s...rg/+bug/388803 and applies to oocalc at v2.4 (on EEEPC) and 3.0 (on Gentoo - binary package)

Anyone know if it's ever going to get fixed?