But i changed the formula to
formula = "SUMPRODUCT(('Datensatz MDS'!$Q$3:$Q$10000=K1)*('Datensatz
MDS'!$R$3:$R$10000=\"G\"))+(NOW()*0)";
and it worked wonders for me ..
Thanks yegor for the input ..
HR
On Tue, May 24, 2011 at 2:07 PM, Yegor Kozlov <[email protected]> wrote:
> 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]
>
>
