https://issues.apache.org/bugzilla/show_bug.cgi?id=45041
--- Comment #2 from Andreas Goetz <[EMAIL PROTECTED]> 2008-05-19 13:21:30 PST --- Based on the 3.1b1 error message I've also investigated if POI was potentially confused by the A:A column notation and changed the formula like this, unfortunately still with the same error message: (1+IRR(SUMIF(A1:A100;ROW(INDIRECT(MIN(A1:A100)&\":\"&MAX(A1:A100)));B1:B100);0))^365-1 I could find if this should work- may be the "Everything else" under unsupported features on the POI website includes my case :( -- Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
