Sunday, March 9, 2025
2 changes · master
Enhancements to existing features
This update refreshes Odoo's spreadsheet engine with improvements to editing, charting, clipboard handling, and Excel export compatibility. Business users benefit from smoother spreadsheet work, more reliable formulas and filters, responsive controls, image clipboard support, and a new funnel chart option.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/f59f5f684 [REL] 18.3.0-alpha.3 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0)…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/f59f5f684 [REL] 18.3.0-alpha.3 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/2df3512b5 [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/2ae78b56c [IMP] cells: do not remove filtered rows when deleting content [Task: 4594840](https://www.odoo.com/odoo/2328/tasks/4594840) https://github.com/odoo/o-spreadsheet/commit/7b88816a4 [IMP] xlsx: support exporting array formulas [Task: 4134347](https://www.odoo.com/odoo/2328/tasks/4134347) https://github.com/odoo/o-spreadsheet/commit/d212ca990 [FIX] *: Scope css rules to o-spreadsheet component [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/41dff1254 [IMP] Clipboard: support images in the clipboard [Task: 4235104](https://www.odoo.com/odoo/2328/tasks/4235104) https://github.com/odoo/o-spreadsheet/commit/cc1c4170d [MOV] tests: move test in correct describe section [](https://www.odoo.com/odoo/2328/tasks/) https://github.com/odoo/o-spreadsheet/commit/e18410f8d [IMP] spreadsheet: adapt data validation formula [Task: 4510482](https://www.odoo.com/odoo/2328/tasks/4510482) https://github.com/odoo/o-spreadsheet/commit/5b15b429a [IMP] TopBar: Add responsiveness [Task: 4562073](https://www.odoo.com/odoo/2328/tasks/4562073) https://github.com/odoo/o-spreadsheet/commit/daf6e9882 [FIX] xlsx: fix conversion of table formulas [Task: 4095599](https://www.odoo.com/odoo/2328/tasks/4095599) https://github.com/odoo/o-spreadsheet/commit/066e8b737 [IMP] chart: add funnel chart [Task: 3619237](https://www.odoo.com/odoo/2328/tasks/3619237) https://github.com/odoo/o-spreadsheet/commit/1a6787c9e [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/1b9bf4a3c [FIX] composer: wrong size for autocomplete dropdown [Task: 4456224](https://www.odoo.com/odoo/2328/tasks/4456224) https://github.com/odoo/o-spreadsheet/commit/7c320a1d0 [FIX] popover: scroll lost on re-render [Task: 4456224](https://www.odoo.com/odoo/2328/tasks/4456224) https://github.com/odoo/o-spreadsheet/commit/dcb8cc4a2 [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/b0ece279a [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/1c5fa6ac2 [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/21fd07819 [FIX] spreadsheet: adapt CF formulas [Task: 4510426](https://www.odoo.com/odoo/2328/tasks/4510426) https://github.com/odoo/o-spreadsheet/commit/3c8419421 [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/455633219 [FIX] Chart: fix data series reordering [Task: 4600194](https://www.odoo.com/odoo/2328/tasks/4600194) 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>
The spreadsheet edition module was updated to work with a changed file storage process used when handling copied content. This keeps image and file handling in spreadsheets aligned with the latest clipboard improvements, helping users avoid disruptions when pasting or managing content.
Original PR description
Following the improvement of the clipboard (see https://www.odoo.com/odoo/2328/tasks/4235104) the record file store API was changed. Task-4235104