recalcuate sheet does not work on offset(match()) formula

[Dereck Wonnacott]

Binary package hint: openoffice.org

I use a lookup table in a calc document with the following formula:
=OFFSET($Price.$C$1,MATCH(H503,$Price.$A$2:$A$121,0),0)

I use it on a few thousand cells to lookup data on another sheet and populate it into the current sheet for analysis.

F9 has no affect on these cells, even though the lookup table has been updated. I have to re-copy the formula into all of the cells each time I want to update the data. :(

ProblemType: Bug
DistroRelease: Ubuntu 10.10
Package: openoffice.org (not installed)
ProcVersionSignature: Ubuntu 2.6.35-22.35-generic 2.6.35.4
Uname: Linux 2.6.35-22-generic i686
NonfreeKernelModules: nvidia
Architecture: i386
Date: Wed Oct 27 20:21:47 2010
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release i386 (20101007)
ProcEnviron:
 LANG=en_US.UTF-8
 SHELL=/bin/bash
SourcePackage: openoffice.org

[penalvch (penalvch)]

Dereck Wonnacott, thank you for reporting this bug and helping make Ubuntu better. Could you please attach an example document that demonstrates this problem?

[Launchpad Janitor (janitor)]

[Expired for openoffice.org (Ubuntu) because there has been no activity for 60 days.]

[penalvch (penalvch)]

Dereck Wonnacott, we are closing this bug report because it lacks the information we need to investigate the problem, as described in the previous comments. Please reopen it if you can give us the missing information, and don't hesitate to submit bug reports in the future. To reopen the bug report you can click on the current status, under the Status column, and change the Status back to "New". Feel free to test this problem with LibreOffice Calc and report back to this bug with your results. Thanks again!

sudo add-apt-repository ppa:libreoffice/ppa && sudo apt-get update && sudo apt-get -y upgrade && sudo apt-get -y install libreoffice-calc