[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 Eike Rathke changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |er...@redhat.com

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 Eike Rathke changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 zh_CN User Community Liaison changed: What|Removed |Added Ever confirmed|1 |0

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 --- Comment #7 from zh_CN User Community Liaison --- Created attachment 161512 --> https://bugs.documentfoundation.org/attachment.cgi?id=161512=edit Same sample file as 161113, saved by MS Excel Sample file saved by Excel attached.

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 --- Comment #6 from Eike Rathke --- Yes. It looks like an inline array (unlike a cell range reference) as argument where a scalar value is expected would force array mode of the entire formula expression. Question remains what happens if

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 --- Comment #5 from zh_CN User Community Liaison --- (In reply to Eike Rathke from comment #4) > Can we please have an original Excel sample file attached, not a WPS > generated one, to see what Excel actually stores for this case?

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 Eike Rathke changed: What|Removed |Added CC||er...@redhat.com

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 --- Comment #3 from zh_CN User Community Liaison --- (In reply to zh_CN User Community Liaison from comment #2) > I can indeed get the desired 15501 result using Shift+Ctrl+Enter on 6.4.4, > it didn't work on 6.2.8 though. Actually, it's

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 --- Comment #2 from zh_CN User Community Liaison --- Hi Miguel, Thanks for helping. (In reply to m.a.riosv from comment #1) > For me: > =SUMIFS(D8:D14;C8:C14;{"li"|"liu"}) => 9812 > > {=SUMIFS(D8:D14;C8:C14;{"li"|"liu"})} => 9812

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 m.a.riosv changed: What|Removed |Added CC||miguelangelrv@libreoffice.o

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 zh_CN User Community Liaison changed: What|Removed |Added URL|

[Libreoffice-bugs] [Bug 133260] FILEOPEN XLSX: Calc doesn't handle SUMIFS() with array as the third parameter correctly

https://bugs.documentfoundation.org/show_bug.cgi?id=133260 zh_CN User Community Liaison changed: What|Removed |Added Attachment #161113|Sample file using |Sample file using