I have an Excel template which has a table to be filled-up (e.g. A1:C10, 10 rows). I fill up its rows using NPOI in C#. Cells of Column C has a formula that is referencing to other cells (e.g. =SUM(A1:B1)). I also use evaluator.EvaluateFormulaCell(c) to evaluate the formula after writing to cells A&B.
Most of the time, I only write a few rows (e.g. 4 rows) for this table so the other row cells are blank. When this file is saved and opened, it prompts with "We found a problem with some content in 'MyExcel.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this work book, click Yes."
Clicking yes, it prompts again with: Removed Records: Shared formula from /xl/worksheets/sheet1.xml part Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)
The Column C formula is also gone for rows 5 to 10.
When I fill up the whole table, I do not encounter this. When I use evaluator.EvaluateInCell(c) I do not encounter this also, but yes all the formula is gone.
What could be the exact problem? How to retain the formula with blank references without any errors? Thanks!
