https://bugs.documentfoundation.org/show_bug.cgi?id=161592
--- Comment #12 from ady <[email protected]> --- (In reply to Regina Henschel from comment #11) > Created attachment 194767 [details] > Same calculation but different amount of formulas > The two sheets only differ, that in one sheet the > range goes to row 813 (fail) whereas in the other sheet it goes to row 812 > (good). To test the sheets change the value in cell B2. The size of the range for the search array in MATCH() impacts the behavior (too). STR: 1. Open attachment 194767, worksheet "fail813". 2. Cells B3 and B4: 2.1. change them from =MATCH(0,B11:B813,-1) to: =MATCH(0,$B$11:$B$812,-1) We now have the same amount of formulas, but the range used within MATCH() is 1 cell smaller. 3. Change cell B2 to 15000, then to 7000; both cells B3 and B4 recalc correctly. So: * It is not just the amount of formulas. * The relative location of the formulas impacts the behavior. * The size of the range(s) used within MATCH() impacts the behavior. 6.0.3.2 > all OK <https://git.libreoffice.org/core/+log/8f48d515416608e3a835360314dac7e47fd0b821> 6.0.4.2 > fails <https://git.libreoffice.org/core/+log/9b0d9b32d5dcda91d2f1a96dc04c645c450872bf> -- You are receiving this mail because: You are the assignee for the bug.
