https://bugs.documentfoundation.org/show_bug.cgi?id=161592
ady <adylo811...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |er...@redhat.com
Ever confirmed|0 |1
Summary|MATCH() is not updating |MATCH() fails to
|when the values in the |AutoCalculate
|lookup range change |
Status|UNCONFIRMED |NEW
--- Comment #3 from ady <adylo811...@gmail.com> ---
Apparently, either there is something wrong with the MATCH() function, or there
is something wrong with AutoCalculate.
STR:
1. Open attachment 194753.
2. Manually change cell C5 from 3000 to 5000
2.1. Note cell G3 does not change to 117
3. Manually change cell C5 from 5000 to 3000 (not using Undo).
3.1. Note cell G3 changes to 117, the value that corresponds to cell C5=5000,
not 3000.
Depending on the numeric value used in C5, I can see the result in G3 updating
correctly, or updating to a wrong result (previously correct), or not updating
its calculation.
I don't know whether some setting is influencing the behavior; for instance
menu Tools > Options > Calc > Formula > (Detailed Calculation Settings).
Whichever the case, the behavior is confusing.
CC'ing Eike.
--
You are receiving this mail because:
You are the assignee for the bug.
