[Libreoffice-bugs] [Bug 115841] sumif across multiple sheets using named range not working
https://bugs.documentfoundation.org/show_bug.cgi?id=115841 m.a.riosvchanged: What|Removed |Added CC||miguelangelrv@libreoffice.o ||rg --- Comment #3 from m.a.riosv --- Created attachment 140020 --> https://bugs.documentfoundation.org/attachment.cgi?id=140020=edit Test file Not clear it is not a bug, seems bidimensional arrays doesn't work, at least when more than one multirange in the formula, although INDIRECT seems to get the right data. Only with COUNTIF seems to work and when the second dimension it's force. Please Eike some advice woul be appreciated. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115841] sumif across multiple sheets using named range not working
https://bugs.documentfoundation.org/show_bug.cgi?id=115841 Xavier Van Wijmeerschchanged: What|Removed |Added Status|UNCONFIRMED |RESOLVED Resolution|--- |NOTABUG --- Comment #2 from Xavier Van Wijmeersch --- When looking to your formula and name range, i see in X3 and Y3 only something like A3:A60 C3:C60. These are not formula or name range. I have a 504error. "no reference or text..." see the help file "F1" So for me its not a bug, if you not agree you can still reopen the report -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 115841] sumif across multiple sheets using named range not working
https://bugs.documentfoundation.org/show_bug.cgi?id=115841 Dhruv Mohindruchanged: What|Removed |Added CC||dmohin...@yahoo.com --- Comment #1 from Dhruv Mohindru --- Created attachment 139984 --> https://bugs.documentfoundation.org/attachment.cgi?id=139984=edit Excel file which work in MS Excel 2013, but not in LibreOffice Calc -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs