Summary: | Implement AVERAGE.WEIGHTED Function in LibreOffice Calc | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | ririmello.a |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | enhancement | CC: | erack, stephane.guillou |
Priority: | medium | ||
Version: | 7.6.4.1 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 108827 | ||
Attachments: | exported ODS from Google Sheets |
Description
ririmello.a
2024-02-18 18:02:52 UTC
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>) |