PRODUCT 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 PRODUCT() formula to some of the cells.
4. Save and open it in LO.
The cells which had and PRODUCT 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: 22.214.171.124.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
Created attachment 149192 [details]
Screenshot of the original document side by side in Word and Writer.
Created attachment 149193 [details]
Document with PRODUCT table formulas.
The attached document contains below/above/right/left which can't be handle by Writer atm. Attaching a new Formula with PRODUCT without those...
Created attachment 149218 [details]
Simplier Product formula
László Németh committed a patch related to this issue.
It has been pushed to "master":
tdf#123388 sw: add PRODUCT table 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:
Affected users are encouraged to test the fix and report feedback.
Build ID: 6640d7f405d2970ba2825a9455926cc803284d01
CPU threads: 4; OS: Mac OS X 10.15.5; UI render: default; VCL: osx
Locale: ru-RU (ru_RU.UTF-8); UI: en-US
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
@László Németh, thanks for fixing this issue!!