Description: I would like to request the implementation of the AVERAGE.WEIGHTED function in LibreOffice Calc, similar to the functionality available in Google Sheets, where it finds the weighted average of a set of values, given the values and the corresponding weights. The AVERAGE.WEIGHTED function would provide a convenient way to calculate weighted averages without the need for complex formulas. Steps to Reproduce: 1. Actual Results: Expected Results: Reproducible: Always User Profile Reset: No Additional Info: Google Sheets AVERAGE.WEIGHTED function docs: https://support.google.com/docs/answer/9084098?hl=en&sjid=8153603731442131355-SA#null
Thanks for the suggestion. Workarounds are not cumbersome, but I can see how opening a spreadsheet with the function replaced by the following is not ideal: =IFERROR(__xludf.dummyfunction("AVERAGE.WEIGHTED(<values>,<weights>)"),<static_result>) That's what Google Sheets saves it as when exporting to XLSX or ODS. MS Excel does not seem to support it either, so if we do add it, it does mean that we will be producing files that are less compatible with MS Excel. Eike, how do we usually proceed when a spreadsheet function is only available in one of the other main office suites? If it's not in ODF -> won't fix?
Created attachment 193227 [details] exported ODS from Google Sheets
ODF not defining a function doesn't matter, then functions are stored with an extension namespace and we have a bunch of them, see https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_OpenFormula_Extensions Which of course doesn't help if Google Sheets stores it with their dumb __xludf.dummyfunction() and string argument instead of an ODF standard conformant extension, something like =IFERROR(COM.GOOGLE.AVERAGE.WEIGHTED(<values>,<weights>),<static_result>)