Usig xlsio features (user controls & shapes) in Spreadsheet Control

Question

Good day,In further exploring the spreadsheet control I was wondering if it may be possible to add in autoshapes (circles, rectangles, etc) as well as user controls, particularly comboboxes to create custom filters, as you can with typical xlsio applications using Excel.The documentation makes no mention of adding these things in as it does richtextboxes and images, but I wanted to make sure that was accurate before moving on. If these things are not supported, I recommend considering them for the future.Thanks.

Kanimozhi Bharathi · Answer

Hi Travis Chambers,   
   
Currently we don’t have support to add the auto shapes at runtime in Spreadsheet. As this support is not available in our product, we will consider this as feature request. Hence could you please confirm us whether the following shapes matches your requirement to consider for feature request,   
   

Line
Rectangle
Oval
Circle
Triangle
   
Also, to insert ComboBox in Spreadsheet,  please find the KB link for your reference,   
   
https://www.syncfusion.com/kb/7011/how-to-load-combobox-inside-a-cell-in-spreadsheet   
   
Regards   
Kanimozhi B

Travis Chambers · Answer

Thank you very much. Yes, those shapes are perfect, but I would add in an ellipse (rectangle with rounded edges) as well. I think those shapes will cover all the bases.

The combobox works great, however, I would like to add an array dynamically. I have tried to convert a range to an array as well as combobox items to an array and I keep getting an error message: "Too many strings in the array or strings are too long." How can I dynamically add items to the embedded combobox. Basically I need to add all unique items from a column into the combobox.

Thanks!

Thirumurugan Loganathan · Answer

Hi Travis, 
  
 
Please find the below details for the asked queries, 
 





S.No 

Query 

Comments 


1 

Support to add auto shapes at runtime in the spreadsheet.  

We have logged this as a feature request in our database. The feature implementation would also greatly depend on the factors such as product design, code compatibility and complexity. We will update you when this feature has been implemented. 
 
Disclaimer: The date for the feature implementation is tentative and not a commitment on our parts.   


2 

“Too many strings in the array or strings are too long” Exception occurred when dynamically add the items in the ComboBox. 

This issue can be resolved by assigning the list of values to the unused ranges in Spreadsheet and refer that range as validation range. Please refer the below KB document for further reference. 
 
https://www.syncfusion.com/kb/7081/how-to-avoid-exception-while-setting-more-number-of-characters-in-list-validation   
 
Regards, 
Thirumurugan

S.No	Query	Comments
1	Support to add auto shapes at runtime in the spreadsheet.	We have logged this as a feature request in our database. The feature implementation would also greatly depend on the factors such as product design, code compatibility and complexity. We will update you when this feature has been implemented. Disclaimer: The date for the feature implementation is tentative and not a commitment on our parts.
2	“Too many strings in the array or strings are too long” Exception occurred when dynamically add the items in the ComboBox.	This issue can be resolved by assigning the list of values to the unused ranges in Spreadsheet and refer that range as validation range. Please refer the below KB document for further reference. https://www.syncfusion.com/kb/7081/how-to-avoid-exception-while-setting-more-number-of-characters-in-list-validation