The spreadsheet tool has been updated with easier pivot filtering, improved large-number display, and better currency formatting. It also fixes an issue with the F4 shortcut selecting too much content, making spreadsheet editing smoother and more reliable for users.

### Contains the following commits:

https://github.com/odoo/o-spreadsheet/commit/93644c4b [IMP] components: set global filter on click on pivot header
https://github.com/odoo/o-spreadsheet/commit/adb8e782 [REF] format: rename currency format type
https://github.com/odoo/o-spreadsheet/commit/05b00cdf [IMP] formulas: introduce FORMAT.LARGE.NUMBER
https://github.com/odoo/o-spreadsheet/commit/b934f06b [IMP] format: support large number with currency
https://github.com/odoo/o-spreadsheet/commit/85af5179 [IMP] format: large numbers
https://github.com/odoo/o-spreadsheet/commit/0200c043 [FIX] composer: F4 shortcut shouldn't always select the whole range

Users now receive a clear warning when spreadsheet saving or real-time collaboration may be stuck because another browser tab has stopped syncing in the background. The message helps users resolve the issue by closing other tabs, reducing confusion around spreadsheets that appear to save indefinitely.

It can happen (somewhat randomly) that your spreadsheet will indefinitely
display "Saving..." on the top righ corner, in the topbar.

Spreadsheet real time synchronisation relies on the polling cross tab bus.
There's actually only one tab actually polling. It then transmit bus events
to other tabs through local storage.
There's one major caveat: if the master tab is in the background, the browser
can decide to throttle it and set it to "sleep". We don't have any control
over it. If that happens, real time synchronisation on all other tabs is
stopped.

With this commit, we try to mitigate the issue by warning the user that
something is wrong and give him a hint to fix the issue (close other tabs).

This problem should be fixed when we will finally use a websocket bus which
won't have this crosstab bus limitation. The websocket bus has been
under developpent for a while now, but things seems very slow to move and we
don't have any ETA and I'm fed up of this infinite "Saving..." showing up
every so often.

Spreadsheet cells that are still loading now show a clear loading state instead of an error indicator. This reduces unnecessary concern for users and makes pivot table loading behavior easier to understand.

Uploading invoice PDFs with embedded Factur-X data in Documents now uses the existing structured invoice information before falling back to OCR. This makes invoice creation more consistent with Accounting uploads and can reduce unnecessary processing.

Before this PR, uploading a Factur-X PDF document in the Documents app resulted in a call to the OCR even though the PDF already contains the structured document.

We should have the same workflow as the Upload button in the Accounting app where we first try to read the embedded Factur-X in the PDF, before sending the invoice to the OCR.

This PR fixes that.

This fixes the placement of benefit icons in the salary configurator after the Bootstrap 5 update. Users will see the salary package options displayed more clearly and consistently, reducing visual confusion during configuration.

The advantage' icons were not correctly positioned anymore.

This fixes a display issue in the Appraisals area where an overlay could appear incorrectly after a Bootstrap update. Users should now see the overlay positioned as expected, reducing confusion during appraisal workflows.

The overlay was not positioned correctly since the merge of Bootstrap 5.

Spreadsheet upgrades now handle invalid formulas without crashing during migration. This helps businesses keep existing spreadsheets accessible and reduces upgrade interruptions when older files contain broken formulas.

Commit 4e27ef0 introduced a migration process to convert PIVOT formulas
parameters. However, this process crashes if the spreadsheet contains some
invalid formulas because it cannot parse them.

This update corrects how Sales Subscriptions selects email templates after a related platform change. It helps prevent subscription-related emails from using the wrong internal format, reducing the risk of email flow errors.

Since https://github.com/odoo/odoo/pull/72368, _find_mail_template now
returns a mail template, and not a mail template id anymore.

This commit adapts the override in sale_subscription that was forgotten
in the above PR/task.

This update aligns Enterprise report generation with the latest core reporting changes, reducing the risk of reports being created with the wrong company or user context. It affects payroll, field service, signing, stock barcode, Belgian and Mexican localization reports, and Studio report customization, helping reports remain accurate across business workflows.

Enterprise part of odoo/odoo#91341

This update simplifies spreadsheet pivot calculation logic to reduce the chance of future mistakes. It does not add new features or change expected user behavior, but helps keep the spreadsheet module more reliable over time.

Fallthrough in switch/case statements is error prone and not a good practice

The menu to export the work entries to SDWorx was always showing, even if the setting was disabled. task-2916468 Forward-Port-Of: odoo/enterprise#29810

The menu to export the work entries to SDWorx was always showing, even
if the setting was disabled.

task-2916468

Forward-Port-Of: odoo/enterprise#29810

The todo notes were shoved to the right of the screen, now they are displayed under the other boxes. task-2908999 Forward-Port-Of: odoo/enterprise#29817

