Iam using POI 3.6
and i have to write the formula
{= SUM(('Datensatz MDS'!$Q$3:$Q$10000=K1)*('Datensatz
MDS'!$R$3:$R$10000=\"G\"))}
{} is added by the key combination ctrl+shift+enter
this is how it is shown in excel cell
and iam doing the same through POI like
cell = row.getCell(DATEN_GREEN_CELL);
formula = "{=SUM(('Datensatz MDS'!$Q$3:$Q$10000=K1)*('Datensatz
MDS'!$R$3:$R$10000=\"G\"))}";
cell.setCellFormula(formula);
When i write it like above it gives formulas parse exception when i set the
formula .
curly braces is a must to get the right data
Can anyone help
Regards
HR
