### Contains the following commits:

https://github.com/odoo/o-spreadsheet/commit/3e43a462d [REL] 18.1.20 [Task: 0](https://www.odoo.com/odoo/2328/tasks/0)
https://github.com/odoo/o-spreadsheet/commit/7d09ed2f0 [FIX] evaluation: fix floating point precision [Task: 4766910](https://www.odoo.com/odoo/2328/tasks/4766910)
https://github.com/odoo/o-spreadsheet/commit/03538f2d5 [FIX] tokenizer: support signed scientific exponent [Task: 4766910](https://www.odoo.com/odoo/2328/tasks/4766910)
https://github.com/odoo/o-spreadsheet/commit/def746dec [FIX] Stores: skip unnecessary renderings [Task: 4781429](https://www.odoo.com/odoo/2328/tasks/4781429)
https://github.com/odoo/o-spreadsheet/commit/3b13b1005 [FIX] pie chart: shown values are not formatted [Task: 4791081](https://www.odoo.com/odoo/2328/tasks/4791081)
https://github.com/odoo/o-spreadsheet/commit/2f95f0476 [FIX] sheet: make sheetName comparison case insensitive [Task: 4707398](https://www.odoo.com/odoo/2328/tasks/4707398)
https://github.com/odoo/o-spreadsheet/commit/338234379 [FIX] pivot: chart field with mix of text and numbers [Task: 4771482](https://www.odoo.com/odoo/2328/tasks/4771482)
https://github.com/odoo/o-spreadsheet/commit/abd0776d2 [FIX] pivot: pivot panel with multiple of same dimensions [Task: 4775660](https://www.odoo.com/odoo/2328/tasks/4775660)
https://github.com/odoo/o-spreadsheet/commit/ebbb2ebd5 [FIX] composer: empty composer assistant shadow [Task: 4774936](https://www.odoo.com/odoo/2328/tasks/4774936)
https://github.com/odoo/o-spreadsheet/commit/0e72ab317 [REV] pivot: re-introduce pivot missing cell insertion [Task: 4707732](https://www.odoo.com/odoo/2328/tasks/4707732)
https://github.com/odoo/o-spreadsheet/commit/e3f442f38 [FIX] Composer: keep focus with interacting with formula assistant [Task: 4771772](https://www.odoo.com/odoo/2328/tasks/4771772)

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>

Steps to reproduce:
---------------------------------------------------------------------------------------------------------------------
- Install the point_of_sale module.
- Enable Loyalty from configuration
- 1. Open Session and add a gift card product to the order.
     Enter a gift card number using a past suggestion (autocomplete).
- 2. Create a new partner from the frontend using autofill

Issue:
----------------------------------------------------------------------------------------------------------------------
- A traceback occurs when the gift card number is selected from the suggestion
 list & create partner using autofill

Cause:
----------------------------------------------------------------------------------------------------------------------
- The event key value is undefined when selecting from autocomplete
  suggestions, causing a crash in the keydown event handler.

Fix:
---------------------------------------------------------------------------------------------------------------------
- Gift card number field suggestion is unnecessary, so remove suggestion and 
  safely handled cases where event key is undefined during keydown events to 
  prevent crashes.
  
  Task:4743765

**Steps to reproduce:**
- Install `sale_commission_linked_achievement` module
- Enable Commissions in settings
- Go to Sales > Commissions > Commissions
- Group By Sales Team
- Error `psycopg2.errors.UndefinedFunction: operator does not exist: text = integer` is triggered

**Issue:**
When generating a raw query with a untyped `NULL` value (`NULL AS team_id`) in a `WITH` subquery, PostgreSQL infers the type as `text` (instead of default `unknown`) when the clause is done. This leads to a comparison error when joining results during the `group_by` operation. 
`ON ("sale_commission_report"."team_id" = "sale_commission_report__team_id"."id")`

Explanation in PostgreSQL source code:
```
* If all the inputs were UNKNOWN type --- ie, unknown-type literals ---
* then resolve as type TEXT.  This situation comes up with constructs
* like SELECT (CASE WHEN foo THEN 'bar' ELSE 'baz' END); SELECT 'foo'
* UNION SELECT 'bar'; It might seem desirable to leave the construct's
* output type as UNKNOWN, but that really doesn't work, because we'd
* probably end up needing a runtime coercion from UNKNOWN to something
* else, and we usually won't have it.  We need to coerce the unknown
* literals while they are still literals, so a decision has to be made
* now.
```
This can be reproduced manually by doing :
```
WITH example AS (
  SELECT NULL AS team_id
)
SELECT pg_typeof(team_id) FROM example;

 pg_typeof
-----------
 text
(1 row)
```

**Fix:**
Explicitly cast the `NULL` value to the proper type using `NULL::INTEGER` to ensure it is treated as an integer during the comparison.

The issue was introduced here : https://github.com/odoo/enterprise/commit/80beef2077c3b4fa7ee6e20dd2f9400a7d1d2273 
And, as the `sale_commission_linked_achievement` will be removed, as well as the `Sales Team` grouping, it should disappear with this : https://github.com/odoo/enterprise/commit/b1e41f9b23aa62bfd6f9be1feb1059b3507f2ce5

opw-4765421