Daily updates from Odoo
Wednesday, July 20, 2022
2 changes
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