Monday, May 26, 2025
4 changes · saas-18.3
Resolved issues and error corrections
This update refreshes Odoo’s spreadsheet engine with fixes for pivot sorting, chart resizing, scrolling behavior, autocomplete, localization, and formula handling. It also improves Excel export compatibility by preventing unsupported SPLIT and FILTER functions from being exported, reducing user confusion and file issues.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/fb0d8091c [REL] 18.3.5 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0)…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/fb0d8091c [REL] 18.3.5 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/8deee0b68 [FIX] pivot: `month` granularity sorting [Task: 4781810](https://www.odoo.com/odoo/2328/tasks/4781810) https://github.com/odoo/o-spreadsheet/commit/ea7a3c72e [IMP] xlsx: prevent exporting the SPLIT function [Task: 4766568](https://www.odoo.com/odoo/2328/tasks/4766568) https://github.com/odoo/o-spreadsheet/commit/1a5a9e4aa [FIX] ComposerStore: placeholder should be localized [Task: 4817738](https://www.odoo.com/odoo/2328/tasks/4817738) https://github.com/odoo/o-spreadsheet/commit/9e7fa799b [FIX] Spreadsheet: reset scroll inertia after some time [Task: 4813296](https://www.odoo.com/odoo/2328/tasks/4813296) https://github.com/odoo/o-spreadsheet/commit/8bdbb45b6 [FIX] OT: range adaptation should be case-insensitive [Task: 4717724](https://www.odoo.com/odoo/2328/tasks/4717724) https://github.com/odoo/o-spreadsheet/commit/f7c9ae9f1 [FIX] OT: Fix chart transformations [Task: 4717724](https://www.odoo.com/odoo/2328/tasks/4717724) https://github.com/odoo/o-spreadsheet/commit/91cfaab75 [FIX] auto_complete: showing all proposal on single match [Task: 4735015](https://www.odoo.com/odoo/2328/tasks/4735015) https://github.com/odoo/o-spreadsheet/commit/8f634cb15 [IMP] xlsx: prevent exporting FILTER function [Task: 4766579](https://www.odoo.com/odoo/2328/tasks/4766579) https://github.com/odoo/o-spreadsheet/commit/45797df7e [FIX] chart: charts changing size on update [Task: 4794364](https://www.odoo.com/odoo/2328/tasks/4794364) https://github.com/odoo/o-spreadsheet/commit/417f8e784 [FIX] module logical: keep functional behavior on empty ref [Task: 4775222](https://www.odoo.com/odoo/2328/tasks/4775222) https://github.com/odoo/o-spreadsheet/commit/636f07f16 [FIX] module logical: vectorize only if valid expression [Task: 4775222](https://www.odoo.com/odoo/2328/tasks/4775222) 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>
Barcode scanning could fail when searching for a product because the system used an outdated search parameter. This fix updates the product lookup call so scans complete normally instead of interrupting the user with an error.
Original PR description
The system crashes with an error when attempting to scan a barcode. because `name_search` expects `domain` and it gives `args`. **Error:-** `TypeError: ProductProduct.name_search() got an unexpected keyword argument 'args'` **Issue:-** - The **args** keyword was used to pass the domain filter. However, this is deprecated and not supported by the **name_search** method anymore. The correct keyword is **domain**. Reference:- https://github.com/odoo/odoo/pull/198154 - but this PR misses the line number 297:-https://github.com/odoo/odoo/blob/2f901dde76546baae2f13c978a37d42f7b33299c/addons/web/static/src/views/fields/many2one/many2one.js#L295-L301 **Sentry - 6388425767** I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Customers using self-order delivery can now reuse their saved details without the email field being left blank or locked. This prevents checkout blockers on repeat orders and ensures order confirmation emails are sent correctly.
Original PR description
**Problem:** When ordering a delivery with the self order, you have to fill in your informations. For the second order, you can automatically add those informations that were saved. When doing this second order, the email was not automatically filled in, and it was impossible to manually fill it in, as the field was locked. **Steps to reproduce:** - Go to your self order and make an order. - Fill your informations in. - Pay or cancel it, to be able to make another order. - Make another order and select "Select your address" for it to fill your informations in. - The email is not present and it is not possible to do it manually afterwards. **Why the fix:** The email was never accounted for, we retrieved every other data to create a new res partner, except for the email. It is now given for the creation of this res partner, and is displayed accordingly, allowing to go to the next step, and the email is sent as it should. opw-4795481
ESG Initiative pages now keep the correct web address instead of showing a generic tasks link. This prevents crashes when users copy the link to another browser or enter and leave Studio, making the ESG workflow more reliable.
Original PR description
Have esg_project installed Got to ESG => Act => Initiatives Check the url Before this commit, the url was /odoo/tasks. This posed a number of issues: - Copying this URL in another browser crashed because the context of this action was lost - Entering then leaving studio crashed too, for the same reason. After this commit, the path of the action is correct and reloading it in another browser works correctly. runbot-error-198568