[FW][FIX] pivot: sorting of undefined headers

fw-bot commented 1 month ago

Steps to reproduce:

Create a pivot table with headers value "Alice", "Olaf", "".

=> The headers are sorted in the following order: "Alice", "(Undefined)", "Olaf".

The root cause was that the sorting function sorts the keys of the groupby, and the key of the undefined object is the string "null" and so it was sorted between the A of Alice and the O of Olaf.

Task: 4123261

Description:

description of this task, what is implemented and why it is implemented that way.

Task: : TASK_ID

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