On Apr 12, 2009, at 11:46 PM, Joe Black <[email protected]> wrote:
For example, I want to put the formula
=sumif($A$1:$A$7, $A11, $B$1:$B$7)
in cell B11, I can do like this
row = sheet.createRow(10);
cell = row.createCell(1);
cell.setCellFormula("sumif($A$1:$A$7,$A11,$B$1:$B$7)");
Actually if you try putting sumifs in that way, it seems to throw an error complaining about not knowing sumifs.
It will work. However if my interpretation of your "raw" function is not correct, apologies.
No, you're correct - getting something like the above to work is what I'm trying to do.
Cheers, Filip
rgds,Date: Wed, 8 Apr 2009 17:48:35 -0700 Subject: SUMIFS function From: [email protected] To: [email protected] Hi, I was wondering if anyone has implemented HSSF support for the SUMIFS function ? The SUMIF function is there and works fine, but when using SUMIFS, I'm getting an exception.Alternatively, is it possible to insert a "raw" function via HSSF ? I really don't need HSSF to understand/be able to compute the function result, I justneed to be able to insert the formula and save the spreadsheet. Thanks much for any hints, - Filip_________________________________________________________________ More than messages–check out the rest of the Windows Live™. http://www.microsoft.com/windows/windowslive/
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
