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.
The cells which had and AVERAGE formula now have ** Expression is faulty ** instead of what was in them in Word.
All the cells should have the same data in them.
User Profile Reset: No
LibreOffice details: Version: 18.104.22.168.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
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
Regression introduced by:
author Jean-Sebastien Bevilacqua <firstname.lastname@example.org> 2017-02-16 09:54:33 (GMT)
committer Miklos Vajna <email@example.com> 2017-03-30 17:39:00 (GMT)
commit c568eb7d3bb4584867f0a1f0a7965f73097f009b (patch)
parent 53c2507bf97867011fd2bfbbac6c86b7fc494338 (diff)
tdf#105975 Add Formula field parsing (docx) in SWriter
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
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":
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:
Affected users are encouraged to test the fix and report feedback.
Created attachment 165511 [details]
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.
Version: 22.214.171.124.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
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.