We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

ArrayFormula in a single cell

When trying to recalculate the attached sheet, Aspose.Cells fails to recalculate with the following exception:

Exception in thread “main” com.aspose.cells.FormulaCalcException: Sheet1!B1[=SUM(IF(2:2<>"",IF(2:2<>“Type name here”,1,0),))]
at com.aspose.cells.Cell.h(Unknown Source)
at com.aspose.cells.Cell.g(Unknown Source)
at com.aspose.cells.fP.a(Unknown Source)
at com.aspose.cells.fP.a(Unknown Source)
at com.aspose.cells.eG.a(Unknown Source)
at com.aspose.cells.Workbook.calculateFormula(Unknown Source)
at AsposeCellsTestMain.main(AsposeCellsTestMain.java:22)

The affected cell (B1) contains the following array formula:
{=SUM(IF(2:2<>"",IF(2:2<>“Type name here”,1,0),))}

The following code was used to recalculate the workbook:
Workbook workbook = new Workbook();
workbook.open(“aspose-array-formula.xls”);
workbook.calculateFormula(false);

Does Aspose.Cells support array formulas at all ? Or does is simply not support single-cell array-formulas ?

With kind regards,

Barry Lagerweij

Hi,

Thanks for providing us the sample file here.

I have found the issue as you have mentioned. I have logged your issue into our issue tracking system with an id: CELLSJAVA-20002. Once we figure it out, we will let you know.

Thank you.

<!–[if gte mso 10]> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";}

<![endif]–>

Hi,

Please try the attached version. We have fixed the issue of calculating given array formula.

Thank you.

The issues you have found earlier (filed as 20002) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.