i am creating dynamic drop-down list for exporting excel file by using Aspose.cell , the drop-down list having 70 items (total characters of 70's item is more than 256 characters).
the issue is a limitation of the validation drop down with a string list. Unable to proceed further due to this issue. what is the maximum character limit for delimited list in Excel, is it 256?
Is there any alternative solution for this issue ?
Hi,
Well, MS Excel (2003 - 2007/2010) itself does not allow entering validation string(s) more than 255 characters ( List data validation in Excel with a sequence of comma-separated values). MS Excel can allow only maximum of 255 characters for a list value for the data validation, you may confirm it in MS Excel. We follow MS Excel standards and specifications.
For you needs, you may use formula (based on cells’ range of data) for the list value instead.
Thank you.
Hi,
You are welcome. Feel free to contact us any time if you need further help or have some other queries or issue, we will be happy to assist you soon.
Thank you.