https://bugs.documentfoundation.org/show_bug.cgi?id=100620
Aron Budea <ba...@caesar.elte.hu> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needAdvice
--- Comment #8 from Aron Budea <ba...@caesar.elte.hu> ---
Hi! I checked Excel's description for COUNTA as well, and based on that it
seems you're right, the circular reference can be eliminated based on this
criteria: "The COUNTA function counts cells containing any type of information,
including error values and empty text ("")".
So regardless of what the field with formula in the range evaluates to, it can
be counted in COUNTA (I don't know what actually happens in Excel, this is just
my deduction).
For reference and comparison:
https://support.office.com/en-us/article/COUNTA-function-7dc98875-d5c1-46f1-9a82-53f3219e2509
https://help.libreoffice.org/Calc/Statistical_Functions_Part_One#COUNTA
Adding needAdvice keyword to get input on this from developers.
Now that we discussed COUNTA, is anything wrong with COUNT?
--
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
