LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Software (http://www.linuxquestions.org/questions/linux-software-2/)
-   -   openoffice calc LOOKUP() returns wrong value (http://www.linuxquestions.org/questions/linux-software-2/openoffice-calc-lookup-returns-wrong-value-559562/)

edgjerp 06-06-2007 06:04 AM

openoffice calc LOOKUP() returns wrong value
 
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)'

bigrigdriver 06-07-2007 05:02 PM

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.

edgjerp 06-08-2007 09:23 AM

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

bdt-rob 06-20-2009 06:08 AM

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?


All times are GMT -5. The time now is 03:08 PM.