I have some values in my calc sheet:
A1: 10; B1: =A1*10 (formula wich evaluates to 100)
A2: 20
When I copy a formula from B1 and paste it to B2, I get 100, not 200.
What’s going on?
Everything worked fine unti a couple days ago.
I’m using LibreOffice 7.2.4.1 (x64) on Win 10.
BTW I’m not a newbie.
Thanx in advance.
Works as expected for me - LO 7.4.42 on Slackware 15. What is the formula that results from the copy in B2?
Copy the entire cell, not the cell text.
I cannot reproduce that. Provide the precise steps on how you copy and paste so we can reproduce exactly what you did. It is extremely unlikely that your observation is related to a software issue,
Did that. When I copy the entire cell, the result in the cell B2 is “=A2*10” but the cell shows value from B1 (100)
One more detail: The spreadsheet is saved on the cloud. I’m editing it from 2 computers and have same problem on both.
It’s probably some settings in the Libre Calc.
Hallo
enable ```→Data→Calculate→[x]Automatic``