Array formulas (those enclosed in curly braces) are not supported in POI-3.6.
Try the 3.8-beta2, they should work. Yegor On Tue, May 24, 2011 at 1:54 PM, Hepzibah Rajulah <[email protected]> wrote: > 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 > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
