So i'm having an issue which is baffling me.
Originally, we have an application which gets a varying set of Values (Based on user Input), which is then sent to an .xlsx spreadsheet (Set into certain cells) and then using these values, various formulas in the Excel document perform calculations and these generate new values, which we return back to the Application and display it out to the user.
Now this document is not saved. The values are set, and then the result set is retrieved all in one go (Which worked without issue, up until the point of around 19th April, 2018) without saving the document. (We cannot save the document either, as multiple processes are accessing it, and we get "Document in Use" error after saving)
What issue we are now finding, is that as soon as the Excel Document is Opened, and formulas are updated (Or even if nothing is updated) and the document is saved, the above no longer works. We cannot set values, and retrieve a result set anymore.
The application is written in C#, with a large majority of JavaScript, however the actual access to and from the Excel Document is done in C# with use of ClosedXML.
If someone is able to shed some light on to why we are getting this issue now, it'd be most appreciated. As of now, we have reverted to an older version of the Excel Document, which has outdated formulas, and we need a way to be able to edit this Document, while being able to still perform the original functionality that we used to have.
