[We would therefore like you to report any occurence of #VALUE! in a cell upon opening a POI generated workbook in excel. (Check that typing the formula into Excel directly gives a valid result.) ]
This is the formula that gives the problem:
=IF(COUNTBLANK(G11:I11)=0;SUMPRODUCT(G11:I11;$G$10:$I$10)/SUM($G$10:$I$10);"")
Once "edited" in Excel (without changing anything) it gives the correct result (a calculated number if none of the cells G11:I11 are blank; blank if one of these cells is blank).
Koen.
At 15:31 19/05/2004, you wrote:
Darn! I joined the wrong project :-)
-Ryan
----- Original Message ----- From: "Koundinya (Sudhakar Chavali)" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]> Sent: Wednesday, May 19, 2004 3:47 AM Subject: POI Excel Efficiency related
> Hi All, > > When I have tested the POI and JExcelAPI which are both open > standards, I have identified that JExcelAPI is much better than > POI's HSSF > > The Reasons are > 1. it can handle formulae > 2. It parses much faster than the HSSF > > 1.2 MB filew took 9 seconds form using POI whereas it took only > 4.7 seconds using JEXCELAPI. > > Jexcel API source I have found from > http://www.andykhan.com/jexcelapi/index.html > > Regards > Sudhakar > > ===== > "No one can earn a million dollars honestly."- William Jennings Bryan (1860-1925) > > "Make everything as simple as possible, but not simpler."- Albert Einstein (1879-1955) > > "It is dangerous to be sincere unless you are also stupid."- George Bernard Shaw (1856-1950) > > > > > __________________________________ > Do you Yahoo!? > SBC Yahoo! - Internet access at a great low price. > http://promo.yahoo.com/sbc/ > > --------------------------------------------------------------------- > 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]
--- [This E-mail scanned for viruses by Declude Virus]
--- [This E-mail scanned for viruses by Declude Virus]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
