Friday, September 6, 2024
8 changes · saas-17.4
Resolved issues and error corrections
The self-ordering mobile and kiosk experience now avoids showing duplicate product attribute values when the same attribute is used across multiple products. It also hides attributes that represent separate product variants, preventing customers from seeing irrelevant configuration options.
Original PR description
Before this commit, adding the same attribute to multiple products caused the attribute values to appear multiple times in the mobile/kiosk. Moreover, attributes with the variant creation mode were incorrectly displayed as configurable options, despite being intended to represent separate products and not to be shown as options for configuration. opw-4163858 --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
This update refreshes Odoo's spreadsheet component with several fixes that make spreadsheet work more reliable. Users benefit from better Excel exports, improved pivot table insertion, smoother scrolling and selection behavior, and fewer issues during concurrent editing or localized copy-paste operations.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/c14a4c9b8 [REL] 17.4.7 Task: 0 https://github.com/odoo/o-spreadsheet/commit/fe643b772 [FIX] XLSX: Export values along…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/c14a4c9b8 [REL] 17.4.7 Task: 0 https://github.com/odoo/o-spreadsheet/commit/fe643b772 [FIX] XLSX: Export values along the formula string Task: 4141855 https://github.com/odoo/o-spreadsheet/commit/27ff4aefd [FIX] pivots: Allow insertion of both static and dynamic pivots Task: 4137727 https://github.com/odoo/o-spreadsheet/commit/a173ab6e3 [PERF] evaluation: group positions to zones Task: 4160050 https://github.com/odoo/o-spreadsheet/commit/ed160952a [FIX] sheetview: Avoid useless cleanViewport Task: 4084860 https://github.com/odoo/o-spreadsheet/commit/84bf187a1 [FIX] selection: avoid useless selection anchor assignation Task: 4084860 https://github.com/odoo/o-spreadsheet/commit/1a7d2d992 [FIX] session: avoid concurrent updates Task: 4080148 https://github.com/odoo/o-spreadsheet/commit/82c59e6b8 [FIX] bottom bar: handle horizontal scroll Task: 4129625 https://github.com/odoo/o-spreadsheet/commit/ce01a69e0 [FIX] clipboard: Fix paste as value for in localized sheet Task: 4104432 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>
Point of Sale now updates an order to use its rescue session when the order is loaded. This prevents missing session information in the checkout interface and helps staff continue recovering affected orders reliably.
Original PR description
Before when a rescue session was created for an order, it was not loaded in the pos. So the order session_id fields in the frontend was empty. This commit fixes this issue by replacing the current session by the new rescue one when the order is loaded.
Users without Sales access can now open the Contacts app without seeing an access error. The Contacts view now hides the CRM opportunity counter unless the user has the proper Sales permissions, preventing unnecessary access checks.
Original PR description
Versions -------- - saas-17.4+ Steps ----- 1. Have Sales & CRM installed; 2. log in as a user with no access to Sales; 3. open Contacts app. Issue ----- Access Error Cause ----- Commit 855560ed2e21 simplified `res_partner` kanban views. In doing so, it removed the `groups` attribute from the `opportunity_count` button. As a consequence, trying to access the `res_partner` kanban view will always try to compute the `opportunity_count` field, regardless of the user's access rights. Solution -------- Re-add the `groups` attribute to restrict the button to `sales_team.group_sale_salesman` users. opw-4145862
Odoo can now import XLSX files that do not include a specific spreadsheet dimension marker, a format sometimes produced after exporting from Google Sheets. This prevents import errors when users re-upload vendor pricelists or similar spreadsheet data after editing it outside Odoo.
Original PR description
After this https://github.com/odoo/odoo/commit/9b5ae3b38bef70151a1148d760340b35569c454a, the problem arises with some XLSX files (e.g., from Google Sheets). When the library openpyxl tries to parse these files, it fetches dimensions from the dimension tag {http://schemas.openxmlformats.org/spreadsheetml/2006/main}dimension. As a workaround, we can use the calculate_dimension method on the sheet to get the dimensions, which returns the same result.
Steps to reproduce:
- Import Vendor Pricelists.
- Import the same file into Google Sheets.
- Export it from Google Sheets.
- Import it back into Vendor Pricelists.
- An error will occur.
opw-4127978
---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-prThe self-order kiosk language selector now shows the correct language names and flag icons when multiple languages are enabled. This improves the customer ordering experience by making language switching clear and usable.
Original PR description
Steps: ---------- Step 1: Set up the self-order (kiosk) configuration. Step 2: Select multiple languages in the self-order configuration. Step 3: Open the self-order UI page. You'll see the broken language selection on the UI. Issue: ---------- language selection on the self-order UI is broken. Cause: ---------- Use `display_name` instead of `name` and the field `flag_image_url` is not loaded in pos. FIX: --------- Replace "display_name" with "name" and load the "flag_image_url" field in the "pos". task- 4153942
Colombian DIAN electronic invoices linked to sales orders now include the required order reference ID and omit an unsupported sales order field. This helps ensure generated documents follow DIAN requirements and reduces the risk of rejection during electronic invoicing.
Original PR description
Currently, when generating a DIAN document for an invoice related to a sale order, the system creates a `cac:OrderReference` tag but fails to include it's required `cbc:ID` child tag. ### Fix The `order_reference` and `sales_order_id` fields correspond to the `<cbc:ID>` and `<cbc:SalesOrderID>` tags, respectively: https://github.com/odoo/odoo/blob/72e312815f372de88388c47c612bb5f44b4d8b4e/addons/account_edi_ubl_cii/data/ubl_20_templates.xml#L438-L441 The previous code modified the standard UBL format by setting `order_reference=False`, which caused the `<cbc:ID>` tag to be omitted from the `<cac:OrderReference>` element. However, based on official documentation, it seems that the `<cbc:SalesOrderID>` tag should be removed instead, as it is never mentioned there. Therefore, this update changes the logic to set `sales_order_id=False` instead of `order_reference=False`. opw-4124291
Spreadsheet pivot tables now default to the simpler static insertion format instead of dynamic array-style formulas. This makes pivot results easier for everyday users to understand and use without needing advanced spreadsheet formula knowledge.
Original PR description
Dynamic pivot formulas technically are array formulas, which only are used by advanced excel users. The common user will more likely be lost with the concept whereas the static pivots "just work" out of the box. This revision removes the default insertion of pivot formula from their "splilled formula" form to their previous static form. task-4137727