Wednesday, July 20, 2022
3 changes · master
Enhancements to existing features
The Intrastat report now shows system and type information together as a single Commodity Flow field, reducing duplicate information for users. Spreadsheet exports keep the simpler system code only, making exported data cleaner while preserving the needed reporting detail.
Original PR description
On the intrastat report the system and type fields represent the same thing and are thus redundant. It therefore makes sense to consolidate them into one field called 'Commodity Flow'. In this commit…
On the intrastat report the system and type fields represent the same thing and are thus redundant. It therefore makes sense to consolidate them into one field called 'Commodity Flow'. In this commit the two fields instead represented as one field, with the 'system' first, and the 'type' following it in brackets e.g. 19 (Dispatch). The xlsx export should instead contain only the 'system' (the 'type' is actually redundant when considering the 'system' codes), so the 'print_xlsx' function is modified such that only the 'system' is used. In order to achieve this distinction, a key 'country_format' is inserted into the options inside of the 'print_xlsx'. The content of this report 'Commodity Flow' field is generated depending on this key. The tests are updated to match this new structure and a new test has been added to test the content of the report under the same conditions as an xlsx export (i.e. codes instead of names). task-id: 2884333 This PR contains the majority of the contents of the original PR: https://github.com/odoo/enterprise/pull/28630, which was closed in v13.0 as the contents would have violated stable policy. The part that is fine to merge in stable is not included in this PR, and is in a different PR in v13.0: https://github.com/odoo/enterprise/pull/29505 (It involves altering the dictionaries containing the key-value pairs of country-code to 'system' for the Netherlands)
This update refreshes the spreadsheet engine with fixes that improve formula recalculation, chart formatting, menu interactions, and demo data links. It also adds support for the TEXT formula, helping users format values more flexibly inside spreadsheets.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/765361db [FIX] Tests: Clean *Registry after tests https://github.com/odoo/o-spreadsheet/commit/1b830e98 [IMP] husky: allow use of pre-commit hook for windows https://github.com/odoo/o-spreadsheet/commit/6306bad9 [FIX] evaluation: re-evaluate async formulas when changing sheets https://github.com/odoo/o-spreadsheet/commit/2b5cf2b4 [FIX] evaluation: re-evaluate errors in other sheets https://github.com/odoo/o-spreadsheet/commit/f3e4efc6 [IMP] Functions: Add `TEXT`function https://github.com/odoo/o-spreadsheet/commit/01f93c8d [FIX] Charts: Set a format on a cell invalidates runtimes https://github.com/odoo/o-spreadsheet/commit/0bf9533f [FIX] formats: use `cell.evaluated.format` https://github.com/odoo/o-spreadsheet/commit/7dd1bc3f [FIX] top_bar: bugged top_bar menu item hitbox https://github.com/odoo/o-spreadsheet/commit/67ec2703 [FIX] spreadhseet: fix link demo data
Resolved issues and error corrections
Historical refund values in the subscription dashboard are corrected so monthly recurring revenue reports show accurate totals. This ensures pivot views and past reporting data align with the fixed calculation, improving confidence in revenue analysis.
Original PR description
https://github.com/odoo/enterprise/commit/9812998643668bc1eaacef69e957b3ff66f0f6fc fixed the MRR computation but older value remained. These value were prefixed with the right amount but pivot views were still wrong for historical data. This commit and the associated upgrade script fix these values. taskid: 2909297