View original (French)

Addition problem with open office.org (calc)

zatox Posted messages 663 Status Member -  
Raymond PENTIER Posted messages 58216 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

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