Hi, I am using POI 3.5 beta 5.
I used this method to write a small program and it is working. rgds, > From: [email protected] > To: [email protected] > Subject: Re: SUMIFS function > Date: Sun, 12 Apr 2009 23:56:48 -0700 > CC: [email protected] > > > > 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 just > >> need 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] > _________________________________________________________________ What can you do with the new Windows Live? Find out http://www.microsoft.com/windows/windowslive/default.aspx
