poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Danny Mui <da...@muibros.com>
Subject Re: CAN I SPECIFY THE cell "Error Checking Options" using the POI API???
Date Mon, 27 Sep 2004 19:00:32 GMT
http://jakarta.apache.org/poi/apidocs/index.html

I don't see a record that seems to handle that function in the docs. 
Granted, I do not know the name/hex id of the record that handles that 
functionality.

I think i remember a workaround of prepending spaces to these cells.

Steve wrote:
> Two questions:
> 
> 1) what is the meaning/usage of   HSSFCellStyle    ALIGN_GENERAL
> 
> 2)
> I am putting some String values in cells that are HSSFCell.CELL_TYPE_STRING
> Some of these values are not numbers, but some of them are numbers (integers) converted
to String.
> 
> When Excel opens, it puts a small triangle in the upper left corner of the "STRING"
> cells that have "numbers" in them.
> "The number in this cell is formatted as text or preceded by an apostrophe"
> 
> I would prefer if such cell DID NOT have this indicator.
> 
> I know it can be turned off in Excel by editing the Error Checking Options,
> but CAN I SPECIFY THE Error Checking Options using the POI API???
> 
> THANKS,
> Steve
> 
> 

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