Description: ROUND 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 ROUND() formula to some of the cells. 4. Save and open it in LO. Actual Results: The cells which had and ROUND 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
Created attachment 149194 [details] Screenshot of the original document side by side in Word and Writer.
Created attachment 149195 [details] Document with ROUND table formulas.
Formula debug:6656:6656: =ROUND(6,678;2) debug:6656:6656: =ROUND(B1;6) Actually Writer has a round function as well... like =<A1>/2 round 0
Created attachment 163977 [details] Example created under a German local in Word 365 I work under a German local both for Word and LibreOffice. The attempt from https://gerrit.libreoffice.org/c/core/+/98614 does not work for me, because in a German local the decimal separator is a , (comma) and the parameter separator is a ; (semicolon) in Word.
Michael Warner committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/68e74bdf63e992666016c790e8e4cfd5b28d6abe tdf133647 tdf123386 tdf123389 Improved .docx table formula import It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/82189fdc93ac337e1de3379d678eca6b7654e6fc tdf133647 tdf123386 tdf123389 fix DOCX table formula export It will be available in 7.1.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Michael Warner committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/a8dbdf4c41d0299aee6e155323f217e2fa1565c9 tdf133647 tdf123386 tdf123389 Improved .docx table formula import It will be available in 7.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
László Németh committed a patch related to this issue. It has been pushed to "libreoffice-7-0": https://git.libreoffice.org/core/commit/8f1cb34bdb523e17478de2b0ef7d745c29743df7 tdf133647 tdf123386 tdf123389 fix DOCX table formula export It will be available in 7.0.2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Verified in: Version: 7.1.0.0.alpha0+ (x64) Build ID: a3b4831208da615789bd1e2d5660dd130807f504 CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded