You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Karl-Heinz Zengerle <ka...@sawag.com> on 2004/07/06 17:28:39 UTC
formula - Integer expected
Hi world.
What's wrong?
I thought to use the nearly simplest formula sample
oC.setCellFormula("=1+2");
and I receive an exception (Integer expected).
In Excel this would be allowed. Aren't constants within the formula
handled in POI?
Regards, Karl-Heinz.
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: formula - Integer expected
Posted by Roger Misteli <ro...@abacus.ch>.
Shouldn't this be
> oC.setCellFormula("1+2");
according to the documentation, you should omit the = sign. I didn't
test this, but, well, have a try :-)
Regards,
Rog
Centuries ago, Nostradamus forsaw that at
Tue, 6 Jul 2004 17:28:39 +0200 (CEST) Karl-Heinz Zengerle <ka...@sawag.com> would write this:
> Hi world.
>
> What's wrong?
>
> I thought to use the nearly simplest formula sample
> oC.setCellFormula("=1+2");
> and I receive an exception (Integer expected).
>
> In Excel this would be allowed. Aren't constants within the formula
> handled in POI?
>
> Regards, Karl-Heinz.
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
/*
* Roger Misteli - ABACUS Research AG
* email: roger.misteli@abacus.ch (PGP key available)
* "If you think the problem is bad now, just wait until we've solved it."
*/
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org