Bug 122648 - [RFE] Missing advanced sum formulas in Writer: SUM(ABOVE), SUM(LEFT), SUM(BELOW), SUM(RIGHT)
Summary: [RFE] Missing advanced sum formulas in Writer: SUM(ABOVE), SUM(LEFT), SUM(BEL...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Writer-Tables-Enhancements Writer-Tables-Formulas
  Show dependency treegraph
 
Reported: 2019-01-11 09:35 UTC by Marina Latini (SUSE)
Modified: 2019-02-12 10:30 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
Sample DOCX (19.01 KB, application/vnd.openxmlformats-officedocument.wordprocessingml)
2019-01-11 16:17 UTC, Timur
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Marina Latini (SUSE) 2019-01-11 09:35:47 UTC
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:
Comment 1 Timur 2019-01-11 16:17:29 UTC
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).
Comment 2 Roman Kuznetsov 2019-01-15 08:27:35 UTC
(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