[FW][FIX] find_and_replace: fix previous command

fw-bot commented 2 weeks ago

[FIX] find_and_replace: fix previous command

Problem

The problem occurs when we perform a search using "Find & Replace". In fact, when going backward to a previous occurrence that is located in the previous sheet, we match the first occurrence of that sheet, when actually we need to match on the last occurrence of that sheet.

Solution

This commit solves the issue by checking whether the sheet switch is automatic (coming from the Previous button).

Task: 3839575

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

Forward-Port-Of: odoo/o-spreadsheet#4250

robodoo commented 2 weeks ago

fw-bot commented 2 weeks ago

This PR targets saas-17.3 and is part of the forward-port chain. Further PRs will be created up to master.

More info at https://github.com/odoo/odoo/wiki/Mergebot#forward-port

odoo / o-spreadsheet