You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by abhishek <as...@xora.com> on 2003/09/11 10:26:14 UTC
Suppressing excel warnings using POI
Hi
If we pass numeric data as string in cell.setColumnValue(string) method in
HSSF the excel takes the passed numeric data as string. The excel then shows
a warning message that numeric data is being stored as string. Is it
possible to suppress this warning display programatically?
TIA
Abhishek Vinod Singh
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Suppressing excel warnings using POI
Posted by Avik Sengupta <av...@apache.org>.
If you store a number as a string, it SHOULD warn you, shouldnt it?
Store the number as a number.
On Thu, 2003-09-11 at 13:56, abhishek wrote:
> Hi
> If we pass numeric data as string in cell.setColumnValue(string) method in
> HSSF the excel takes the passed numeric data as string. The excel then shows
> a warning message that numeric data is being stored as string. Is it
> possible to suppress this warning display programatically?
>
> TIA
>
> Abhishek Vinod Singh
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.512 / Virus Database: 309 - Release Date: 8/19/2003
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org