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
https://bz.apache.org/bugzilla/show_bug.cgi?id=61624

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
forms.

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


Mime
View raw message