Created attachment 204106 [details] 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
Confirm with Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 177b3d2a88afb2dfd3e89025624d8bf62b36cda4 CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded There is an attribute "contains column labels" in the Define DB range dialog. Maybe it could be considered.