Can Micro enabled excel file updatable using OpenXMLPowertools?
If we update some specific cell which is referenced in same excel file but in another sheet, does it calculate and update the value in it?
Does it support custom functions as well?
Thanks in advance for you help.
Very sorry for the slow response – have been on vacation, traveling, etc.
You can open a macro enabled XLSM using the Open-Xml-Sdk, but you are limited to directly changing the contents. There is no calculation engine in the Open-Xml-Sdk, so if you change values, it does not change the values in the dependent cells. And custom functions are also not part of the functionality of the Open-Xml-Sdk and Open-Xml-PowerTools.
You must be logged in to reply to this topic.