There is a table in OpenOffice Writer (not Calc).

In one of the cells there is a sum that was considered a formula.

  1. How to make the value itself updated when the data in the table changes?
  2. How to edit the entered formula?
  3. How to divide the result (amount) by 8?

PS: It is impossible to google, everything comes across about Calc.

  • 1. It was not necessary to include text cells in the formula. It worked. - Qwertiy ♦
  • No, it did not work ... Buggy ... - Qwertiy ♦

1 answer 1

Tested on OpenOffice Writer Version

AOO411m6(Build:9775) - Rev. 1617669 2014-0Gh8-13 09:06:54 (Mi, 13 Aug 2014)
  1. We have a table of columns Продукты , Цена :

Sample table

  1. The line of the sum is written in the following notation =<B2:B5> .

To insert a formula, use F2 , the formula starts with = . Method limitations - recalculation occurs automatically when the values ​​in the Цена column change. When adding rows, you need to change the lower value of the row index ( B5 in our example)

Insert total by column

  1. To divide the sum by 8 suffices to add /8 in F2 in the sum formula (the final version of the formula =<B2:B5>/8 ).

Dividing the amount by 8