CALC missing re-calculation

edit

Hi, I am using Libreoffice 7.0.2.2 on Linux Mint 10. C:\fakepath\CALC Bad calculation.xlsx I am attaching a file with an example of the annoying problem I am dealing with. If I use the SUM() function on a range containing a calculation, the sum result is not updated when the operators of the calculation are changed. Is there any missing config? Thank you in advance for your help. Marco