>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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
