RadSpreadsheet questions

[Efrat]

hello, I'm using RadSpreadsheet and didn't figure out how to do the following:

1. In SpreadsheetTool Name="InsertCells", Can I change the default tool that appear to be other than "Add Column left"?

2. When dragging down a cell it behaves like "Copy cell" , but if the cell include content that ends with a digit the dragging will cause a "Fill Series" behavior, which means the new cell will have the prev cell value increased by 1, is there a way to control this default behavior and config it to be only "copy cell" with no increments??

Thanks,

Efrat

 

[Rumen]

Hi Efrat,

Straight to the questions:

• The current implementation of the spreadsheet does not offer an API to customize or reorder the dropdown items of the toolstrip buttons. I examined the source code and saw that the InsertCells default option is set on the server side, which prevents me to send you a javascript override to reorder the buttons. 
  
  
• As for the second request: currently, the Spreadsheet widget will always increment the numeric if it is the last member of the cell value. Preventing that behavior is currently not supported by the widget. Nevertheless, I would suggest you to track the following GitHub item, which focuses on AutoFill enhancements in the base Kendo Spreadsheet widget - the server-wrapper of which RadSpreadsheet is: https://github.com/telerik/kendo-ui-core/issues/3265. As a result of your question, we have just raised the priority of the task. That will move it sooner in our implementation queue.

Best Regards,
Rumen
Progress Telerik