Wednesday, March 15, 2023
5 changes · master
Enhancements to existing features
The core product version has been updated to mark the master branch as the 16.3 alpha release. This helps align future development, testing, and release planning around the next planned version.
This updates Odoo's spreadsheet engine to a newer version, improving reliability and usability in spreadsheet workflows. Users benefit from fixes to color selection, filtering, sheet navigation, chart display, and Excel exports that now include images.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/2c6fe88a [REL] 16.2.0-alpha.4 https://github.com/odoo/o-spreadsheet/commit/5da3ae45 [FIX] ColorPicker: Convert custom…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/2c6fe88a [REL] 16.2.0-alpha.4 https://github.com/odoo/o-spreadsheet/commit/5da3ae45 [FIX] ColorPicker: Convert custom string to valid HEX color Task: 3224839 https://github.com/odoo/o-spreadsheet/commit/8b1620b8 [FIX] chart_scorecard: adjusted title and baseline description colors https://github.com/odoo/o-spreadsheet/commit/c8dd3159 [REF] figure: unify chart and image menus https://github.com/odoo/o-spreadsheet/commit/cd919f01 [IMP] readme: add npm package https://github.com/odoo/o-spreadsheet/commit/06bd4fe4 [FIX] server: Do not capture exit process event https://github.com/odoo/o-spreadsheet/commit/8beef23d [IMP] package: disable console clearing https://github.com/odoo/o-spreadsheet/commit/aa58c5ac [IMP] package: add task label https://github.com/odoo/o-spreadsheet/commit/3b23d4ee [FIX] bottom_bar: left/right scroll sheet arrows don't WorkbookData https://github.com/odoo/o-spreadsheet/commit/febacd14 [FIX] filters: filter can hide all the visible rows of a sheet https://github.com/odoo/o-spreadsheet/commit/2e34887f [FIX] package: correctly name package entry files https://github.com/odoo/o-spreadsheet/commit/b8efb5ea [IMP] XLSX: export images https://github.com/odoo/o-spreadsheet/commit/635a643b [IMP] spreadsheet: separate ZoneDimension and DOMDimension https://github.com/odoo/o-spreadsheet/commit/734c930c [FIX] package-lock.json: remove git conflict markers https://github.com/odoo/o-spreadsheet/commit/0cad29b7 [IMP] rollup: improve argument handling of rollup.config.js https://github.com/odoo/o-spreadsheet/commit/1296e415 [IMP] bundle_xml: improve the bundling o xml
The work entry pivot report now opens with details grouped by employee and work entry type, making key information visible immediately. Duration is also available as a measure, helping HR teams review time-related work entry data more easily.
Original PR description
before this commit, the pivot view of hr.work.entry model is not showing the details by default. after this commit, the pivot view will be expanded by employee and work entry type and duration is added as measure for the pivot view. Before:  After:  --- I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr
Updates Odoo’s spreadsheet component to a newer version with visual polish, better toolbar and menu behavior, and fixes for colors, filters, and sheet navigation. It also improves spreadsheet exports by including images in XLSX files, making shared files more complete and reliable.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/1633f098 [REL] Bump master version to 16.3.0-alpha.0 https://github.com/odoo/o-spreadsheet/commit/5fa40538 [IMP]…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/1633f098 [REL] Bump master version to 16.3.0-alpha.0 https://github.com/odoo/o-spreadsheet/commit/5fa40538 [IMP] top_bar: added placeholder to topbar composer https://github.com/odoo/o-spreadsheet/commit/4d93a990 [IMP] toolbar: fix style of icons and of hover https://github.com/odoo/o-spreadsheet/commit/2c6fe88a [REL] 16.2.0-alpha.4 https://github.com/odoo/o-spreadsheet/commit/5da3ae45 [FIX] ColorPicker: Convert custom string to valid HEX color Task: 3224839 https://github.com/odoo/o-spreadsheet/commit/8b1620b8 [FIX] chart_scorecard: adjusted title and baseline description colors https://github.com/odoo/o-spreadsheet/commit/c8dd3159 [REF] figure: unify chart and image menus https://github.com/odoo/o-spreadsheet/commit/cd919f01 [IMP] readme: add npm package https://github.com/odoo/o-spreadsheet/commit/06bd4fe4 [FIX] server: Do not capture exit process event https://github.com/odoo/o-spreadsheet/commit/8beef23d [IMP] package: disable console clearing https://github.com/odoo/o-spreadsheet/commit/aa58c5ac [IMP] package: add task label https://github.com/odoo/o-spreadsheet/commit/3b23d4ee [FIX] bottom_bar: left/right scroll sheet arrows don't WorkbookData https://github.com/odoo/o-spreadsheet/commit/febacd14 [FIX] filters: filter can hide all the visible rows of a sheet https://github.com/odoo/o-spreadsheet/commit/2e34887f [FIX] package: correctly name package entry files https://github.com/odoo/o-spreadsheet/commit/b8efb5ea [IMP] XLSX: export images https://github.com/odoo/o-spreadsheet/commit/635a643b [IMP] spreadsheet: separate ZoneDimension and DOMDimension https://github.com/odoo/o-spreadsheet/commit/734c930c [FIX] package-lock.json: remove git conflict markers https://github.com/odoo/o-spreadsheet/commit/0cad29b7 [IMP] rollup: improve argument handling of rollup.config.js https://github.com/odoo/o-spreadsheet/commit/1296e415 [IMP] bundle_xml: improve the bundling o xml
Subscription reporting is being redesigned so teams can analyze recurring revenue changes in pivot views and spreadsheets, instead of relying on the old dashboard. The update separates new revenue, expansion, contraction, and churn, and improves currency handling so results can be compared across companies.
Original PR description
# PURPOSE Before this task, the sale_subscription_dashboard can be used to display statistics about subscriptions but the graphs can't be exported in sheets. The idea is to create sql views and to produce a new dashboard. # SPECIFICATIONS Create subscription logs based on [Sale.order.log](https://sale.order.log/) instead of [account.move.line](https://account.move.line/) New event types : New MRR, Expansion, Contraction, Churn Moreover the log amounts were saved in the currency of the pricelist and in the company currency. When we want to compare revenues from different companies, we need a common currency to allows compare these amounts, even if the are coming from different currencies. The best way to achieve it is to convert it to the currency whose relative rate is equal to 1 and then to the currency of the user displaying the report. These things can only be done in the override of read_group. taskid: 3151840