The todo notes were shoved to the right of the screen, now they are
displayed under the other boxes.

task-2908999

Forward-Port-Of: odoo/enterprise#29817

Since https://github.com/odoo/odoo/pull/77254, Quality Checks are not created on the backorders of a MO because the moves of the backorders are not confirmed anymore. We therefore create the QC of the backorders at the confirmation of the workorders Task-ID: 2901900 Community-PR: https://github.com/odoo/odoo/pull/95982 Forward-Port-Of: odoo/enterprise#30010 Forward-Port-Of: odoo/enterprise#29476

Since https://github.com/odoo/odoo/pull/77254, Quality Checks are not
created on the backorders of a MO because the moves of the backorders
are not confirmed anymore. We therefore create the QC of the backorders
at the confirmation of the workorders

Task-ID: 2901900
Community-PR: https://github.com/odoo/odoo/pull/95982

Forward-Port-Of: odoo/enterprise#30010
Forward-Port-Of: odoo/enterprise#29476

In this commit, we have added the edi feature for `Vendor Bill` and `Vendor Credit Note`. When the vendor can not send the invoice to the government, we might need to do it for him. For that, you can create a separate purchase journal where you fill in the DIAN information. That way, the vendor bills on that journal be sent to the government. TaskID - 2522967 Forward-Port-Of: odoo/enterprise#29984 Forward-Port-Of: odoo/enterprise#29689

In this commit, we have added the edi feature for `Vendor Bill` and `Vendor Credit Note`.

When the vendor can not send the invoice to the government,
we might need to do it for him.

For that, you can create a separate purchase journal where you fill in the
DIAN information. That way, the vendor bills on that journal be sent
to the government.

TaskID - 2522967

Forward-Port-Of: odoo/enterprise#29984
Forward-Port-Of: odoo/enterprise#29689

…t without grouping Forward-Port-Of: odoo/enterprise#28887

…t without grouping

Forward-Port-Of: odoo/enterprise#28887

In this commit, we have added a test tour in the sign module. Test Case: ========= - Open Sign Application - Remove filter - Search template - Switch on the list view - Fill in the signed item(User name and Signature ) - Open the dialog signature - Click the Auto sign auto button - Click on Adopt & Sign button - Click on Validate & Send Completed Document button - View the sign document task-2869973 Forward-Port-Of: odoo/enterprise#29314

In this commit, we have added a test tour in the sign module.

 Test Case:
 =========
- Open Sign Application
- Remove filter
- Search template
- Switch on the list view
- Fill in the signed item(User name and Signature )
- Open the dialog signature
- Click the Auto sign auto button
- Click on Adopt & Sign button
- Click on Validate & Send Completed Document button
- View the sign document

task-2869973

Forward-Port-Of: odoo/enterprise#29314

Forward-Port-Of: odoo/enterprise#29554

Forward-Port-Of: odoo/enterprise#29554

Steps to reproduce: - use demo data - install l10n_lu_reports - Go into accounting>reporting>balance sheet and export to xml Issue: - The fields CA BILAN and CA_COMPP would have no lines This feature works in 14.0 but not in 15.0. This is due to a change in the function _get_table() in account.report Previously it would return the id as a int, but in 15.0 this is a string containing the full model name followed by a number. To adapt the current function of 15.0 to the new _ge

Steps to reproduce:
	- use demo data
	- install l10n_lu_reports
	- Go into accounting>reporting>balance sheet and export to xml
Issue:
	- The fields CA BILAN and CA_COMPP would have no lines

This feature works in 14.0 but not in 15.0.
This is due to a change in the function _get_table() in account.report

Previously it would return the id as a int, but in 15.0 this is a string
containing the full model name followed by a number.

To adapt the current function of 15.0 to the new _get_table() I've
simply applied a regex function to extract the last digit in the id
and cast it to an int. After that, the rest of the function can
keep working in the same way as in 14.0.

Forward-Port-Of: odoo/enterprise#29040

Fixed an error where when a draft batch with no pickings but a pick type chosen is accessed from the barcode app and list of available pickings is shown, if the user goes tries to go back the error is thrown. How to reproduce: - In Inventory, create a new batch transfer, choose an operation type and save it; - Open the Barcode app, click on "BATCH TRANSFERS" and remove the "In Progress" filter; - Open the draft batch previously created then click on the arrow to go b

Fixed an error where when a draft batch with no pickings but a pick type chosen
is accessed from the barcode app and list of available pickings is shown,
if the user goes tries to go back the error is thrown.

How to reproduce:
  - In Inventory, create a new batch transfer, choose an operation type
    and save it;
  - Open the Barcode app, click on "BATCH TRANSFERS" and remove the
    "In Progress" filter;
  - Open the draft batch previously created then click on the arrow to
    go back to the batch kanban view > An error occured.

TaskId: 2871679

Forward-Port-Of: odoo/enterprise#29904