poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Avik Sengupta <a...@apache.org>
Subject Re: ATTR(semiVolatile)
Date Tue, 12 Aug 2003 14:02:53 GMT
not really clear what you are really trying to do, but if you want to
set the formula, you say cell.setCellFormula("TODAY()");

the ATTR(semiVolatile) bit is some Excel/poi innards coming out.. dont
bother too much about it... 

I suppose it would be best to ensure that ATTR does not print anything
out on a call to toFormulaString .. however, some code has been written
that assumes such a string return, so thats not an option in the short

hope that helps. If not, please tell us what code you are trying to

On Tue, 2003-08-12 at 19:31, Xuemin Guan wrote:
> Dear all, I am experiencing a problem with formula.
> Say, I have a cell set up a formula: TODAY().
> The HSSFCell.getCellFormula() returns a String representing
> this formula as : TODAY(ATTR(semiVolatile)).
> The ATTR(semiVolatile) is returned by the method
> toFormulaString(SheetReferences refs) of class
> AttrPtg (formula package).
> When I set this as a formula to a new cell, I had the
> following exception:
> Caused by: java.lang.StringIndexOutOfBoundsException: String index out 
> of range: 0
>      at java.lang.String.charAt(String.java:460)
>      at org.apache.poi.hssf.util.CellReference.<init>(CellReference.java:81)
>      at 
> org.apache.poi.hssf.record.formula.ReferencePtg.<init>(ReferencePtg.java:94)
>      at 
> org.apache.poi.hssf.model.FormulaParser.Ident(FormulaParser.java:311)
>      at 
> org.apache.poi.hssf.model.FormulaParser.Factor(FormulaParser.java:484)
> ...
> Then I tried to manually set it in a new cell with the MS-Excel 
> application. The Excel rejected it saying this is an invalid
> formula.
> Any one knows, what I should do about this?
> Thanks a lot,
> Xuemin
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
Avik Sengupta <avik@apache.org>

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

View raw message