https://bugs.documentfoundation.org/show_bug.cgi?id=171682
--- Comment #7 from ady <[email protected]> --- (In reply to m_a_riosv from comment #6) > Created attachment 206617 [details] > Sample file with Calc and Excel values. Thank you Miguel. In column B in attachment 206617, you include cases with a tilde character immediately followed by a wildcard-related character. Column B includes the corresponding _search_criteria_ argument for the countif() function. Unfortunately, the important item that attachment 206617 does not include is the _search_criteria_ having a tilde immediately followed by a character that is _not_ related to wildcards. That is the key argument (i.e. the search criteria) that changes the result according to either wildcards, or regex, or none of them. For attachment 206617, we would need the results (in Excel with standard wildcards support, no regex) of a value in column B such as "Where~a", or, even better, a value such as "Where~0" in _both_ columns, A and B, and the corresponding results in Excel. Beware: in Calc, also the "Search criteria = and <> must apply to whole cells" setting must be enabled (ON) for the comparison with Excel to be relevant, AFAIU (but I could be wrong). I am leaving the status of the report unmodified. I still hope that someone can report the results in Excel with a relevant _search_criteria_ argument. -- You are receiving this mail because: You are the assignee for the bug.
