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
term. 

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

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


Mime
View raw message