On our current version of Aspose (7?) the function of What-if analysis with the Data Table function does not work properly. Calculations are made, but outcomes are incorrect. We would like to know if updating our Aspose version would resolve this issue. So the question is, is the “Data Table…” function of the “What-If Analysis” fully functional in the latest version of Aspose.Cells?
Background: We use Aspose to create a webform from an Excel file. This file has about 100 sheets and a total of about 200.000 cells with formulas. Right now we use 9 exactly similar sheets with each sheet having almost 20.000 cells with formulas. Only the input for each of these sheet is different. If we could remove 8 of these ‘calculation core’-sheets by using the Data Table function, the speed of our webtool will probably increase a lot.