Placing the values in a separate sheet is a great solution! Thank you for the recommendation. It's working very well now including support for validation after exporting to Excel.
Posted on:09 Mar 2022 15:03
Thank you for sharing the reason behind the issue you have encountered.
As an alternative, the values can be added in a separate sheet and the validation to point to a range instead of a hardcoded string.
Virtual Classroom, the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products quickly just got a fresh new look + new and improved content including a brand new Blazor course! Check it out at https://learn.telerik.com/.
Posted on:09 Feb 2022 20:18
My apologies for the second post. The solution I listed below does not work. The actual problem is that Excel has a 256-character limit on data validation lists that are entered as a string (as opposed to validations sourced from elsewhere in a spreadsheet). Source
If the From string exceeds 256 characters, an error message will appear on export.
Posted on:09 Feb 2022 16:48
Hello, I found the cause of my problem and will post it here if it helps others.
I have a RadSpreadsheet that uses a custom database provider. The spreadsheet has many columns that use a custom editor to provide a drop-down list of selections. The drop-down list is generated from a generic list (from a database). In the below sample code, _fundCodes is a List<FundCode>.
When I create the column like this, I will see validation error messages when exporting to Excel:
Please verify the Validation is properly formatted depending on the coding language you use. The shared online demo is updated and the validation is working properly.
If you still have issues, please open a support ticket where you share your spreadsheet configuration and code files and we can review them and provide more specific suggestions to overcome the problem.
Progress is here for your business, like always. Read more about the measures we are taking to ensure business continuity and help fight the COVID-19 pandemic. Our thoughts here at Progress are with those affected by the outbreak.