https://bugs.documentfoundation.org/show_bug.cgi?id=161592
--- Comment #6 from ady <[email protected]> --- (In reply to Regina Henschel from comment #4) > If I write the same formula to G4, the formula in G4 recalculates as > expected. > > If I move the formula from G4 to G2, then G2 does not recalculate, but G3 > does. It seems, the top-most formula in the column does not recalculate. That happens only on the same column G or before it. When using the same formula on column L (or any other after G), then recalculation is correct, as long as there is the same formula "before" the new one. On cell G3 (or the "first" located), [F9] does not work either; Hard Recalc does work on it. Observation: It would seem as if the recalculation works on columns (and then on rows) "after" the precedent, failing on the _first_ encounter, wherever that first might be located. > > If I use the forced recalculate mark "==" instead of the simple "=" for both > formulas, then that in G3 recalculates, but that in G4 does not recalculate. Even with double equal sign, the first encounter fails, wherever that first MATCH() formula is located. > > If I use =XLOOKUP(0;B10:B329;A10:A329;;1;-2) or =XMATCH(0;B10:B329;1;-2) it > results #N/A and gives the correct result only after "Recalculate Hard". Wherever the formula is located, a Hard Recalculate seems to work, also on MATCH(). Simple Recalculate fails on the "first" formula. > > For me it looks like a more general error in AutoCalculate. Not just AutoCalculate; there is some kind of "old cache" behavior, and a "first encountered location" too, at least using this MATCH() function. -- You are receiving this mail because: You are the assignee for the bug.
