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

Save prompt when opening file with formulas

Dec 19, 2014 at 6:31 PM
I have a problem: when I save excel with formulas and open it, and then immediately close it without making any changes, it asks me to save changes.

I have found old threads about this behavior, and the reason was because EPPlus didn't have a calculation engine and it's Excel who calculates formulas on load, what is considered as changes. But now in v4 EPPlus have a calculation engine and this problem must disappear, but calling Calculate() doesn't help.

How can I overcome this issue?

You can reproduce this by opening Excel file generated by sample 1 and immediately close it.
Jan 23, 2015 at 11:27 AM
Edited Jan 23, 2015 at 11:28 AM
There's also an issue about this: