# First fix

Steps to reproduce:
-------------------
1. Install Project and Sales apps
2. Log in as admin user (e.g. Mitchell Admin), and create a billable project for a customer A
3. Invite user B (e.g. Marc Demo) to the project
4. Only give project (user) access rights to the user B, remove all other access rights
5. Create an SO with customer A as partner, add a service product (e.g. Junior Architect), confirm the SO and create a timesheet
6. Log in as user B, create a task in the billable project from the task form, make sure customer A is set as partner
7. Save the task, an access error is raised

Fix:
-------------------
When creating a new task from the form, _inverse_partner_id() is called, which calls task._get_last_sol_of_customer().
As the user has no Sales access, the search of the SOL in _get_last_sol_of_customer() will raise an Access Error in such case.
We add a sudo() before calling _get_last_sol_of_customer() to give the user access to the SOL we are looking for.

# Second fix

Steps to reproduce:
-------------------
1. Configure a user with the project > user and sales > user: own documents access rights
2. Log in with this user
3. Create a task in a billable project (e.g. for Deco Addict)
4. The compute automatically sets an SOL but the current user doesn't have access to the SOL (make sure that the user does not have access to the SOL that is set)
5. Error when trying to update the value of the SOL

Fix:
-------------------
We add a sudo() in _get_partner_display() to give the user access to the SO. As the user may not have access to the SO of the SOL that is currently set in the task.

task-4207245
version-17.2

---
I confirm I have signed the CLA and read the PR guidelines at www.odoo.com/submit-pr

### Contains the following commits:

https://github.com/odoo/o-spreadsheet/commit/139e5a37f [REL] 17.2.27 Task: 0
https://github.com/odoo/o-spreadsheet/commit/807866cd0 [FIX] collaborative: don't snapshot in read-only mode Task: 4344187
https://github.com/odoo/o-spreadsheet/commit/4347a9d46 [FIX] functions: Fix error message of some Lookup functions Task: 4320993
https://github.com/odoo/o-spreadsheet/commit/3961b21fc [FIX] functions: XLOOKUP linear search crashes without lookup values Task: 4320993
https://github.com/odoo/o-spreadsheet/commit/350728d92 [FIX] config: Update task url Task: 0
https://github.com/odoo/o-spreadsheet/commit/fd31d5f58 [FIX] Datavalidation: coreView plugin should not dispatch Task: 4241141
https://github.com/odoo/o-spreadsheet/commit/efdc06bbc [FIX] functions: remove MFILL from source Task: 0
https://github.com/odoo/o-spreadsheet/commit/45b5e0cbf [FIX] evaluation: log when reaching maximum iterations Task: 4252800
https://github.com/odoo/o-spreadsheet/commit/bb85e4430 [FIX] evaluation: Ensure dependency invalidation for array formulas Task: 4252800

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: 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>