https://bugs.documentfoundation.org/show_bug.cgi?id=169545
Bug ID: 169545
Summary: Data Provider Transformations Aggregate Functions:
Average counts header
Product: LibreOffice
Version: 26.2.0.0 alpha0+ master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 204106
--> https://bugs.documentfoundation.org/attachment.cgi?id=204106&action=edit
list of numbers with header line
PRECONDITION:
new Calc spreadsheet, Data > Define Range
(e.g. see Bug #169514 attachment DataRangeForDataProvider.ods)
https://bugs.documentfoundation.org/attachment.cgi?id=204066
PROBLEM DESCRIPTION:
Data > Data Provider
select Range, CSV, URL attached average-with-title.csv
Transformations Aggregate Functions [ADD], Average, Col: 2;3;4;5
Preview [Apply]
this is average-with-title.csv:
user,Mike,Tom,Jeff,Lisa
beer, 0, 2, 1, 1
tea, 4, 3, 1, 2
coffee, 2, 2, 1, 1
juice, 4, 1, 3, 0
the sum is divided by 5, results to average:
2, 1.6, 1.2, 0.8
should be divided by 4:
2.5, 2, 1.5, 1
EXPECTED BEHAVIOR:
rows with text shall not only be counted as 0 but even not counted for the
division
Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 480ef73deef62c458e5735cd496a1d74ef408ed8
CPU threads: 2; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
