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

fw-bot commented 2 months ago

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#4722

robodoo commented 2 months ago

fw-bot commented 2 months ago

@LucasLefevre @rrahir cherrypicking of pull request odoo/o-spreadsheet#4722 failed.

stdout:

Auto-merging src/functions/helpers.ts
Auto-merging tests/functions/module_math.test.ts
CONFLICT (content): Merge conflict in tests/functions/module_math.test.ts

Either perform the forward-port manually (and push to this branch, proceeding as usual) or close this PR (maybe?).

In the former case, you may want to edit this PR message as well.

:warning: after resolving this conflict, you will need to merge it via @robodoo.

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

odoo / o-spreadsheet

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

Description:

review checklist