[FIX] functions: allow to match empty cells

[LucasLefevre]

Description:

description of this task, what is implemented and why it is implemented that way.

Task: : 4023057

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]

[laa-odoo]

the behavior that "*" does not catch empty cells while "<>..." catches them seems weird to me. However this is the behavior observed on Excel and Google.

This therefore makes me say that the code which was added specifically to resolve this case should not be there. But that the behavior observed on Google and Excel must be the side effect of code used on a larger scale.

to see if, depending on the difficulty encountered on the fwp, the fix should not be done elsewhere

[laa-odoo]

@robodoo r+

[LucasLefevre]

I cherry-picked the commits in master: everything is fine :ok_hand:

[robodoo]

@LucasLefevre @laa-odoo because this PR has multiple commits, I need to know how to merge it:

• merge to merge directly, using the PR as merge commit message
• rebase-merge to rebase and merge, using the PR as merge commit message
• rebase-ff to rebase and fast-forward

[LucasLefevre]

robodoo rebase-ff

[robodoo]

Merge method set to rebase and fast-forward.