[IMP] xlsx: support exporting array formulas

[Rachico]

This commit improves the export of vectorized & array formulas, including those that spill across cells, ensuring better compatibility with other spreadsheet applications. The adopted approach is to treat all formulas as array formulas & to add an additional xml file that contains metadata about array formula properties. As a result, we improve the integrity & usability of our generated XLSX files.

Task: 4134347

review checklist

• [ ] feature is organized in plugin, or UI components
• [ ] support of duplicate sheet (deep copy)
• [ ] in model/core: ranges are Range object, and can be adapted (adaptRanges)
• [ ] in model/UI: ranges are strings (to show the user)
• [ ] undo-able commands (uses this.history.update)
• [ ] multiuser-able commands (has inverse commands and transformations where needed)
• [ ] new/updated/removed commands are documented
• [ ] exportable in excel
• [ ] translations (_t("qmsdf %s", abc))
• [ ] unit tested
• [ ] clean commented code
• [ ] track breaking changes
• [ ] doc is rebuild (npm run doc)
• [ ] status is correct in Odoo

[robodoo]

[Rachico]

could you back-port to 18.0 (or even to 17.0) ? Thanks :)

Alrighty ;)

[rrahir]

done in https://github.com/odoo/o-spreadsheet/pull/5555 ...