Bug 123392 - FILEOPEN DOCX SUM table formula with two arguments (ex.: BELOW and ABOVE) is not working in LO
Summary: FILEOPEN DOCX SUM table formula with two arguments (ex.: BELOW and ABOVE) is ...
Status: RESOLVED DUPLICATE of bug 123355
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
6.3.0.0.alpha0+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: DOCX-Fields Regressions-expression-is-faulty
  Show dependency tree / graph
 
Reported: 2019-02-12 08:08 UTC by NISZ LibreOffice Team
Modified: 2019-02-12 10:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Screenshot of the original document side by side in Word and Writer. (280.58 KB, image/png)
2019-02-12 08:09 UTC, NISZ LibreOffice Team 		Details
Document with SUM table formulas. (20.37 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2019-02-12 08:09 UTC, NISZ LibreOffice Team 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description NISZ LibreOffice Team 2019-02-12 08:08:40 UTC 
Description:
SUM table formula with two arguments has Expression is faulty when opened in LO.

Steps to Reproduce:
    1. Create a new docx in Word.
    2. Insert a Table.
    3. Insert SUM() formula with two arguments to some of the cells.
    4. Save and open it in LO.

Actual Results:
The cells which had and SUM formula now have ** Expression is faulty ** instead of what was in them in Word.

Expected Results:
All the cells should have the same data in them.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details: Version: 6.3.0.0.alpha0+
Build ID: cec7ae9f3c69ecc83462f28fc4987e37dc1b420e
CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: threaded
Comment 1 NISZ LibreOffice Team 2019-02-12 08:09:03 UTC 
Created attachment 149200 [details]
Screenshot of the original document side by side in Word and Writer.
Comment 2 NISZ LibreOffice Team 2019-02-12 08:09:22 UTC 
Created attachment 149201 [details]
Document with SUM table formulas.
Comment 3 Xisco Faulí 2019-02-12 10:11:07 UTC 
Formulas:

debug:6656:6656: =SUM(LEFT;ABOVE)
debug:6656:6656: =SUM(RIGHT;ABOVE)
debug:6656:6656: =SUM(LEFT;BELOW)
debug:6656:6656: =SUM(RIGHT;BELOW)

Duplicate of bug 123355

*** This bug has been marked as a duplicate of bug 123355 ***
Comment 4 Timur 2019-02-12 10:29:07 UTC 
No. 
bug 123355 was about AVERAGE and this is SUM, so a dupe of 122719.

*** This bug has been marked as a duplicate of bug 122719 ***
Comment 5 Xisco Faulí 2019-02-12 10:34:31 UTC 

*** This bug has been marked as a duplicate of bug 123355 ***