POI Formulas & local languages

2016-12-11 Thread Pierre MIEHE
(HSSFWorkbook) I get the local version of the function names: e.g. DUREE.MODIFIEE and PRIX.TITRE (in French). How could I get the English version of the formula with HSSFWorkbooks? Many thanks in advance for your help and best wishes, Pierre Pierre MIEHE Actuary IA Tel.: +33 (0)6 10 40 68 91

RE: POI Formulas & local languages

2016-12-11 Thread Pierre MIEHE
ng FormulaPrice = sheet.GetRow(2).GetCell(14).CellFormula; Return FormulaDuration+" / "+FormulaPrice; } " Thank you! Pierre Pierre MIEHE Actuary IA Tel.: +33 (0)6 10 40 68 91 Linkedin: https://fr.linkedin.com/in/pierremiehe Skype: pierre.miehe1 Twitter: https://twitter.com/mi

Error in Sumifs/countifs functions?

2017-05-03 Thread Pierre MIEHE
Dear all, I am currently using the NPOI version of POI for C#, and I have a doubt about the countifs and sumifs function: it seems they give wrong results no? I looked at the code on http://www.lookatsrc.com/source/org/apache/poi/ss/formula/functions/Countifs.java?a=org.apache.poi:poi and I have

RE: Error in Sumifs/countifs functions?

2017-05-04 Thread Pierre MIEHE
? Hi, Which version of POI is this? Can you try with the latest release 3.16? There have been fixes in this area, especially https://bz.apache.org/bugzilla/show_bug.cgi?id=56822 seems to be related. Dominik. On Wed, May 3, 2017 at 3:27 PM, Pierre MIEHE wrote: > Dear all, > > I am curre