Formulas copied are sometimes not recomputed - known issue?

This is difficult to reproduce, but I’ve experienced it many times with a Calc spreadsheet ( with several sheets; most sheets were initially created via a copy-paste (formulas included) from a “mother” sheet.
Now, when I change the sheet data, the formulas are (sometimes) not updated, even if I turn off “autorecalc” and I run a explicit “recalculate”.

Here’s a video I made:

Notice how the calculated cell should display 0 (it shows that result if I copy the formula verbatim into another cell), but it sticks to the original value, even after I change the cell format, or reference the cell in another cell; it recalculates the correct value only when I make some trivial change to the formula (eg, append “+ 0”)

This is extremely annoying, it basically means you cannot trust your data in the spreadsheet.
Is this a known issue? Is there some workaround?

This is very, very strange! Try to reset the user profile

Some functions needs a hard recalc Ctrl+Shift+F

Please take a look to this link:

while autocalculate is on results shouldn’t need manual recalc, if they do domething is odd, see comment there: comment to first answer about ‘hard-recalc-crutch’