https://bugs.documentfoundation.org/show_bug.cgi?id=122648
Bug ID: 122648
Summary: [RFE] Missing advanced sum formulas in Writer
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Writer
Assignee: [email protected]
Reporter: [email protected]
Description:
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)
Actual Results:
the function doesn't work
Expected Results:
The formula provides the sum of the values entered in A1 and A2.
Reproducible: Always
User Profile Reset: No
Additional Info:
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
