Description: COUNT 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 COUNT() formula to some of the cells. 4. Save and open it in LO. Actual Results: The cells which had and COUNT 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
Created attachment 149153 [details] Screenshot of the original document side by side in Word and Writer.
Created attachment 149154 [details] Document with COUNT table formulas.
The problem is it's using debug:29011:29011: COUNT(LEFT) debug:29011:29011: COUNT(RIGHT) debug:29011:29011: COUNT(ABOVE) can be closed as a dupe of bug 123355 *** This bug has been marked as a duplicate of bug 123355 ***
The attached document contains below/above/right/left which can't be handle by Writer atm. Attaching a new Formula with COUNT without those...
Created attachment 149219 [details] Simplier Count formula
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/f1f27b2487ccfb7a03190ff68eadbfb611dd9749 tdf#123356 DOCX import: fix COUNT formula 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/894a0f77c12f3ac4029bdeb671943f32bcad875c Revert "tdf#123356 DOCX import: fix COUNT formula" 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/79681f6a35ebf70293136034d675d312c5b6cdee tdf#123356 sw: add table formula COUNT 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.
Verified in Version: 7.1.0.0.alpha0+ Build ID: e2f4e65a7b8024c00b049eebf0d87637efda7f24 CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded @László Németh, thanks for fixing this issue!!