Sunday, March 9, 2025
5 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
Miscellaneous changes
Forward-Port-Of: odoo/enterprise#80854
Original PR description
Forward-Port-Of: odoo/enterprise#80854
\+ tests update in documents_approval Fix owner edit role member after copy or creating inside a folder, including while specifying access_ids. Allow client code to add members to the default members added by the base logic of documents (owner's log) and folders inherited values => Fix HR Payroll Employee Declaration where members of the payroll folder would not have access to the generated documents. The paradigm is: * The owner should always have a "document.access" record create
Original PR description
\+ tests update in documents_approval Fix owner edit role member after copy or creating inside a folder, including while specifying access_ids. Allow client code to add members to the default members…
\+ tests update in documents_approval Fix owner edit role member after copy or creating inside a folder, including while specifying access_ids. Allow client code to add members to the default members added by the base logic of documents (owner's log) and folders inherited values => Fix HR Payroll Employee Declaration where members of the payroll folder would not have access to the generated documents. The paradigm is: * The owner should always have a "document.access" record created * It should be possible to add a member in addition to the inherited ones. * If one passes values for a member when creating, it should override the default value for that partner. * If access_ids is passed as `False`, it should prevent inheriting access (but not prevent a role=False record for owner). * Follow-up of https://github.com/odoo/enterprise/pull/77783, there is no need to enforce logic for owner's `documents.access` role as the owner is basically an empowered editor. Additionally, make sure that * No membership (document.access with role) is created for odoobot * The access of owner is not shown on the permission panel Task-4593290 Forward-Port-Of: odoo/enterprise#81002 Forward-Port-Of: odoo/enterprise#79915
See included commits that * allow deleting unused company folders * prevent quick creating folders in the config settings opw-4444537 Task-4531261 Forward-Port-Of: odoo/enterprise#80992 Forward-Port-Of: odoo/enterprise#78234
Original PR description
See included commits that * allow deleting unused company folders * prevent quick creating folders in the config settings opw-4444537 Task-4531261 Forward-Port-Of: odoo/enterprise#80992 Forward-Port-Of: odoo/enterprise#78234