Wednesday, May 14, 2025
3 changes · saas-17.4
Resolved issues and error corrections
This update refreshes the spreadsheet engine with fixes that improve calculation accuracy, pivot table handling, copying behavior, and sheet-name matching. Users should see fewer spreadsheet errors and smoother interaction when working with pivots, formulas, and copied spreadsheet data.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/534c5f40f [REL] 17.4.35 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0)…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/534c5f40f [REL] 17.4.35 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/b025f16c5 [FIX] evaluation: fix floating point precision [Task: 4766910](https://www.odoo.com/odoo/2328/tasks/4766910) https://github.com/odoo/o-spreadsheet/commit/8e88bafe6 [FIX] tokenizer: support signed scientific exponent [Task: 4766910](https://www.odoo.com/odoo/2328/tasks/4766910) https://github.com/odoo/o-spreadsheet/commit/daddc0d11 [FIX] pivot: chart field with mix of text and numbers [Task: 4771482](https://www.odoo.com/odoo/2328/tasks/4771482) https://github.com/odoo/o-spreadsheet/commit/97ea27793 [FIX] Stores: skip unnecessary renderings [Task: 4781429](https://www.odoo.com/odoo/2328/tasks/4781429) https://github.com/odoo/o-spreadsheet/commit/b109ddaa3 [IMP] clipboard: copy whole pivot as dynamic pivot [Task: 4771494](https://www.odoo.com/odoo/2328/tasks/4771494) https://github.com/odoo/o-spreadsheet/commit/bae204539 [FIX] composer: empty composer assistant shadow [Task: 4774936](https://www.odoo.com/odoo/2328/tasks/4774936) https://github.com/odoo/o-spreadsheet/commit/068f956e0 [FIX] sheet: make sheetName comparison case insensitive [Task: 4707398](https://www.odoo.com/odoo/2328/tasks/4707398) https://github.com/odoo/o-spreadsheet/commit/c114af479 [FIX] pivot: pivot panel with multiple of same dimensions [Task: 4775660](https://www.odoo.com/odoo/2328/tasks/4775660) 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>
This fix restores the quantity selector when shoppers use the Add to Cart button from the main shop product listing. It ensures customers can choose product quantities directly from the product grid when that option is enabled, reducing checkout friction.
Original PR description
Steps to reproduce: - 1. Install `website_sale` module 2. Go to the shop on the website 3. From the editor>customize, select Button(add to cart) 4. Add the products through add cart button on…
Steps to reproduce: - 1. Install `website_sale` module 2. Go to the shop on the website 3. From the editor>customize, select Button(add to cart) 4. Add the products through add cart button on products You will notice that the Select Quantity option is not visible, (even if the Select Quantity option is enabled). Issue: - - In this [PR](https://github.com/odoo/odoo/pull/196947/files), we fix visibility of quantity buttons based on the [showQuantity](https://github.com/odoo/odoo/blob/aa7fdc055ec399e003cd29f11a48682305a82e26/addons/sale/static/src/js/product/product.xml#L32). But, when we activate the add cart option in all products page we didn't get showQuantity value [here](https://github.com/odoo/odoo/blob/aa7fdc055ec399e003cd29f11a48682305a82e26/addons/website_sale/static/src/js/website_sale_product_configurator.js#L46), due to this buttons are invisible. Solution: - - Add the `js_add_cart_json` class when the Add to Cart option is enabled on the All Products page. We get the `showQuantity` value. The buttons are visible. Before fix: -  After fix: -  **OPW** - [4686969](https://www.odoo.com/odoo/project/70/tasks/4781159) Description of the issue/feature this PR addresses: Current behavior before PR: Desired behavior after PR is merged: --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Purchase orders now warn users when several individually acceptable lines exceed the budget together. This helps prevent approvals or purchases that would push spending over the planned budget.
Original PR description
Description of the issue this commit addresses: When multiple lines that are in budget on their own are above budget when summed together, neither the lines nor the budget button show that the budget will be exceeded. This leads to making purchase orders that shouldn't be made. --- Desired behavior after this commit is merged: This commit makes it so that when the lines together will exceed the budget, the budget smart button and all the lines become red as a single line would. --- task-4710838