https://bugs.documentfoundation.org/show_bug.cgi?id=140672
--- Comment #1 from himajin100...@gmail.com ---
FWIW:
In current implementation, the only functions that ignore the empty cells are
"AVERAGE","COUNT", and "PRODUCT".
(i.e. When I create a 1-row and 3-column table, and input 1 to A1,
=AVERAGE(<A1:B1>) to C1 and keep the B1 cell empty, the avearge value will be
1, not (1 + 0) /2 = 0.5)
https://opengrok.libreoffice.org/xref/core/sw/source/core/fields/cellfml.cxx?r=94306083&fi=MakeFormula_#360
https://opengrok.libreoffice.org/xref/core/sw/source/core/fields/cellfml.cxx?r=94306083&fi=MakeFormula_#376
--
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
