[Libreoffice-bugs] [Bug 112326] Average/sum of column gets thrown off by boolean values

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #4 from Eike Rathke <erack at redhat.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170911/3320673a/attachment.html>