funny, i think i reported a bug yesterday, can't find it today, second try, sorry if double ...
take file from next comment, click in B1, enlarge formula-bar (triangle on right end), step with the cursor keys! to B2, B3, B4, and watch the formula *not changing*. proceed to B5, formula disappears, and go up again, another - quite similar - formula appears, and again remains unchanged while you cursor-step to B3, B2. either may be right, the formula shown or the results, not both.
the correct - and different - formulae are correctly stored for the cells, you can check with F2, but are presented wrong to the user.
such behavior irritates unsuspecting users and is likely to raise doubts about the integrity of the program.
entering the cells by mouseclick worked correctly - on my tries - as well as different versions of calc produced slightly different misbehaviour, but all from 220.127.116.11 to 18.104.22.168alpha0+ failed, even in the safe settings without CL and 'unthreaded'.
have fun to dig down ...
observed side effect: inserting blank cells / rows between the red cells blocks the effect, hiding those rows let's it step in again ...
Steps to Reproduce:
see above description and file in next comment, i tested with a 64bit win machine, can't yet tell about lin or 32-bit versions.
wrong formula shown in the formula bar
the same formula in the bar as you see in the cell when editing (F2)
User Profile Reset: No
Version: 22.214.171.124 (x64)
Build ID: f82ddfca21ebc1e222a662a32b25c0c9d20169ee
CPU threads: 8; OS: Windows 6.1; UI render: GL; VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
version with which the file was created, other versions fail too
Created attachment 156258 [details]
see bug report, stepping through the three red marked cells with the cursor keys shows formulae in the formula bar which don't fully match the formula in the cells.
*** This bug has been marked as a duplicate of bug 129141 ***