What-If Analysis

Aspose.Cells Product Family
,
1

Hi,

i want to add some information to the Scenario Manager for testing purpose.
But i find out it is not supported by Aspose. Unfortunately these information get lost
after opening and saving it with Aspose. This is an unexpected behavior.

When do you plan to preserve this data at least ?

Kind regards,
Guido

2

Hi,


Could you attach your template file and output file here, we will look into your issue soon.

Thank you.
3

Hi,

i add the ‘before’ and ‘after’ files.

Kind regards,

Guido

4

Hi Guido,


Thanks for the sample files.

I can notice the issue after an initial test. After just opening and re-saving the file by Aspose.Cells, the scenario is removed in the Scenario Manager in Ms Excel.

Sample code:

Workbook workbook = new Workbook(“e:\test2\before.xlsx”);
workbook.Save(“e:\test2\After.xlsx”);

I have logged a ticket with an id “CELLSNET-41316” for your issue. We will look into your issue soon.

Thank you.
5

@Nachti
Please try the latest fix:
Aspose.Cells21.6.1 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.6.1 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.6.1 For .NetStandard20.Zip (5.5 MB)