East central Iowa | If I understood your problem correctly I made a simple column of numbers. 1,2,3 and summed them. Then I changed 1 to 2 and pressed enter, it automatically changed from total 6 to 7.
I did nothing else.
Below is settings for calculations in my Calc VERSION 7.3.0.3
 (calc1 (full).JPG)
 (calc2 (full).JPG)
 (calc3 (full).JPG)
Attachments
----------------
 calc1 (full).JPG (61KB - 6 downloads)
calc2 (full).JPG (32KB - 6 downloads)
calc3 (full).JPG (37KB - 7 downloads)
|
ReCalculate in Libre Calc Spreadsheets
