Im having trouble with "refreshing" the content in formulabased cells.
The program flow is as following:
1 - import csv to Datatable
2 - Update content and set formulaes > save to excel with Epplus
3 - Import Excel file to datatable
My flow may seem inlogical, but before importing the excel again to my application I usally have split the excelfiles manually an done som QA, sorting etc :)
In other words I usually - Save the excel file IN MS-EXCEL - before importing it again. The formula values is then correctly updated.
But: in some cases I have to import the ORIGNAL xlsx file, generated with Epplus, without opening it manually and re-saving it with MS-Excel. The problem occures in theese instances. When imorting, none of the formulas show the correct values.