[Libreoffice-bugs] [Bug 122648] New: [RFE] Missing advanced sum formulas in Writer

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: marina.latini at libreoffice.org

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190111/a6db9d7f/attachment.html>