You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Raghuveer Rao <ra...@yahoo.com> on 2003/01/30 17:00:21 UTC
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
Re: Auto sum
Posted by "Andrew C. Oliver" <ac...@apache.org>.
I'm pretty sure this has been fixed in recent builds.
Avik Sengupta wrote:
>It is probably a POI bug. Some help from you would go a long way in
>trying to fix it. attach the minimum amount of code that replicates this
>issue into bugzilla.
>
>On Thu, 2003-01-30 at 21:30, Raghuveer Rao wrote:
>
>
>>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
>>
>>
>>
>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
>
Re: Auto sum
Posted by Avik Sengupta <av...@apache.org>.
It is probably a POI bug. Some help from you would go a long way in
trying to fix it. attach the minimum amount of code that replicates this
issue into bugzilla.
On Thu, 2003-01-30 at 21:30, Raghuveer Rao wrote:
> 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
>
RE: Auto sum
Posted by "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