Daily updates from Odoo
Tuesday, May 24, 2022
2 changes · master
Resolved issues and error corrections
Fixes a crash that could happen when users tried to insert a pivot table from another spreadsheet sheet after reloading the page. This helps users continue working with spreadsheet reports reliably, even when some pivot data has not been loaded yet.
Original PR description
- Insert two pivots on a spreadsheet, one on the first sheet and one on the second - Then reload the page and try to insert the second pivot (which is not loaded) in the first sheet. => boom Task 2844664
Spreadsheet list formulas now recognize date and datetime fields as dates instead of plain text. This allows users to apply the expected date formatting and improves the accuracy and readability of spreadsheet reports.
Original PR description
.. and datetime. Currently, formulas `LIST` yield the server value of fields date and datetime, which are strings. As such, the o_spreadsheet lib will tag the cell with such content as a string; which prevents a proper formatting. To solve this, we now convert the server values to a number for values realted to date and datetime fields. Task 2857297