https://bugs.documentfoundation.org/show_bug.cgi?id=161592
Bug ID: 161592
Summary: MATCH() is not updating when the values in the lookup
range change
Product: LibreOffice
Version: 7.6.7.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 194753
--> https://bugs.documentfoundation.org/attachment.cgi?id=194753&action=edit
Example spreadsheet
I am trying to make a simple mortgage payment spreadsheet. I want to use the
MATCH() function to show the number of payment periods... by finding the last
positive cell in the column containing the outstanding principle. When I
initially enter the match() formula, the value shows correct. If I make
changes to the payment amount, which changes the values in the column in which
match() is doing the lookup, it doesn't update the lookup index. If I change
the formula to another column which has a related value, it updates to the
expected value.
Reproducing using the supplied example. The MATCH() is in cell G3. When it
loads, it should show the expected value of 305.
Change the value in cell C5 from $3000 to $5000. The new value that should
appear in G3 should be 116 or 117 (I switch between doing the lookup on column
B or G to get it to update because those are related values.) So if I switch
the formula, I get the new value. If I switch it back, I get the old value.
It's like it's cached or something silly.
--
You are receiving this mail because:
You are the assignee for the bug.
