Description: AVERAGE 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 AVERAGE() formula to some of the cells. 4. Save and open it in LO. Actual Results: The cells which had and AVERAGE 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 149151 [details] Screenshot of the original document side by side in Word and Writer.
Created attachment 149152 [details] Document with AVERAGE table formulas.
The problem is it's using debug:29011:29011: AVERAGE(BELOW) debug:29011:29011: AVERAGE(LEFT) debug:29011:29011: AVERAGE(RIGHT) debug:29011:29011: AVERAGE(ABOVE) Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=c568eb7d3bb4584867f0a1f0a7965f73097f009b author Jean-Sebastien Bevilacqua <realitix@gmail.com> 2017-02-16 09:54:33 (GMT) committer Miklos Vajna <vmiklos@collabora.co.uk> 2017-03-30 17:39:00 (GMT) commit c568eb7d3bb4584867f0a1f0a7965f73097f009b (patch) tree ea7e6fb1e0d77369a90bc69dd8756f589bb352e4 parent 53c2507bf97867011fd2bfbbac6c86b7fc494338 (diff) tdf#105975 Add Formula field parsing (docx) in SWriter Introduction Bisected with bibisect-linux-64-5.4
*** Bug 123356 has been marked as a duplicate of this bug. ***
*** Bug 123392 has been marked as a duplicate of this bug. ***
*** Bug 123391 has been marked as a duplicate of this bug. ***
*** Bug 123383 has been marked as a duplicate of this bug. ***
*** Bug 123382 has been marked as a duplicate of this bug. ***
This one started as AVERAGE and we have a separate bug for SUM.
(In reply to Timur from comment #9) > This one started as AVERAGE and we have a separate bug for SUM. it doesn't matther, the problem is Below/above/left/right
*** Bug 122719 has been marked as a duplicate of this bug. ***
I'm not sure these are regressions. There was no update before.
(In reply to Timur from comment #13) > I'm not sure these are regressions. There was no update before. Yep, I'm thinking the same way now after investigating these issues a bit... I'll report the average problem in a follow-up issue
(In reply to Xisco Faulí from comment #14) > Yep, I'm thinking the same way now after investigating these issues a bit... > I'll report the average problem in a follow-up issue bug 123401
Changing priority to 'high' since the number of duplicates is higher than 5 or the number of people in CC higher than 20
László Németh committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/436cf6d31deb7f9594a5da52ec7883d7e3d34344 tdf#123355 DOCX import: fix cell range ABOVE, BELOW, 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.
Created attachment 165511 [details] Document compared Thanks. Verified this one and checked and reopened some duplicates.
This one was about Average but seems like some Sum was also resolved. attachment 149199 [details] from bug 123391 and attachment 149201 [details] from bug 123392 with SUM are OK. But attachment 149184 [details] is not resolved, so I reopened. Also not resolved is Max, also reopened.
*** Bug 122648 has been marked as a duplicate of this bug. ***
Only way to recognize great work of László is to mark this Major, which it was.
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 Thanks, Laci :)
(In reply to Timur from comment #21) Thanks, Timur. I continued the import fix of Michael Warner with the export, these LEFT, BELOW etc., but we didn't notice, that these worked only for the first DOCX table. :) So many thanks to you, Xisco and others for your feedback, testing and verification!
I updated https://wiki.documentfoundation.org/ReleaseNotes/7.1 with this.