Odoo Changelog — 2022-03-29

Tuesday, March 29, 2022

3 changes · master

Improvements(2)

Enhancements to existing features

master spreadsheet 2903 BI

Enterprisemasterdocuments_spreadsheet_bundleMEDIUM

The spreadsheet component used in Documents has been updated to a newer version. This brings several small reliability and usability improvements, including better formula guidance, more consistent sheet handling, improved row and column movement, and cleaner display of large fonts and merged cells.

Original PR description

- [IMP] documents_spreadsheet_bundle: update o_spreadsheet to latest version
- [IMP] documents_spreadsheet_bundle: update o_spreadsheet to latest version

#spreadsheet#documents#usability#stability

[IMP] documents_spreadsheet_bundle: update o_spreadsheet to latest version

PR #25683

Enterprisemasterdocuments_spreadsheet_bundleMEDIUM

This update refreshes the embedded spreadsheet engine used in Documents. It improves reliability when moving rows or columns, displaying large text and merged cells, and showing formula or error guidance, making spreadsheet work smoother for users.

Original PR description

### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/82a7624a [FIX] formulas: remove trailing chars in DATE args description…

### Contains the following commits:

https://github.com/odoo/o-spreadsheet/commit/82a7624a [FIX] formulas: remove trailing chars in DATE args description
https://github.com/odoo/o-spreadsheet/commit/41cfb8fb [FIX] sheet: undeterministic sheet id
https://github.com/odoo/o-spreadsheet/commit/bc26d9ff [FIX] selection: preserve columns/rows size on moving
https://github.com/odoo/o-spreadsheet/commit/fb66021e [IMP] tests: introduce move columns-rows helpers
https://github.com/odoo/o-spreadsheet/commit/88d20005 [IMP] composer: changed formula bracket or string highlight color
https://github.com/odoo/o-spreadsheet/commit/96bdf7fa [FIX] functions: remove some optional flags
https://github.com/odoo/o-spreadsheet/commit/f20b977a [FIX] functions: Split multiple repeatable args everywhere
https://github.com/odoo/o-spreadsheet/commit/9e32f9f6 [IMP] functions: Only allow valid function names in registry
https://github.com/odoo/o-spreadsheet/commit/657aa592 [FIX] popover: error tooltip position
https://github.com/odoo/o-spreadsheet/commit/ddae1e94 [FIX] renderer : number align wrong for big font
https://github.com/odoo/o-spreadsheet/commit/9d0252d0 [FIX] renderer : clipping inside merges

#spreadsheet#documents#usability#reliability

Bug Fixes(1)

Resolved issues and error corrections

[REF/FIX] web_enterprise: refactor and fix expiration panel

PR #25587

Enterprisemasterweb_enterpriseweb_studioMEDIUM

The expired subscription experience was adjusted so users can still interact with the subscription renewal panel even when the rest of the interface is blocked. Subscription-related logic was also reorganized into a clearer shared service, improving consistency between expired and soon-to-expire states.

Original PR description

Previously, when the user's subscription had expired, we would block the
UI. In 14.0 and under, the expiration panel was moved into the blockUI
overlay so that the user could still interact with the expiration panel.
With the wowl refactoring, the ui service doesn't expose an API to do
anything similar, as the desired semantics for such an API are unclear
(in particular: in the case of multiple calls to blockUI with different
content, which should we choose? Should we stack them? Should unrelated
code be allowed to unblock the ui?)

This commit fixes that by introducing a main component that will function
similarly to the blockUI overlay and that contains a different copy of
the expiration panel. Since both expiration panels should share most of
their state, the parts of the logic that are related to managing the
enterprise subscription have been extracted to the enterprise service
(which was renamed to enterprise_subscription service to better match
its purpose). With that, when the subscription is exprired, the home
menu will signal on the bus that the UI should be blocked by the
expiration panel, and when the subscription is almost expired, it will
render the expiration panel within itself as usual.

#subscription#expiration#user interface

### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/82a7624a [FIX] formulas: remove trailing chars in DATE args description https://github.com/odoo/o-spreadsheet/commit/41cfb8fb [FIX] sheet: undeterministic sheet id https://github.com/odoo/o-spreadsheet/commit/bc26d9ff [FIX] selection: preserve columns/rows size on moving https://github.com/odoo/o-spreadsheet/commit/fb66021e [IMP] tests: introduce move columns-rows helpers https://github.com/odoo/o-spreadsheet/commit/88d20005 [IMP] composer: changed formula bracket or string highlight color https://github.com/odoo/o-spreadsheet/commit/96bdf7fa [FIX] functions: remove some optional flags https://github.com/odoo/o-spreadsheet/commit/f20b977a [FIX] functions: Split multiple repeatable args everywhere https://github.com/odoo/o-spreadsheet/commit/9e32f9f6 [IMP] functions: Only allow valid function names in registry https://github.com/odoo/o-spreadsheet/commit/657aa592 [FIX] popover: error tooltip position https://github.com/odoo/o-spreadsheet/commit/ddae1e94 [FIX] renderer : number align wrong for big font https://github.com/odoo/o-spreadsheet/commit/9d0252d0 [FIX] renderer : clipping inside merges

Previously, when the user's subscription had expired, we would block the UI. In 14.0 and under, the expiration panel was moved into the blockUI overlay so that the user could still interact with the expiration panel. With the wowl refactoring, the ui service doesn't expose an API to do anything similar, as the desired semantics for such an API are unclear (in particular: in the case of multiple calls to blockUI with different content, which should we choose? Should we stack them? Should unrelated code be allowed to unblock the ui?) This commit fixes that by introducing a main component that will function similarly to the blockUI overlay and that contains a different copy of the expiration panel. Since both expiration panels should share most of their state, the parts of the logic that are related to managing the enterprise subscription have been extracted to the enterprise service (which was renamed to enterprise_subscription service to better match its purpose). With that, when the subscription is exprired, the home menu will signal on the bus that the UI should be blocked by the expiration panel, and when the subscription is almost expired, it will render the expiration panel within itself as usual.