This project has moved and is read-only. For the latest updates, please go here.

Adding formula results save prompt when excel file is closed

Oct 23, 2014 at 1:24 AM
Edited Oct 23, 2014 at 1:47 AM
I just added the following line in my .net application:
ws.Cell(3, 5).FormulaR1C1 = "RC[-1] - RC[-2]";
Formula works as expected when I open resulting excel file. But when I click close button excel asks me to save changes. How to avoid this prompt? I upgraded to DocumentFormat.OpenXml 2.5 and ClosedXML 0.75; the issue still remains.
Oct 23, 2014 at 1:52 AM
Ok, I found an answer in another thread: