poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dimitri Pissarenko <dimitri.pissare...@gmx.net>
Subject Re: HSSF, Problem with a formula
Date Sun, 16 Nov 2003 20:33:32 GMT
>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


Mime
View raw message