https://bugs.documentfoundation.org/show_bug.cgi?id=161235
Bug ID: 161235
Summary: Function AVERAGE in Calc is not compatible with Excel
when logical values are used
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 194307
--> https://bugs.documentfoundation.org/attachment.cgi?id=194307&action=edit
XLSX sample file
The function AVERAGE should not consider logical values as numeric. See:
https://support.microsoft.com/en-us/office/average-function-047bac88-d466-426c-a32b-8f33eb960cf6
However, logical values are taken into consideration in Calc, causing
compatibility issues in sheets with such values.
Steps to reproduce:
1) Open the attached XLSX file in Calc (the file was originally created in
Excel, so as soon as it opens, all the results from the formulas will be
correct).
2) Notice that all results in Column G are 14.25 (which is correct)
3) Now recalculate the sheet (Data - Calculate - Recalculate Hard / or
Ctrl+Shift+F9)
4) Notice that the results in Column G now changed to 11.6 in rows 2 and 3
So it appears that logical values are counted... text is correctly not
considered.
System info
Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 420(Build:2)
CPU threads: 16; OS: Linux 6.8; UI render: default; VCL: kf5 (cairo+xcb)
Locale: pt-BR (pt_BR.UTF-8); UI: en-US
Ubuntu package version: 4:24.2.3~rc2-0ubuntu0.24.04.1~lo1
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
