Formula causes message: "do you want to save changes" when closing a spreedsheet

Aspose.Cells Product Family
1

Is there anyway to turn this off. I don't want the warning.

All else works fine.

2
Hi,

For ignoring the warning message (when opening the resultant file and closing it into ms excel), please set ReCalcOnOpen attribute to false before saving your workbook. Also, kindly try our latest version (4.7.0).

See the following Sample code:

Sample code:

Workbook workbook = new Workbook();
Worksheet ws = workbook.Worksheets["Sheet1"];
ws.Cells[0, 0].PutValue(5);
ws.Cells[1, 0].PutValue(6);
ws.Cells[2, 0].PutValue(7);
ws.Cells[3, 0].PutValue(8);
ws.Cells[4, 0].PutValue(9);
ws.Cells[5, 0].PutValue(10);
ws.Cells[6, 0].Formula = "=SUM(A1:A6)";
workbook.CalculateFormula();
workbook.ReCalcOnOpen = false;
workbook.Save(@"f:\test\resbook_test.xls");

Thank you.

3

Thank you, that works.