[Libreoffice-bugs] [Bug 98297] Array Formula Incorrectly Evaluated

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |

-- 
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 98297] Array Formula Incorrectly Evaluated

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED

-- 
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 98297] Array Formula Incorrectly Evaluated

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #4 from Eike Rathke  ---
Actually Calc also ignores errors in COUNT, just not in array mode ... to be
fixed.

@Gerard:
What makes you think that LOOKUP ignores errors?

-- 
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 98297] Array Formula Incorrectly Evaluated

[bugzilla-daemon]

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

GerardF  changed:

   What|Removed |Added

 CC||gerard.farg...@orange.fr

--- Comment #3 from GerardF  ---
Excel function COUNT ignore errors values while Calc COUNT propagates errors.

See Excel COUNT :
https://support.office.com/en-us/article/COUNT-function-a59cd7fc-b623-4d93-87a4-d23bf411294c

Not related to this bug, but function LOOKUP also ignore errors in Excel.

-- 
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 98297] Array Formula Incorrectly Evaluated

[bugzilla-daemon]

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

Luke  changed:

   What|Removed |Added

 CC||er...@redhat.com

--- Comment #2 from Luke  ---
Eike,
Our functions should follow the same specification as Excel, right?

-- 
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 98297] Array Formula Incorrectly Evaluated

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #1 from m.a.riosv  ---
I have not excel, maybe SEARCH() has a different return when text it's not
founded, in calc returns #VALUE!.

{=COUNT(IF(ISERROR(SEARCH("brown";A1:A4));"";1))}

or

{=COUNT(IFERROR(SEARCH("brown";A1:A4);""))}

or

=SUMPRODUCT(NOT(ISERROR(SEARCH("brown";A1:A4

or

=SUMPRODUCT(IFERROR(SEARCH("brown";A1:A4)>0;0))

or 

{=COUNT(IFERROR(SEARCH("brown";A1:A4)>0;""))}

works for me, the interest of SUMPRODUCT() it's that is an implicit array,
avoiding the need to enter the formula as array

-- 
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