[FW][FIX] functions: COUNTIF count string dates

[fw-bot]

Description:

Steps to reproduce: in A1: ="01/01/2024" in B1: =COUNTIF(A1, "01/01/2024")

The result of B1 is 0, but it should be 1

Bug introduced with bde73c8f277a96c420fbdf33d8b119d6f2742da0

Task: : 4077445

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#4745 Forward-Port-Of: odoo/o-spreadsheet#4722

[robodoo]

[fw-bot]

@LucasLefevre @rrahir this PR targets master and is the last of the forward-port chain containing:

• odoo/o-spreadsheet#4748
• odoo/o-spreadsheet#4746

To merge the full chain, use

@robodoo r+

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

[LucasLefevre]

robodoo r+

On Thu, Aug 1, 2024 at 5:09 PM Otis - Odoo Forward-Port Steward [bot] < @.***> wrote:

@LucasLefevre https://github.com/LucasLefevre @rrahir https://github.com/rrahir this PR targets master and is the last of the forward-port chain containing:

• 4748 https://github.com/odoo/o-spreadsheet/pull/4748

• 4746 https://github.com/odoo/o-spreadsheet/pull/4746

To merge the full chain, use

@robodoo https://github.com/robodoo r+

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

— Reply to this email directly, view it on GitHub https://github.com/odoo/o-spreadsheet/pull/4750#issuecomment-2263315265, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACTHFEPRXXAAYX4POUVOLJLZPJFSXAVCNFSM6AAAAABL2YUOO6VHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDENRTGMYTKMRWGU . You are receiving this because you were mentioned.Message ID: @.***>