poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From avik.sengu...@itellix.com
Subject Re: HSSF, Problem with a formula
Date Sun, 26 Oct 2003 20:09:17 GMT
> If I enter formula like "-N155" 
Yes, the parser doesnt handle unary operators at the moment.. but the workaround
is simple, try something like "0-N155"

> I've already tried to use worksheet names without spaces,
Did you remove the quotes around the worksheet name?

Regards
-
avik


Quoting Dimitri Pissarenko <dimitri.pissarenko@gmx.net>:

> >I think its because of the space in the sheet name.. I guess the formula
> parser 
> >doesnt support it... try this with a sheet name without a space... look at 
> 
> I've already tried to use worksheet names without spaces, but it did
> not help.
> 
> Then, I decided to put the rows with the sums into the same worksheet
> and in this way to avoid references to other worksheets. It helped,
> except in one case:
> 
> If I enter formula like "-N155" (i. e. the value of cell N155
> multiplied by -1), I get following exception:
> 
> 2003-11-16 21:26:38,718 DEBUG [processCalculation.bsh] -
> formula=N155*(-1)
> 2003-11-16 21:26:38,718 ERROR [profile.bsh] - 
> java.util.EmptyStackException
> 	at java.util.Stack.peek(Unknown Source)
> 	at java.util.Stack.pop(Unknown Source)
> 	at
> org.apache.poi.hssf.model.FormulaParser.createTree(FormulaParser.java:813)
> 	at
> org.apache.poi.hssf.model.FormulaParser.getRPNPtg(FormulaParser.java:654)
> 	at
> org.apache.poi.hssf.model.FormulaParser.getRPNPtg(FormulaParser.java:650)
> 	at
> org.apache.poi.hssf.usermodel.HSSFCell.setCellFormula(HSSFCell.java:715)
> 
> How can I display a negative value of a cell?
> 
> TIA 
> 
> dap
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 




---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org


Mime
View raw message