Creating Named ranges in the Worksheets.Names collection.
If you set
xName.RefersTo = refersTo
refersTo should support both
- =sheetname!C10
- =sheetname!C[10]
In XMLXLS format, they should render as follows:
But, currently, if you assign
newName.refersTo = "=ToSpitfire!C10"
aspose.cells stores:
<ss:NamedRange ss:Name="zRawItems_DocItem_Description" ss:RefersTo="=<FONT>ToSpitfire!R[9]C[2]" />
The distinction is important because in the case of =FromSpitfire!C10, if you click on the column
the range name appears in the current range box. And if you cut and paste the range moves too! Which is critical for my application...
In the case of =ToSpitfire!C[10], cutting and pasting leaves the name "behing".
It would be terrific if you could correctly handle the version w/o the []!