Table formula MAX() is not working when opened in LO.
Steps to Reproduce:
1. Create a new docx in Word.
2. Insert a table with some numbers.
3. Create a MAX formula in one of the cells.
4. Save it and open it in LO.
The cells that contain a formula has a 0 in them regardless what was in them before.
They should have the same number as in MSO.
User Profile Reset: No
LibreOffice details: Version: 220.127.116.11.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 149181 [details]
Screenshot of the original document side by side in Word and Writer.
Created attachment 149182 [details]
A document which contains some MAX formulas.
Closing as a dupe of bug 123355
*** This bug has been marked as a duplicate of bug 123355 ***
Not resolved in bug 123355, it was about Average.
(In reply to Timur from comment #4)
> Not resolved in bug 123355, it was about Average.
A1 has =MAX(BELOW) (=13)
A2 has =MAX(RIGHT) (=8)
C3 has =MAX(ABOVE) (=7)
D4 has =MAX(LEFT) (=15)
Of these the two in column A are not rewritten and give 0 as result in current Writer, but the ones in columns C and D are rewritten (to MAX(<C2:C1>) and MAX(<C4:A4>) ), and give the expected result.
Version: 18.104.22.168.alpha0+ (x64)
Build ID: ed4f610f4a3de12016f8308a17b6ad4f86e9d67a
CPU threads: 4; OS: Windows 6.3 Build 9600; UI render: default; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Created attachment 165536 [details]
fails with AVERAGE too
This is no a problem with the formula MAX, it also fails with AVERAGE. The problem is using BELOW on cell A1
Created attachment 165539 [details]
Modified version of the example file
I don't think the problem is with the MAX function itself. More like with the replacement of the LEFT/RIGHT/ABOVE/BELOW specifiers.
Created attachment 165541 [details]
Screenshot of the modified document side by side in Word and Writer
Here I tried to break things but the only common pattern found yet is that any formula in the first column does not have its LEFT/RIGHT etc replaced.
@all: thanks for the nice catch and investigation! Handling of the first column missed completely. Interestingly, there was another problem, too: the original formula of the first cell wasn't grab-bagged, causing the same problem, but only in the cell A1:
László Németh committed a patch related to this issue.
It has been pushed to "master":
tdf#123382 DOCX import: fix range IDs in column A
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 165843 [details]
Screenshot MSO LO with values
I still see and issue here: values are not the same, maybe a priority problem.
Please also explain why LEFT, RIGHT..are replaced instead of having similar functions.
(In reply to Timur from comment #11)
> Created attachment 165843 [details]
> Screenshot MSO LO with values
> I still see and issue here: values are not the same, maybe a priority
> Please also explain why LEFT, RIGHT..are replaced instead of having similar
Which document are you using ? Should we just create a new ticket for it ?