Re: COUNTIF Formula results in #VALUE

[andy]

I thought we fixed that, the flag to tell excel to recalculate
uncalculated cells seems to be unset.  What version of POI?

Lior Shliechkorn wrote:

Hello,

I've created an excel file, which I need to create a
column of rows where I want to use the COUNTIF
function. My method currently is creating a temp file
of the report I generated, and then re-read the file
in to modify cells to contain the formula.

I managed a row index called GLOBAL_ROW_COUNT and I
basically have the following code block:

 private void modifySheet( HSSFSheet sheet ) {
        HSSFRow row = null;
        HSSFCell cell = null;
        for( short i = 2; i < (GLOBAL_ROW_COUNT - 1); i++ )
{
                row = sheet.getRow( i );
                cell = row.getCell( (short) 19 );
                cell.setCellFormula( "COUNTIF(S3:S" +
(GLOBAL_ROW_COUNT - 1) +",S" + ( i + 1 ) + ")" );           
        }
 }

So this scans the whole column for instances of the
current cell within that column. Now, I'm getting a
#VALUE result. But when I hit F2 to modify the cell
and then simply just hit enter I see the correct
value. What can I do to solve this issue?

Thank you very much,

Lior Shliechkorn

__________________________________ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more.
http://info.mail.yahoo.com/mail_250

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]