Hi,
I think that if you just want to put a "hard coded formula" in a cell, it is
possible.
I am not sure whether you meant that by "raw function"?
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)");
It will work. However if my interpretation of your "raw" function is not
correct, apologies.
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/
