https://bz.apache.org/bugzilla/show_bug.cgi?id=61624
--- Comment #3 from Javen O'Neal <[email protected]> --- (In reply to Herve from comment #2) > COUNTIFS is not supported The COUNTIFS function *is* supported for XLSX files as part of the AnalysisToolPak, which must be loaded at runtime. COUNTIFS is not available in XLS. Supported for COUNTIFS was added in POI 3.10 via bug 55873 https://poi.apache.org/changes.html#3.10-FINAL Supported functions: https://poi.apache.org/spreadsheet/eval-devguide.html#Appendix+A Implementation https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/formula/functions/Countifs.java AnalysisToolPak: https://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/formula/atp/AnalysisToolPak.java Unit tests: https://svn.apache.org/viewvc/poi/trunk/src/ooxml/testcases/org/apache/poi/ss/formula/functions/CountifsTests.java OOXML saves formulas as strings instead of binary Ptgs, so it's possible that your version of Excel expects the function names to be translated into your locale. The curly brackets ({0}) in your formula don't look like they're part of the standard Excel formula language spec and very likely not supported by POI. Maybe this is the source of the problem. -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
