Thursday, October 6, 2022
3 changes · master
Enhancements to existing features
This update refreshes Odoo's spreadsheet engine, adding clickable dashboard cells and several familiar spreadsheet formulas such as XLOOKUP, MID, PROPER, CLEAN, IFNA, and ISBLANK. Users should see more capable dashboards and better spreadsheet performance, especially for lookup-heavy sheets.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/a6675aa4 [IMP] clickable cell: give env as condition argument https://github.com/odoo/o-spreadsheet/commit/b8420475…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/a6675aa4 [IMP] clickable cell: give env as condition argument https://github.com/odoo/o-spreadsheet/commit/b8420475 [IMP] dashboard: clickable cells https://github.com/odoo/o-spreadsheet/commit/7b1c16b0 [REF] components: use dedicated component for dashboard mode https://github.com/odoo/o-spreadsheet/commit/b3f48d65 [REF] grid: move focusable element to grid https://github.com/odoo/o-spreadsheet/commit/cd083d9b [REF] grid: resize sheet view independently from grid https://github.com/odoo/o-spreadsheet/commit/ed4948b8 [REF] tests: globally mock grid clientX and clientY https://github.com/odoo/o-spreadsheet/commit/011aa0d4 [IMP] spreadsheet: export positionToZone helper https://github.com/odoo/o-spreadsheet/commit/b24e6483 [IMP] formula: ignore space when caching compiled formula https://github.com/odoo/o-spreadsheet/commit/65a67b51 [IMP] package.json: upgrade Typescript https://github.com/odoo/o-spreadsheet/commit/af4f2f58 [IMP] package.json: upgrade prettier https://github.com/odoo/o-spreadsheet/commit/4c15328d [IMP] functions: improve performance of lookup functions https://github.com/odoo/o-spreadsheet/commit/baafa638 [IMP] functions: add XLOOKUP function https://github.com/odoo/o-spreadsheet/commit/3d5c662e [IMP] functions: add MID function https://github.com/odoo/o-spreadsheet/commit/26f24529 [IMP] functions: add PROPER function https://github.com/odoo/o-spreadsheet/commit/07b4201f [IMP] functions: add CLEAN function https://github.com/odoo/o-spreadsheet/commit/adee58ff [IMP] functions: add IFNA function https://github.com/odoo/o-spreadsheet/commit/089f3b8d [IMP] functions: add ISBLANK function https://github.com/odoo/o-spreadsheet/commit/b638a3d5 [IMP] grid: use correct event attribute https://github.com/odoo/enterprise/pull/32358
This update refreshes Odoo's spreadsheet engine with new formula options, faster lookup calculations, and better dashboard interactions. Business users benefit from spreadsheets that are more compatible with familiar spreadsheet tools and dashboards where relevant cells can be clicked to open related data.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/808bd19f [IMP] figure: select figure on insertion https://github.com/odoo/o-spreadsheet/commit/a6675aa4 [IMP]…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/808bd19f [IMP] figure: select figure on insertion https://github.com/odoo/o-spreadsheet/commit/a6675aa4 [IMP] clickable cell: give env as condition argument https://github.com/odoo/o-spreadsheet/commit/b8420475 [IMP] dashboard: clickable cells https://github.com/odoo/o-spreadsheet/commit/7b1c16b0 [REF] components: use dedicated component for dashboard mode https://github.com/odoo/o-spreadsheet/commit/b3f48d65 [REF] grid: move focusable element to grid https://github.com/odoo/o-spreadsheet/commit/cd083d9b [REF] grid: resize sheet view independently from grid https://github.com/odoo/o-spreadsheet/commit/ed4948b8 [REF] tests: globally mock grid clientX and clientY https://github.com/odoo/o-spreadsheet/commit/011aa0d4 [IMP] spreadsheet: export positionToZone helper https://github.com/odoo/o-spreadsheet/commit/b24e6483 [IMP] formula: ignore space when caching compiled formula https://github.com/odoo/o-spreadsheet/commit/65a67b51 [IMP] package.json: upgrade Typescript https://github.com/odoo/o-spreadsheet/commit/af4f2f58 [IMP] package.json: upgrade prettier https://github.com/odoo/o-spreadsheet/commit/4c15328d [IMP] functions: improve performance of lookup functions https://github.com/odoo/o-spreadsheet/commit/baafa638 [IMP] functions: add XLOOKUP function https://github.com/odoo/o-spreadsheet/commit/3d5c662e [IMP] functions: add MID function https://github.com/odoo/o-spreadsheet/commit/26f24529 [IMP] functions: add PROPER function https://github.com/odoo/o-spreadsheet/commit/07b4201f [IMP] functions: add CLEAN function https://github.com/odoo/o-spreadsheet/commit/adee58ff [IMP] functions: add IFNA function https://github.com/odoo/o-spreadsheet/commit/089f3b8d [IMP] functions: add ISBLANK function https://github.com/odoo/o-spreadsheet/commit/b638a3d5 [IMP] grid: use correct event attribute
Resolved issues and error corrections
Allocated time now reflects the full scheduled shift, even when the employee or resource was created after the shift start time. This prevents confusing undercounts during onboarding and also uses the resource calendar when no contract exists.
Original PR description
Steps : \- On a new DB (no demo data). Say created at 15:00. \- Go to planning. \- Add a shift for today. \- Set the dates from 08:00 to 17:00. Issue : The 'Allocated Time' = 02:00. Cause : We used…
Steps : \- On a new DB (no demo data). Say created at 15:00. \- Go to planning. \- Add a shift for today. \- Set the dates from 08:00 to 17:00. Issue : The 'Allocated Time' = 02:00. Cause : We used to count from the resource creation min to the departure max. So, in this case, not from 08:00, but from 15:00. While this might seem logical, it confuses users in onboarding. Fix : Calculate the whole time, regardless of the resource lifespan. Notes : \- Similar issues solved with this commit : > Once the shift validated, the avatar progress bar uses the same allocated time. > Same in Project Task gantt view. \- When contract is installed, if the resource does not have a contract, the Allocated Time = 0. Now, it is calculated from the resource calendar. task-2983993 Description of the issue/feature this PR addresses: Current behavior before PR: Desired behavior after PR is merged: -- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr