[Libreoffice-bugs] [Bug 115841] sumif across multiple sheets using named range not working

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=115841

m.a.riosv  changed:

   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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=115841

Xavier Van Wijmeersch  changed:

   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

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=115841

Dhruv Mohindru  changed:

   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