View original (French)

Addition problem with open office.org (calc)

zatox Posted messages 663 Status Member -  
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   -
Hello, I can't seem to do sums with Calc. If I put numbers in several contiguous cells, then in another cell I sum the previous cells, it works, but if I change a number in the matrix, it doesn't take it into account!!! Strange, right? I've written in cell H3 =SUM(E3:G14). If I change the value of a cell in the matrix E3:G14 (for example, F6), it doesn't account for the new value. Does anyone have an idea? Maybe it's a syntax issue or an option that needs to be set, I don't see it!!!!
Thanks for your responses

Configuration: Linux Mandriva / Firefox 3.6.17

2 answers

Answer 1 / 2
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
In Excel, there is an option "Automatic Calculation"; there may be an equivalent in Calc ...
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
0
Answer 2 / 2
Raymond PENTIER Posted messages 58207 Registration date   Status Contributor Last intervention   17 476
 
So? Problem solved?
--
Retirement is great! Especially in the Caribbean ... :-)
☻ Raymond ♂
0