An exception is thrown from Aspose.Cells whenever a range is created that falls across the 256 column boundary (excel 2003).
The exception thrown is ‘Invalid end column index.’, the excel file used is using correct format ‘xslx’ (office 2007) and therefore should work as the max column is way more than 256 (16,000+).
The attached image shows a range being created correctly via the ‘CreateRange’, notice RefersTo.
The range is created correctly, but when calling via the GetNamedRanges its not returned.
To Test the situation just create a range that cross the 256 boundary.
Hi,
We do not support the column index which is greater than 255 in formula and named range now.
We will look into it.
Thanks for your patience.