In writer is not possible to use advanced sum formulas in tables.
MSO Word is providing the following sum formulas in tables:
a) =SUM(ABOVE) adds the numbers in the column above the cell you’re in.
b) =SUM(LEFT) adds the numbers in the row to the left of the cell you’re in.
c) =SUM(BELOW) adds the numbers in the column below the cell you’re in.
d) =SUM(RIGHT) adds the numbers in the row to the right of the cell you’re in.
For a reference see: https://support.office.com/en-us/article/sum-a-column-or-row-of-numbers-in-a-table-2e373a5f-2d8a-478a-9b85-275c8668bebb
Steps to Reproduce:
1. Insert a table in Writer with 1 column and 3 rows
2. add a value in A1
3. add a value in A2
3. type this formula in A3 -> =SUM(ABOVE)
the function doesn't work
The formula provides the sum of the values entered in A1 and A2.
User Profile Reset: No
Created attachment 148239 [details]
Thank you for reporting a bug. Could you please attach a sample document..:)
Or if I can do it, here it is.
This is not really an enhancement, because LO doesn't read DOCX, but let's keep it like that (to avoid those QA inquiries).
(In reply to Timur from comment #1)
> Created attachment 148239 [details]
> Sample DOCX
> Thank you for reporting a bug. Could you please attach a sample document..:)
> Or if I can do it, here it is.
> This is not really an enhancement, because LO doesn't read DOCX, but let's
> keep it like that (to avoid those QA inquiries).
Timur, I think need to create a different normal bug about opening of DOCX file with table and advanced SUM function when Writer shows us wrong result. I'll do it