https://bugs.documentfoundation.org/show_bug.cgi?id=153214
--- Comment #2 from [email protected] --- Thank you for your quick reply. I completely missed that point where Excel doesn't handle collections for COUNTIF. In my case, replacing the string collection by a range is not possible as I can't modify cell content. My .xlsx files being automatically generated, I dropped COUNTIF({'A', 'B', ...})>1 for OR(A1='A', A1='B', ...) and it solved my issue. I don't know what would be best fit to avoid such surprise when exporting to .xslx. Here are just few ideas: - automatically replace COUNTIF(collection, criteria) by a SUM(value1=criteria, value2=criteria, ...)? Not sure it works in all scenarios - trigger a dedicated warning if using COUNTIF(collection, criteria)? - simply warn user when reopening an xlsx file with Calc as Excel is already doing? -- You are receiving this mail because: You are the assignee for the bug.
