Wednesday, February 5, 2025
2 changes · saas-17.4
Resolved issues and error corrections
This update brings the spreadsheet component to its latest version with fixes for lookup formulas, hidden headers, borders, and rendering edge cases. Users should see more reliable spreadsheet calculations and cleaner visual display, especially in complex or unusual sheet layouts.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/0c55e1874 [REL] 17.4.21 Task: 0 https://github.com/odoo/o-spreadsheet/commit/c02e7af3d [FIX] formulas: accept simple…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/0c55e1874 [REL] 17.4.21 Task: 0 https://github.com/odoo/o-spreadsheet/commit/c02e7af3d [FIX] formulas: accept simple values on search range for lookup formulas Task: 4543381 https://github.com/odoo/o-spreadsheet/commit/2945914b0 [FIX] Rendering: Skip hidden headers Task: 4535794 https://github.com/odoo/o-spreadsheet/commit/4fc1f2682 [FIX] SheetView: avoid some array allocation https://github.com/odoo/o-spreadsheet/commit/32c057df8 [FIX] SheetView: remove useless/costy calls to Object.x https://github.com/odoo/o-spreadsheet/commit/2bdb1d98c [FIX] Renderer: Do not draw if no canvas Task: 4535794 https://github.com/odoo/o-spreadsheet/commit/d7e4bc593 [FIX] SheetView: Fix viewports with negative dimensions Task: 4535794 https://github.com/odoo/o-spreadsheet/commit/14114f7a2 [FIX] Borders: Fix border continuity Task: 4523890 https://github.com/odoo/o-spreadsheet/commit/2d21ad853 [FIX] renderer: Re-fix box rendering Task: 4526742 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>
Studio report customizations will no longer mark standard report records as protected from future updates. This helps ensure later Odoo upgrades can still apply official report changes, reducing migration errors for customized reports.
Original PR description
Issue: ------ When making changes in version saas-17.4 using studio the correspondent standard view's noupdate becomes 'True' as per the logic implemented. But when we migrate the database to the…
Issue: ------ When making changes in version saas-17.4 using studio the correspondent standard view's noupdate becomes 'True' as per the logic implemented. But when we migrate the database to the further versions like 18.0. The changes made in that particular view in 18.0 will not be loaded and will cause errors since its inherited view's will not be compatible enough. For ex: If we make changes in a "Purchase Order"(i.e; purchase.report_purchaseorder) report then after saving the changes the noupdate of that report view which is "purchase.report_purchaseorder_document" will be updated to 'true'. And the action record i.e; "purchase.action_report_purchase_order" noupdate will be updated to 'true'.   If the customer makes changes using studio then those changes will be recorded in the studio view and there is no point of making the standard view's noupdate to 'true'. Solution: ----------- Remove redundant code to overcome updating noupdate to 'true'. Steps to reproduce: ------------------------ 1. Create a database in version saas-17.4. 2. Make changes in any report using studio and save. 3. Migrate the database and try opening that report. 4. You'll encounter issues due to incompatibilty of views. Since, the changes made in the standard will not be loaded because it's noupdate is true. REF PRS: Enterprise PR: 1. https://github.com/odoo/enterprise/pull/43978/commits/2aac4a554538b3d2cd5abb6c716f4c081480ee5f#diff-cf8f46a54f86279b4d773f0d39b23d22f046eb6d33a39c851f2a86dcd2b5b202R463