I have seen a negative impact to performance when using ‘Aspose.Cells.Cell.SetFormula’.
I am needing to write over 100k rows to an exported file. I am also passing the FormulaParseOptions and setting Parse = false and CheckAddIn = false.
To compare performance impact as a test, I used ‘Aspose.Cells.Cell.PutValue’ and we can export the file in a minute. With SetFormula it takes 2 hours!
Can someone help me understand how SetFormula can be used without the performance impact?