You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Hepzibah Rajulah <he...@googlemail.com> on 2011/05/24 11:54:38 UTC
COUNTIF with multiple condition using POI
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
Re: COUNTIF with multiple condition using POI
Posted by Hepzibah Rajulah <he...@googlemail.com>.
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 <ye...@dinom.ru> 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
> <he...@googlemail.com> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
Re: COUNTIF with multiple condition using POI
Posted by Yegor Kozlov <ye...@dinom.ru>.
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
<he...@googlemail.com> 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
how to export delta symbol in pdf
Posted by Lheuillier Damien <da...@gfi.fr>.
Hi,
i used poi in order to export data into pdf format.
The greek symbol delta is not recognized in the pdf.
I tried to replace greek symbol with equivalent "Δ" or "δ"
or "δ" or "0xCE 0xB4" but any replacement is working.
the poi version is 3.5-final
the character encoding is UTF-8.
Thanks for your help.
Damien
Ce message et toutes les pièces jointes (ci-après le « message ») sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, totale ou partielle, est interdite, sauf autorisation expresse des parties. Si vous recevez ce message par erreur, merci de le détruire sans en conserver de copie et d'en avertir immédiatement l'expéditeur. Internet ne permettant pas de garantir l'intégrité de ce message, le groupe GFI Informatique décline toute responsabilité au titre de ce message s'il a été modifié, altéré, déformé ou falsifié. Par ailleurs et malgré toutes les précautions prises pour éviter la présence de virus dans nos envois, nous vous recommandons de prendre, de votre côté, les mesures permettant d'assurer la non-introduction de virus dans votre système informatique.
This email message and any attachments ("the email") are confidential and intended only for the recipient(s) indicated. If you are not an intended recipient, please be advised that any use, dissemination, forwarding or copying of this email whatsoever is prohibited without prior written consent. If you have received this email in error, please delete it without saving a copy and notify the sender immediately. Internet emails are not necessarily secured, and GFI Informatique Group declines responsibility for any changes that may have been made to this email after it was sent. While we take all reasonable precautions to ensure that viruses are not transmitted via emails, we recommend that you take your own measures to prevent viruses from entering your computer system.
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org