Saturday, April 6, 2024
3 changes · master
Enhancements to existing features
This update refreshes Odoo's spreadsheet engine with a new combo chart option, faster calculations in large sheets, and clearer formula highlighting. It also fixes several spreadsheet issues around exports, sheet names, menus, validation, hidden sheets, and browser-specific behavior, making spreadsheet work more reliable for users.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/8c5a22973 [REL] 17.3.0-alpha.2 https://github.com/odoo/o-spreadsheet/commit/105901107 [FIX] Checkbox: unused className…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/8c5a22973 [REL] 17.3.0-alpha.2 https://github.com/odoo/o-spreadsheet/commit/105901107 [FIX] Checkbox: unused className prop in checkbox https://github.com/odoo/o-spreadsheet/commit/4f5e05c43 [FIX] chart: preserve label order when aggregate https://github.com/odoo/o-spreadsheet/commit/c71d79f67 [FIX] xlsx: slice long sheet names at export Task: 3801848 https://github.com/odoo/o-spreadsheet/commit/96873320a [REM] history: remove unused method Task: / https://github.com/odoo/o-spreadsheet/commit/adfef2ccd [PERF] helpers: faster default cell height Task: 3845472 https://github.com/odoo/o-spreadsheet/commit/da87b40b3 [IMP] package: update owl to version 2.2.10 https://github.com/odoo/o-spreadsheet/commit/fbf1079ad [REF] evaluation: simplify getSpreadPositionsOf Task: 3839856 https://github.com/odoo/o-spreadsheet/commit/4a51ad3e3 [REF] evaluation: remove useless method Task: / https://github.com/odoo/o-spreadsheet/commit/ceb1ec955 [IMP] package: update Typescript to version 5.4 https://github.com/odoo/o-spreadsheet/commit/59168b656 [REF] autofill: simplify automatic autofill https://github.com/odoo/o-spreadsheet/commit/2bf123f58 [FIX] *: Compute max/min on huge arrays Task: 3802691 https://github.com/odoo/o-spreadsheet/commit/d85f9c24a [IMP] chart: Add combo chart Task: 3648579 https://github.com/odoo/o-spreadsheet/commit/c22b96d05 [IMP] renderer: highlight array formula Task: 3797136 https://github.com/odoo/o-spreadsheet/commit/6c4a9efa6 [IMP] tests: add `mountComponentWithPortalTarget` helper Task: 3839384 https://github.com/odoo/o-spreadsheet/commit/53e580deb [FIX] SplitIntoColumnsPanel: Panel closes instantly Task: 3829192 https://github.com/odoo/o-spreadsheet/commit/ac1d82f2e [IMP] zones: add comment explaining `hasHeader` flag https://github.com/odoo/o-spreadsheet/commit/e5358f06a [FIX] EditionPlugin: data validation duplicate values https://github.com/odoo/o-spreadsheet/commit/127424011 [IMP] tables: store `getCellComputedStyle` Task: 3768596 https://github.com/odoo/o-spreadsheet/commit/699a47b3c [FIX] spreadsheet: fixed some css https://github.com/odoo/o-spreadsheet/commit/0f8052f14 [REM] helpers: remove unused helpers https://github.com/odoo/o-spreadsheet/commit/efc14e7a2 [FIX] Composer: weird behavior of autocomplete dropdown https://github.com/odoo/o-spreadsheet/commit/1561d0a22 [FIX] BottomBarSheet: Rename a sheet with style content on Firefox Task: 3754944 https://github.com/odoo/o-spreadsheet/commit/e0580b0d2 [FIX] menu: non-aligned menu items Task: 3814222 https://github.com/odoo/o-spreadsheet/commit/1156b2765 [FIX] formula assistant: localize argument separator Task: 3789860 https://github.com/odoo/o-spreadsheet/commit/049c3e942 [IMP] BottomBarStatistic: Keep stats menu open and up-to-date Task: 3820568 https://github.com/odoo/o-spreadsheet/commit/19686a854 [IMP] BottomBarStatistic: cache the statistics results Task: 3820568 https://github.com/odoo/o-spreadsheet/commit/28e33cc42 [IMP] BottomBarStatistic: Fix typo in template name https://github.com/odoo/o-spreadsheet/commit/51354227b [FIX] bottom_bar: disable sheet drag & drop in readonly Task: 3820888 https://github.com/odoo/o-spreadsheet/commit/7f51c2873 [IMP] link: link to hidden sheet warning Task: 3814127 https://github.com/odoo/o-spreadsheet/commit/c14269ce2 [IMP] plugins: remove unused getters Task: 3825311 https://github.com/odoo/o-spreadsheet/commit/f1a14a364 [IMP] bottom_bar: prevent selection of hidden sheets Task: 3801883 https://github.com/odoo/o-spreadsheet/commit/9d960d270 [FIX] export: export non-Excel formulas as value https://github.com/odoo/o-spreadsheet/commit/0c0d3656e [FIX] headers_overlay: unhide cols/rows icon position broken
The spreadsheet components have been updated to a newer library version, bringing improvements that support a more reliable and polished spreadsheet experience. This mainly affects spreadsheet features used inside Documents and should help keep the product aligned with the latest spreadsheet capabilities.
Original PR description
…-alpha.2
Resolved issues and error corrections
This fix restores the ability to process partial refunds for Point of Sale orders. It matters because businesses can once again refund only part of a sale when needed, avoiding incorrect refund handling caused by unreliable order total calculations.
Original PR description
This reverts commit https://github.com/odoo/odoo/commit/7db2c4e760fa9ac1085602c258e737352bc7dcef to allow partial refunding of pos order as the total_amount is not correct anymore. opw-3827876