Calc wont read cells into a spreadsheet

asked 2016-06-17 11:42:30 +0100

topramin gravatar image

im in an accounting class and for some reason when ever i enter any numbers into my T accounts it doesnt reflect on my balance sheet. All my formulas are correct but i have to manually retype in every formula for it to show a difference. For example say in T2=100 and T3= 50 dollers and T4 was the sum of T2,T3=150. If in my balance sheet R1=T4. Then T4 should read 150, but my problem is that i would have to retype in R1 for it to have any change on my spread sheet. Ive been using libre for the last month and never came across this problem if anyone can help me out let me know. i tried on a different spreadsheet and their was no problem even when i tried to copy the spreadsheet i am using now. I can change them manually it is just time consuming, and i know it should be doing that. If anyone could help me out that would be awesome.

edit retag flag offensive close merge delete


Have you enable for that spreadsheet Autocalculation?. Up to ver 5.0 Menu/Tools/Calculate, since 5.1 Menu/Data/Calculate.

m.a.riosv gravatar imagem.a.riosv ( 2016-06-17 23:39:27 +0100 )edit