Bug 123384 - FILEOPEN DOCX MOD table formula is not working in LO
Summary: FILEOPEN DOCX MOD table formula is not working in LO
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
5.4 all versions
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 07:48 UTC by NISZ LibreOffice Team
Modified: 2020-07-10 12:44 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Screenshot of the original document side by side in Word and Writer. (282.25 KB, image/png)
2019-02-12 07:49 UTC, NISZ LibreOffice Team
Details
Document with MOD table formulas. (20.27 KB, application/vnd.openxmlformats-officedocument.wordprocessingml.document)
2019-02-12 07:49 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 07:48:45 UTC
Description:
MOD table formula has Expression is faulty when opened in LO.

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

Actual Results:
The cells which had and MOD 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: 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 07:49:11 UTC
Created attachment 149185 [details]
Screenshot of the original document side by side in Word and Writer.
Comment 2 NISZ LibreOffice Team 2019-02-12 07:49:30 UTC
Created attachment 149186 [details]
Document with MOD table formulas.
Comment 3 Xisco Faulí 2019-02-12 10:26:37 UTC
Formulas:

debug:7354:7354: =MOD(18;4)
debug:7354:7354: =MOD(B1;A1)
Comment 4 Michael Warner 2020-07-10 12:36:26 UTC
Writer doesn't currently support MOD. See calc.cxx:97.