Monday, May 12, 2025
4 changes · saas-18.1
Resolved issues and error corrections
Updates the spreadsheet engine with fixes for pivot tables, charts, formulas, and sheet duplication. Business users should see more reliable spreadsheet dashboards and reports, especially when using date-based pivots or interacting with charts.
Original PR description
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/44cc1709b [REL] 18.1.19 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0)…
### Contains the following commits: https://github.com/odoo/o-spreadsheet/commit/44cc1709b [REL] 18.1.19 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0) https://github.com/odoo/o-spreadsheet/commit/0914df76e [FIX] function: IF should not mutate its input [Task: 4783504](https://www.odoo.com/odoo/2328/tasks/4783504) https://github.com/odoo/o-spreadsheet/commit/9e1a75147 [FIX] pivot: handle undefined granularity [Task: 4742696](https://www.odoo.com/odoo/2328/tasks/4742696) https://github.com/odoo/o-spreadsheet/commit/4cae538d1 [FIX] pivot: add missing month granularity [Task: 4742696](https://www.odoo.com/odoo/2328/tasks/4742696) https://github.com/odoo/o-spreadsheet/commit/7c0208121 [FIX] pivot: date dimension detection [Task: 4742696](https://www.odoo.com/odoo/2328/tasks/4742696) https://github.com/odoo/o-spreadsheet/commit/8169b17d1 [FIX] spreadsheet: add name to DUPLICATE_SHEET [Task: 4640070](https://www.odoo.com/odoo/2328/tasks/4640070) https://github.com/odoo/o-spreadsheet/commit/4d39b3e87 [FIX] pivot: cannot use pivot formula inside its range [Task: 3986479](https://www.odoo.com/odoo/2328/tasks/3986479) https://github.com/odoo/o-spreadsheet/commit/2cfa27f74 [IMP] chart: add `mouseup` event to listened events [Task: 4636147](https://www.odoo.com/odoo/2328/tasks/4636147) https://github.com/odoo/o-spreadsheet/commit/e8d281f3b [FIX] charts: unregister ChartJS extension on unmount [Task: 4636147](https://www.odoo.com/odoo/2328/tasks/4636147) https://github.com/odoo/o-spreadsheet/commit/d8d5b403a [FIX] chart: can `UPDATE_CHART` on a non-chart figure [Task: 4775605](https://www.odoo.com/odoo/2328/tasks/4775605) https://github.com/odoo/o-spreadsheet/commit/d50d3059a [FIX] GridComposer: limit the composer size [Task: 4686816](https://www.odoo.com/odoo/2328/tasks/4686816) Co-authored-by: Anthony Hendrickx (anhe) <anhe@odoo.com> Co-authored-by: Alexis Lacroix (laa) <laa@odoo.com> Co-authored-by: Lucas Lefèvre (lul) <lul@odoo.com> Co-authored-by: Dhrutik Patel (dhrp) <dhrp@odoo.com> Co-authored-by: Adrien Minne (adrm) <adrm@odoo.com> Co-authored-by: Mehdi Rachico (mera) <mera@odoo.com> Co-authored-by: Florian Damhaut (flda) <flda@odoo.com> Co-authored-by: Rémi Rahir (rar) <rar@odoo.com> Co-authored-by: Pierre Rousseau (pro) <pro@odoo.com> Co-authored-by: Vincent Schippefilt (vsc) <vsc@odoo.com>
WhatsApp conversations can send voice messages again after a regression blocked the option. The update also prevents conflicts by allowing either one file attachment or one voice recording per WhatsApp message, matching WhatsApp limits.
Original PR description
Before this commit, whatsapp conversations could not send voice message. This is a regression made from this PR: https://github.com/odoo/odoo/pull/186084 This commit re-adds the feature to voice a message in whatsapp. Note that whatsapp conversations allow only 1 attachments per message. Since a voice message is an attachment, this commit makes sure allow voice message only when no attachment, and similarly allow uploading a file only when there's no ongoing voice recording. opw-4750594
Creating a new database from the database manager no longer disrupts the active session from the original database. This prevents internal server errors after database creation, especially when the original database has apps installed that are absent in the new empty database.
Original PR description
Login in a database where utm is installed, so you get a session in that database. Now go to /web/database/manager and create a new empty db, the installation completes but you get an Internal Server Error message, in the logs a traceback: UTM is not installed. The problem is that once the new database has been created, the user automatically gets a new logged-in session inside that new database, but the environment of the original request got (wrongly) updated too, so later on when the request wraps up, we are no longer using the same environment/registry as at the begining of the request and the http stack fails. Solution: only update the request env if the new env is on the same database. Btw, the original implementation with httpocalypse got that part right, but when we did f63c0f4 a few years later we couldn't remember why the `if request.db == dbname` was needed and we decided to remove it, turns out it is indeed needed.
WhatsApp conversations can send voice messages again, restoring a feature that had stopped working after a previous change. The update also prevents users from adding a file while recording a voice message, and only allows voice messages when no other attachment is present, matching WhatsApp's one-attachment limit.
Original PR description
Before this commit, whatsapp conversations could not send voice message. This is a regression made from this PR: https://github.com/odoo/odoo/pull/186084 This commit re-adds the feature to voice a message in whatsapp. Note that whatsapp conversations allow only 1 attachments per message. Since a voice message is an attachment, this commit makes sure allow voice message only when no attachment, and similarly allow uploading a file only when there's no ongoing voice recording. opw-4750594