https://bugs.documentfoundation.org/show_bug.cgi?id=161592
Regina Henschel <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from Regina Henschel <[email protected]> --- 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. 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. 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". For me it looks like a more general error in AutoCalculate. -- You are receiving this mail because: You are the assignee for the bug.
