Spreadsheet problem with filling down formulas

[nevertime]

Am Using 3.4.4 version
When I use “fill>down” or drag down to copy formulas in a table,
the formula changes correctly, but the number shown is incorrect.
the new cells show the same number that was in the first cell.

I can get the correct number if I retype the formula into each cell,
but that a pain since I have many cells with the same formula.

Thanks for any help you can give.

[mariosv]

The result change after recalculation, press F9,

some functions need a hard recalculation Ctrl+Shift+F9.

You can activate the automatic calculation in:
Menu/Tools/CellContents/Autocalculate.