[FW][FIX] pivot: support empty values

fw-bot commented 2 months ago

Steps to reproduce:

Create a spreadsheet pivot, with some empty values in the data so that we have an (Undefined) header cell
Copy/paste a cell child of the (undefined) header
Freeze the pivot

=> The cells corresponding to empty values are empty.

Implementation note: The pivot helper toNormalizedPivotValue takes groupValue as argument, but the type of groupValue is variable. It's either a CellValue or a FunctionResultObject. This is not ideal and should be fixed in the future.

Task: 4053215

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