This project has moved. For the latest updates, please go here.

Recipients of xls cannot add formulas manually

Dec 2, 2014 at 5:59 PM
Edited Dec 2, 2014 at 6:00 PM
I have an excel that gets generated and emailed nightly that works correctly. However just recently the xls that gets generated will not allow the user to, for example, insert a new column and put in a formula. The formula only shows up as text. If you click on "Evaluate Formula" it will show the value.

However, if you enter the formula outside of the Inserted Range (so if there are 200 rows of data, you put the formula in Row 201) it will Evaluate as expected.

It does not matter if the file is opened from the hard drive, via email, is read only or completely unprotected, all with the same result.

EPP dll is 4.1.0.1
Office v15
Project Targeted Framework 4.5.1

Line 8 shows a failed Evaluation. Line 11, after the inserted range, shows a successful calculation of the same formula:
Image