[FIX] helpers: setXcToFixedReferenceType support all xc

[rmbh-odoo]

Description:

Backport of task 4743563 from saas-18.4. Ensures both parts of an xc reference are treated as static in the standalone composer.

Current behavior before PR:

• The static reference only considered the part before ':'.

Desired behavior after PR is merged:

• Both the part before and after ':' are now correctly treated as static.

Task: 5165969

review checklist

• [ ] feature is organized in plugin, or UI components
• [ ] support of duplicate sheet (deep copy)
• [ ] in model/core: ranges are Range object, and can be adapted (adaptRanges)
• [ ] in model/UI: ranges are strings (to show the user)
• [ ] undo-able commands (uses this.history.update)
• [ ] multiuser-able commands (has inverse commands and transformations where needed)
• [ ] new/updated/removed commands are documented
• [ ] exportable in excel
• [ ] translations (_t("qmsdf %s", abc))
• [ ] unit tested
• [ ] clean commented code
• [ ] track breaking changes
• [ ] doc is rebuild (npm run doc)
• [ ] status is correct in Odoo

[robodoo]

[rmbh-odoo]

@robodoo up to saas-18.3

[robodoo]

Forward-porting to 'saas-18.3'.

[rrahir]

robodoo r+