Possible bug when loading XLL in "WorkbookActivate" or "WorkbookOpen" event and clearing content from a range

Hi people!

I have a bug where if I'm loading a XLL file with UDF functionality in the "WorkbookActivate" or "WorkbookOpen" event and then I try to select a range and clear it, the formula it's invoked for no reason. After either of these events ends, if I try to select the same range and delete it... the formula is not invoked (that's correct).

This is the test code about this (ClearContent is raising the formula and that's wrong):


The parameters are constant and no relation with the cleared cells:

=PHDataColumn("TestTA","TestTicker","TestColumn")


And when the bug occurs, inside the UDF method, the method "Find" from Interop does not works and always throws this COMException: Exception from HRESULT: 0x800A03EC

Any idea how to solve it? If I load the XLL file at statup, I have another issue related to Intellisense, so it's no option.

SO: Windows 10
Office: 2016
ExcelDna.AddIn: 1.0.0
ExcelDna.Integration: 1.0.0
ExcelDna.Intellisense: 1.1.0

Thanks, regards!