RE: Auto sum

["H@rry" <ap...@SoftHome.net>]

Can you check when your program is writing the cells,
it does set the cell type to numeric?

cell.setCellType(HSSFCell.CELL_TYPE_NUMERIC)

If not, the cell value is treated as a text and thus the sum does not
compute



In Excel application, the type is auto determined when we enter the value.
Therefore when you press enter on each cell, the type is automatically set
to
numeric and the value is added to the sum.



-----Original Message-----
From: Raghuveer Rao [mailto:raghuveer_rao@yahoo.com]
Sent: Friday, January 31, 2003 12:00 AM
To: poi-user@jakarta.apache.org
Subject: Auto sum


Hi,
I am using POI in a large project. I have found it
very easy to use. I have a small problem. I am not
sure if it is POI related but I hope people in this
group can help me out.

I create a spreadsheet with POI and it works fine. The
user downloads the generated spreadsheet onto his
machine and then open it and selects a column and hits
autosum button, corrects the formula and hits enter.
The sum always is zero. If the user goes to each cell
and hits enter the value of the cell is added to the
sum cell. Is this a POI bug or an Excel feature.
I am using poi 1.5.1.

Any help appreciated.

Thanks
Raghu

__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com

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