ble?
>
> Jim
>
> -Original Message-
> From: Michael Zalewski [mailto:zalew...@optonline.net]
> Sent: Tuesday, August 31, 2010 3:13 PM
> To: user@poi.apache.org
> Subject: Re: Help with SUM function
>
> Sounds like you are having a column with Subtotals and Grand To
PM
To: user@poi.apache.org
Subject: Re: Help with SUM function
Sounds like you are having a column with Subtotals and Grand Totals. The SUM
function that yields your grand total does not need to pick out ranges. Just run
the SUM function over the entire column
For example
A B
1 Sup
--Original Message-
From: Michael Zalewski [mailto:zalew...@optonline.net]
Sent: Tuesday, August 31, 2010 3:13 PM
To: user@poi.apache.org
Subject: Re: Help with SUM function
Sounds like you are having a column with Subtotals and Grand Totals. The SUM
function that yields your grand total does n
Sounds like you are having a column with Subtotals and Grand Totals. The SUM
function that yields your grand total does not need to pick out ranges. Just run
the SUM function over the entire column
For example
A B
1 Supplier #1 1.00
2 2.00
3 Subtotal @SUM(B1
I am new to POI and perhaps someone has come up with a creative solution to my
problem already and I have not stumbled across it yet.
Excel's SUM function apparently has a limit of 30 cells when they are comma
separated (ie A2, B15, B 40...).
When we pass our list to the excel file to transform