poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 61624] Formula COUNTIFS not converted to Excel French Version, the formula don't translate COUNTIFS to NB.SI.ENS
Date Tue, 17 Oct 2017 23:16:13 GMT

Greg Woolsey <gwoolsey@apache.org> changed:

           What    |Removed                     |Added
                 OS|                            |All

--- Comment #1 from Greg Woolsey <gwoolsey@apache.org> ---
POI doesn't do any formula translation, that's all done in Excel UI
localization code.  

POI operates only on the OOXML file, and the OOXML spec (and all files saved by
internationalized versions of Excel) save all formulas and formats in US locale

Thus if you want to set a formula for a cell using POI, you need to set the US
English function names, the ones listed as supported by POI [1]

[1] https://poi.apache.org/spreadsheet/formula.html

You are receiving this mail because:
You are the assignee for the bug.
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

View raw message