Monday, May 5, 2025
1 change · saas-18.3
Resolved issues and error corrections
This update refreshes Odoo's spreadsheet engine with multiple fixes that make spreadsheet editing, charts, pivot tables, formatting, exports, and collaboration behave more reliably. Users should see fewer unnecessary refreshes, more accurate chart display and XLSX exports, and smoother interactions when working with spreadsheet views.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/7b9574bbc [REL] 18.3.1 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0)…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/7b9574bbc [REL] 18.3.1 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/67a61403a [FIX] selection_input: fix range deletion [Task: 4589387](https://www.odoo.com/odoo/2328/tasks/4589387) https://github.com/odoo/o-spreadsheet/commit/ad9f0e6ac [FIX] chart: avoid useless chart update [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/b9e895314 [FIX] Pivot: allowDispatch invalid pivot dataset [Task: 4756759](https://www.odoo.com/odoo/2328/tasks/4756759) https://github.com/odoo/o-spreadsheet/commit/e6c1b4fd6 [FIX] spreadsheet: parasitic render at every click [Task: 4737827](https://www.odoo.com/odoo/2328/tasks/4737827) https://github.com/odoo/o-spreadsheet/commit/ce701a6cb [FIX] ts: fix compiling of `.d.ts` files [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/cf62edf17 [FIX] pivot: copy from referenced id [Task: 4756878](https://www.odoo.com/odoo/2328/tasks/4756878) https://github.com/odoo/o-spreadsheet/commit/f0289af8e [FIX] bottom_bar_statistic: react to change in cell format [Task: 4747031](https://www.odoo.com/odoo/2328/tasks/4747031) https://github.com/odoo/o-spreadsheet/commit/13214cec2 [FIX] tables: react to change in cell format [Task: 4747031](https://www.odoo.com/odoo/2328/tasks/4747031) https://github.com/odoo/o-spreadsheet/commit/cf9e32be8 [FIX] chart: fix treemap colors with single range [Task: 4752235](https://www.odoo.com/odoo/2328/tasks/4752235) https://github.com/odoo/o-spreadsheet/commit/6ef549bbe [FIX] header_overlay: restore row/col move preview [Task: 4747268](https://www.odoo.com/odoo/2328/tasks/4747268) https://github.com/odoo/o-spreadsheet/commit/a368ac5ee [FIX] xlsx: correctly export aggregated charts [Task: 4714410](https://www.odoo.com/odoo/2328/tasks/4714410) https://github.com/odoo/o-spreadsheet/commit/794a32f6b [IMP] sheetview: lazily re-compute viewports on freeze rows [Task: 3600662](https://www.odoo.com/odoo/2328/tasks/3600662) https://github.com/odoo/o-spreadsheet/commit/bbca47ef6 [FIX] ChartRuntime: take devicePixelRatio in account [Task: 4661712](https://www.odoo.com/odoo/2328/tasks/4661712) https://github.com/odoo/o-spreadsheet/commit/ee405cf8a [FIX] chart: align moving average trendline with bar chart offset [Task: 4653065](https://www.odoo.com/odoo/2328/tasks/4653065) https://github.com/odoo/o-spreadsheet/commit/174fe3f2c [FIX] chart: ignore trendline datasets in show values plugin [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/18651c2be [REL] version 18.3.0 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/aaa23b463 [FIX] grid_overlay: stop interval on error [Task: 4746478](https://www.odoo.com/odoo/2328/tasks/4746478) https://github.com/odoo/o-spreadsheet/commit/7eeeea94c [FIX] Collaborative: Send client position on activeSheet change [Task: 4736980](https://www.odoo.com/odoo/2328/tasks/4736980) Co-authored-by: Anthony Hendrickx (anhe) <anhe@odoo.com> Co-authored-by: Alexis Lacroix (laa) <laa@odoo.com> Co-authored-by: Lucas Lefèvre (lul) <lul@odoo.com> Co-authored-by: Dhrutik Patel (dhrp) <dhrp@odoo.com> Co-authored-by: Adrien Minne (adrm) <adrm@odoo.com> Co-authored-by: Mehdi Rachico (mera) <mera@odoo.com> Co-authored-by: Florian Damhaut (flda) <flda@odoo.com> Co-authored-by: Rémi Rahir (rar) <rar@odoo.com> Co-authored-by: Pierre Rousseau (pro) <pro@odoo.com> Co-authored-by: Vincent Schippefilt (vsc) <vsc@odoo.com>