https://bz.apache.org/bugzilla/show_bug.cgi?id=61624
Bug ID: 61624
Summary: Formula COUNTIFS not converted to Excel French
Version, the formula don't translate COUNTIFS to
NB.SI.ENS
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: critical
Priority: P2
Component: SS Common
Assignee: dev@poi.apache.org
Reporter: hbenfegh...@wideagency.com
Target Milestone: ---
My formula :
&(COUNTIFS(G5:G{0},"DISPO",T5:T{0},"IDF",C5:C{0},"<>STOP")+COUNTIFS(G5:G{0},"DISPO
PA",T5:T{0},"IDF",C5:C{0},"<>STOP")+COUNTIFS(G5:G{0},"DISPO
PARTIELLE",T5:T{0},"IDF",C5:C{0},"<>STOP")/2)&" / dont PA :
"&COUNTIFS(G5:G{0},"DISPO PA",T5:T{0},"IDF",C5:C{0},"<>STOP")
My code :
Cell cellG = myRow.createCell(7);
cellG.setCellFormula(formuleXSemaine);
FormulaEvaluator evaluatorG =
workbook.getCreationHelper().createFormulaEvaluator();
CellValue evaluateG = evaluatorG.evaluate(cellG);
When i evaluate my formule the result is good, but when i open my XLS File the
formula doesn't work i have #NOM? and COUNTIFS isn't converted to NB.SI.ENS
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@poi.apache.org
For additional commands, e-mail: dev-h...@poi.apache.org
