Sunday, March 9, 2025
1 change · saas-18.2
Resolved issues and error corrections
This update refreshes Odoo's spreadsheet engine with fixes for charts, formula editing, pivot panel notifications, and autofill behavior. It also improves Excel export compatibility by supporting array formulas and correcting table formula conversion, reducing user friction when working with complex spreadsheets.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/f5679324a [REL] 18.2.2 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0)…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/f5679324a [REL] 18.2.2 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/7c5471972 [FIX] spreadsheet: handle inverse increment when autofilling upwards/left [Task: 4199568](https://www.odoo.com/odoo/2328/tasks/4199568) https://github.com/odoo/o-spreadsheet/commit/bddc9902f [FIX] chart: improve chartjs extension robustness [Task: 4627232](https://www.odoo.com/odoo/2328/tasks/4627232) https://github.com/odoo/o-spreadsheet/commit/644837610 [IMP] xlsx: support exporting array formulas [Task: 4134347](https://www.odoo.com/odoo/2328/tasks/4134347) https://github.com/odoo/o-spreadsheet/commit/8bd57c6c2 [FIX] xlsx: fix conversion of table formulas [Task: 4095599](https://www.odoo.com/odoo/2328/tasks/4095599) https://github.com/odoo/o-spreadsheet/commit/ed6ad4f4a [FIX] composer: broken layout for long list suggestions [Task: 4456224](https://www.odoo.com/odoo/2328/tasks/4456224) https://github.com/odoo/o-spreadsheet/commit/a81277023 [FIX] composer: wrong size for autocomplete dropdown [Task: 4456224](https://www.odoo.com/odoo/2328/tasks/4456224) https://github.com/odoo/o-spreadsheet/commit/871711343 [FIX] popover: scroll lost on re-render [Task: 4456224](https://www.odoo.com/odoo/2328/tasks/4456224) https://github.com/odoo/o-spreadsheet/commit/e730a0b6e [MOV] test: move some composer tests in correct files [Task: 4456224](https://www.odoo.com/odoo/2328/tasks/4456224) https://github.com/odoo/o-spreadsheet/commit/3f90dd1dd [FIX] chart: only spread relevant options in datasets [Task: 4577783](https://www.odoo.com/odoo/2328/tasks/4577783) https://github.com/odoo/o-spreadsheet/commit/0bea73828 [FIX] selection input: highlight color not sync with range color [Task: 4577803](https://www.odoo.com/odoo/2328/tasks/4577803) https://github.com/odoo/o-spreadsheet/commit/0ffa187f4 [FIX] pivot: prevent incorrect notification for pivot side panel [Task: 4475744](https://www.odoo.com/odoo/2328/tasks/4475744) https://github.com/odoo/o-spreadsheet/commit/804c36816 [FIX] Chart: fix data series reordering [Task: 4600194](https://www.odoo.com/odoo/2328/tasks/4600194) https://github.com/odoo/o-spreadsheet/commit/d80adc878 [FIX] chart: pyramid chart datasets are wrong in the panel [Task: 4517138](https://www.odoo.com/odoo/2328/tasks/4517138) https://github.com/odoo/o-spreadsheet/commit/6b904e4fd [FIX] composer: broken right-to-left selection [Task: 4592612](https://www.odoo.com/odoo/2328/tasks/4592612) 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>