https://bugs.documentfoundation.org/show_bug.cgi?id=162661
Bug ID: 162661
Summary: Libreoffice Excel table not show value use formula
which works in Microsoft excel
Product: LibreOffice
Version: 24.8.0.1 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
hi,
I have an excel with formula which works fine in Microsoft Excel, but can't
show values in libreOffice, the formula like this
c
I figure out the cause is because of {"OA","PA"}, if I change the formula to
the next , it will work fine in libreOffice,
=+SUM(SUMIFS('Data'!$T:$T,'Data'!$B:$B,'Summary-Data'!$E8,'Data'!$F:$F,'Summary-Data'!F$7,'Data'!$Q:$Q,
"OA"),SUMIFS('Data'!$T:$T,'Data'!$B:$B,'Summary-Data'!$E8,'Data'!$F:$F,'Summary-Data'!F$7,'Data'!$Q:$Q,"PA"))
The question is do we have plan to support this kind {"OA","PA"} criteria ?
Actual Results:
The Excel table in LibreOffice is blank
Expected Results:
show the correct value the same whit open it in Microsoft Excel
Reproducible: Always
User Profile Reset: No
Additional Info:
support formula like
=+SUM(SUMIFS('Data'!$T:$T,'Data'!$B:$B,'Summary-Data'!$E8,'Data'!$F:$F,'Summary-Data'!G$7,'Data'!$Q:$Q,{"OA","PA"}))
--
You are receiving this mail because:
You are the assignee for the bug.
