https://bugs.documentfoundation.org/show_bug.cgi?id=105120
Bug ID: 105120
Summary: RANK.EQ function compatibility with excel2016 online
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Upon comparison in Calc of the xlsx before (RANK.EQ.xlsx) and after
RANK.EQ-O2016.xlsx) repair, I notice that:
cell A2 contains formula =RANK.EQ(5, {3,5,2,6,1}, 1) before and value 4
after the repair;
cell A15 contains formula =RANK.EQ(32,(Q1:Q5~P1:P5~R1:R5)) before and
value 3 after the repair.
This looks like an OOXML-export issue with arrays or expressions as
argument.
Steps to Reproduce:
1. open test file
2. save as xlsx
3.open in excel2016 online
Actual Results:
error
Expected Results:
file open
Reproducible: Always
User Profile Reset: No
Additional Info:
User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:50.0) Gecko/20100101 Firefox/50.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
