in previous versions of Aspose.Cells we were able to properly remove named ranges by just calling Remove() on the NameCollection. I understand that this no longer works due to the introduced sanity checks of formulae referencing named ranges and in this case, the name would not be removed, but only the cell references (ReferTo). So, in order to properly / fully remove referenced named ranges, I tried the following
Identify the range / formulae referencing to be deleted named ranges
Call ClearRange on the named range that holds references to other named ranges
Remove the named range that used to hold the formula incl references to other named ranges
Remove the named ranges that were previously referenced
I guess #1 and #2 work just fine, as I can see in the debugger, but when calling Remove() for the no longer referenced named ranges, all that Aspose.Cells does is clear the ReferTo but not remove the named ranges altogether.