We are working on worksheet range names with the help of Aspose.Cells. We have experienced an issue while doing this. While assigning a numerous range name to the cells in the worksheet, the range names are not assigned after certain cells, the behavior of not assigning range name is consistent and it can be seen after the cell (Column : IV). We are stuck in our development , need urgent help from you.
We have attached a POC in this thread.
In the worksheet assignation of range names are working fine till cell name (Column: IV). After this cell range names are not getting assigned to the cells. Below is the screenshot:
Screenshot of Cell (Column:IV Row:0) please refer Screenshot1 in attachments. Range name is assigned properly.
Screenshot of Cell (Column: IW Row: 0) please refer Screenshot2 in attachments. Range Name is not assigned to above highlighted cell and onward.
For more details we are attaching the excel workbook in this thread.