Bug 123391 - FILEOPEN DOCX Sum table formula does not work when opened in LO
Summary: FILEOPEN DOCX Sum table formula does not work when opened in LO
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 treegraph
 
Reported: 2019-02-12 08:06 UTC by NISZ LibreOffice Team
Modified: 2019-02-12 10:12 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. (274.93 KB, image/png)
2019-02-12 08:06 UTC, NISZ LibreOffice Team
Details
A document which contains some SUM formulas. (20.31 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2019-02-12 08:06 UTC, NISZ LibreOffice Team
Details

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:06:10 UTC
Description:
Table formula SUM() is not working when opened in LO.

Steps to Reproduce:
    1. Create a new docx in Word.
    2. Insert a table with some numbers.
    3. Create a SUM formula in one of the cells.
    4. Save it and open it in LO.

Actual Results:
The cells that contain a formula has a 0 in them regardless what was in them before.

Expected Results:
They should have the same number as in MSO.


Reproducible: Always


User Profile Reset: No



Additional Info:
LibreOffice details: Version: 6.3.0.0.alpha0+
Build ID: 17dd2662ccfa9d04efbea74e5d7548db5b2126d4
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:06:33 UTC
Created attachment 149198 [details]
Screenshot of the original document side by side in Word and Writer.
Comment 2 NISZ LibreOffice Team 2019-02-12 08:06:51 UTC
Created attachment 149199 [details]
A document which contains some SUM formulas.
Comment 3 Xisco Faulí 2019-02-12 10:12:39 UTC
Formulas

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

thus, duplicate of bug 123355

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