Cells are not getting inserted dynamically after column IV (256) though the Excel has 16384 as column limit.
Cell Names till IV (256) are generated properly but after that, the cell names are set in cyclic mode (i.e. from the start of that particular row).
Due to this, NamedRange expansion for a particular cell range.is improper
I am trying to expand particular cell range (say Sereis) dynamically from column 247 to 271 (like series1 to series25)
Say StartRow=5, EndRow=5, StartColoumn=247, EndColumn=271 (i.e. From 247+25 = 271)
In the saved xlsx file, the cell insertions has happened smoothly till 256 but after that, the named range for cells have been set from the start of the same row (like in cyclic mode).
Code for Creating Range
area1.EndRow, area1.EndColumn - area1.StartColumn + 1);
Code for saving xlsx
Workbook workbook = new Workbook(xlsx);
Kindly refer the attached Excel where I have described the same scenario.
We have made sure that Excel is saved in xlsx format. Aspose Cells 8.3.1v is used.