Problem with named range

Aspose.Cells Product Family
1

Hi,

Can any one tell me how many Named range we can declare in workbook.

and is there any limit for length of named range characters.

I defined the range for Data validation to show as Drop down list.

I am getting following error when i am opening excel file.

"Excel found unreadable content in filename.xlsx"

Please any one can suggest any solution for this.

Thanks in advance

2

Hi,


Well, Aspose.Cells follows MS Excel standards and works the same way as MS Excel. I think apparently there is no limit to create the number of named ranges, you may have as many as you want but it would depend on your available memory.

For your issue, could you create a sample console application (runnable) with v7.5.0.x, zip it and post it here, we will check your issue soon. Also attach your template Excel file(s).

Thank you.