How to get this: on the pic

[altair]

Hello!
Please, I have tools-detective- auto refresh on,

but this does not happen!
It does not calculate the sum!
I come to the step when first numer is in blue colour, another in red,
But I can not get the forumula doing the same FUNCTION for other two numbers!
I copied and pasted the formula in the cell with copy/paste, then with ctrl+c/ctrl+v, and tried to paste it to another cell, but nothing happened. Where is the mistake, please?
Many thans!

[carnendil]

Generally, it should work if you “drag” the little square on the bottom-right of the cell when it is selected. It is not very clear from your question how exactly is that it doesn’t work (that is, do you get an error or you see the formula instead?). In the latter case, check the cell formatting.

[L-user]

You are using OpenOffice.org program, but this is LibreOffice forum. Yes, LibreOffice originated from OpenOffice.org, but this two programs are not exactly the same, but still very similar. I suggest one of the two things:

1. Find appropriate help at OpenOffice forum.
   
2. Uninstall OpenOffice and install LibreOffice from https://www.libreoffice.org/download
   I am not going to say this will solve your problem, but if we are not using exactly the same software…

[L-user]

What is your cell you are coping formula into? Is it D5? In status bar there is “Vsota=15” this is “Sum=15”, so formula is working fine. What do you mean “nothing happens”? What do you see in cell:

1. Error message? If yes, post the error message.
   
2. You see formula instead of sum result? If yes, right click on cell and select Clear Direct Formatting.
   
3. Do you see “0”? If yes, then you probably have absolute vs. relative formula understanding problem.
   
4. Anything else? Explain.