Apache OpenOffice (AOO) Bugzilla – Issue 101466
ODFF: implement AVERAGEIF and AVERAGEIFS
Last modified: 2017-05-20 11:41:44 UTC
I'd like to see Calc support the Excel AverageIf and AverageIfs functions, so .xlsx spreadsheets with these functions can be properly opened. Trying to do so now results in: #NAME See the attached sample .xlsx file.
Created attachment 61940 [details] .xlsx file demonstrating the missing functions
*** Issue 101466 has been confirmed by votes. ***
See also COUNTIFS issue 90269 SUMIFS issue 95144
makkica will be working on this.
AVERAGEIF is implemented.
AVERAGEIF() implemented. Note: import/export from/to Excel is not implemented yet. In cws calcishmakkica: changeset 237cb91dd986 http://hg.services.openoffice.org/cws/calcishmakkica/changeset/237cb91dd986 M formula/inc/formula/compiler.hrc M formula/inc/formula/opcode.hxx M formula/source/core/resource/core_resource.src M sc/inc/scfuncs.hrc M sc/source/core/inc/interpre.hxx M sc/source/core/tool/interpr1.cxx M sc/source/core/tool/interpr4.cxx M sc/source/core/tool/parclass.cxx M sc/source/core/tool/scmatrix.cxx M sc/source/ui/src/scfuncs.src M sc/util/hidother.src You can observe the progress and possible integration date of CWS calcishmakkica at http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalcishmakkica
AVERAGEIFS implemented. Note: import/export from/to Excel is not implemented yet. In cws calcishmakkica: changeset 02cf226fcde4 http://hg.services.openoffice.org/cws/calcishmakkica/changeset/02cf226fcde4 M formula/inc/formula/compiler.hrc M formula/inc/formula/opcode.hxx M formula/source/core/resource/core_resource.src M formula/source/ui/dlg/parawin.cxx M sc/inc/sc.hrc M sc/inc/scfuncs.hrc M sc/source/core/data/global.cxx M sc/source/core/inc/interpre.hxx M sc/source/core/tool/interpr1.cxx M sc/source/core/tool/interpr4.cxx M sc/source/core/tool/parclass.cxx M sc/source/ui/formdlg/dwfunctr.cxx M sc/source/ui/src/scfuncs.src M sc/source/ui/unoobj/appluno.cxx M sc/util/hidother.src changeset 79da8a1033b6 http://hg.services.openoffice.org/cws/calcishmakkica/changeset/79da8a1033b6 M sc/source/core/inc/parclass.hxx M sc/source/core/tool/interpr1.cxx M sc/source/core/tool/parclass.cxx M sc/source/ui/src/scfuncs.src You can observe the progress and possible integration date of CWS calcishmakkica at http://tools.services.openoffice.org/EIS2/cws.ShowCWS?Path=DEV300%2Fcalcishmakkica
Created issue 117000 as a follow-up to implement Excel import/export.
Reassigning to QA for verification. The latest ODF 1.2 OpenFormula draft is available at http://www.oasis-open.org/committees/download.php/40744/OpenDocument-v1.2-csd06-rev02-part2.odt
seen ok in cws -> verified
Clean up the Target Milestone from AOO 3.5.0, since it is a feature implemented before.
(In reply to comment #11) > Clean up the Target Milestone from AOO 3.5.0, since it is a feature > implemented before. AFAIK, code was committed recently, with revision 1381446 to revision 1381452 This means, the target milestone with be 3.5.0
Resolved in LibreOffice 4.0: https://bugs.freedesktop.org/show_bug.cgi?id=41214
(In reply to comment #13) This bug was fixed in OpenOffice with the inclusion off CWS calcishmakkica in revision 1381445 revision 1381446 revision 1381447 revision 1381448 revision 1381449 revision 1381450 revision 1381452 After that, LO took the code released under the Apache License. > Resolved in LibreOffice 4.0: > https://bugs.freedesktop.org/show_bug.cgi?id=41214 I find it inadmissible that you promote a fork using OpenOffice resources, like this bugzilla