Wednesday, June 5, 2024
2 changes · saas-17.2
Resolved issues and error corrections
This update refreshes Odoo's spreadsheet engine with several fixes that make day-to-day spreadsheet work more reliable. Users should see fewer issues when pasting charts, editing sheets, using formulas, exporting files, and working with charts or conditional formatting.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/086af6d9a [REL] 17.2.9 Task: 0 https://github.com/odoo/o-spreadsheet/commit/eb6592c40 [FIX] package: saas-17.2 is no…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/086af6d9a [REL] 17.2.9 Task: 0 https://github.com/odoo/o-spreadsheet/commit/eb6592c40 [FIX] package: saas-17.2 is no longer the latest version Task: 0 https://github.com/odoo/o-spreadsheet/commit/cc5e097fb [FIX] clipboard: cannot paste chart with deleted ranges Task: 3618758 https://github.com/odoo/o-spreadsheet/commit/2d3d75e67 [FIX] FigureComponent: Stop Ctrl+A propagation Task: 3863300 https://github.com/odoo/o-spreadsheet/commit/6ea6ed083 [FIX] functions: throw errors with formula that return range Task: 3918882 https://github.com/odoo/o-spreadsheet/commit/4ace22d3c [FIX] module array: accept negative index on choose cols/rows Task: 3918882 https://github.com/odoo/o-spreadsheet/commit/c2b60528b [FIX] functions: Conditional functions now handle ranges with different size Task: 3918882 https://github.com/odoo/o-spreadsheet/commit/88a94589c [FIX] functions: correctly handle simple arguments on conditional functions Task: 3918882 https://github.com/odoo/o-spreadsheet/commit/ee96f3f57 [PERF] evaluation: faster spreading Task: 0 https://github.com/odoo/o-spreadsheet/commit/e02dca3e0 [FIX] clipboard: do not change clipboard state on INSERT_CELLS Task: 3874117 https://github.com/odoo/o-spreadsheet/commit/37d51bd4f [FIX] xlsx: Skip non-exported formula with no result Task: 3491974 https://github.com/odoo/o-spreadsheet/commit/8d850d06d [FIX] cf: drag & drop CF break on scroll Task: 3951043 https://github.com/odoo/o-spreadsheet/commit/985b2ba68 [FIX] BottomBarSheet: give focus back to grid after sheet name edition Task: 3945145 https://github.com/odoo/o-spreadsheet/commit/dfcbc9a31 [FIX] chartjs: remove forced hover dot size Task: 3869065 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: 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 prevents delivery orders for different customers from being combined in two-step delivery workflows. It preserves the correct delivery address and ensures each customer gets a separate outbound delivery order.
Original PR description
### Issue: Pickings associated to different customers are merged in 2 steps delivery setups. ### Steps to reproduce: - Create 2 storable products: P1 and P2 - Enable multistep routes in the settings…
### Issue: Pickings associated to different customers are merged in 2 steps delivery setups. ### Steps to reproduce: - Create 2 storable products: P1 and P2 - Enable multistep routes in the settings > set Warehouse Routes - Create a new warehouse WH2 with 2 steps delivery - Go to inventory > Pick (WH2) - Create and validate a new pick for Customer 1: 1 x P1 Note: A delivery order was created for customer 1 - Create and validate a new pick for Customer 2: 1 x P2 ### Expected behavior: A delivery order is created for customer 2 ### Current behavior: The new delivery order is merged with delivery order created for customer 1 and the delivery address is erased as the picking would be associated with 2 contacts. ### Cause of the issue: When generated for the customer delivery is generated by the 2 step delivery the `_assign_picking` methods tries to assign the move to an existing picking if possible: https://github.com/odoo/odoo/blob/71b4a97c9e3da94bfc0130371db2c02beb81eebe/addons/stock/models/stock_move.py#L1250-L1254 However, the `partner_id` is only used in the search domain of this picking if the usage of the `location_id/dest_id` is a transit: https://github.com/odoo/odoo/blob/71b4a97c9e3da94bfc0130371db2c02beb81eebe/addons/stock/models/stock_move.py#L1240-L1241 This should also be the case when the destination is a customer. ### Note: The issue did not occur prior to saas-17.2 since no "Out" transfer were generated by manual pick transfer in 2 steps delivery prior to this version. opw-3857526 --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr