CalculateFormula is very slow


#1

Hi,
we want to fill an Excel template with data with Aspose.Cells. This works very well with ImportData. The template contains the following formula in the register to be filled:
=IF(P5="","",INDEX(Tabelle1[WPS_Nr],MATCH(1,MMULT((Tabelle1[Straßenname]=Q5)*(Tabelle1[HsNr]=R5)*(Tabelle1[Gemeinde]=P5),1),0)))
The data in three columns is to be compared with a very extensive list (almost 80,000 lines). Neither the template nor the formula may be changed by us. If we call the method Workbook.CalculateFormula() or Worksheet.CalculateFormula() after importing the data, the execution takes about one second per imported line. This is a very long time for a few hundred to a thousand lines.

We also tested it without CaculateFormula. All formulas in the workbook are then no longer calculated. Therefore we called the function CalculateFullRebuild by Excelautomation. Here the calculation takes 0.1 seconds per line.

Is there a way to perform the calculation faster with Aspose.Cells?

With best thanks and kind regards
Markus


#2

@MarkusPlesoft
Could you please share a template file where data is already populated and the sample console application (runnable) for our testing. We will reproduce the problem and provide our feedback after analysis.