https://bugs.documentfoundation.org/show_bug.cgi?id=112326
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #4 from Eike Rathke <[email protected]> ---
Boolean values are just numbers formatted differently, with FALSE = 0 and TRUE
= any other value (usually 1 if returned by a function returning boolean).
Functions like SUM, AVERAGE, ... or other taking a cell range as argument do
*not* ignore such "boolean" values.
Solution: do not include the header values in row 2 in your calculations, but
use the actual data range, eg. =SUM(B3:B9) or =AVERAGE(B3:B9), or
=SUM(B3:B1048576) if you want to cover all the rest of the column as well.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
