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