RadSpreadsheet questions

1 Answer 59 Views
Spreadsheet
Efrat
Top achievements
Rank 1
Efrat asked on 11 Jan 2023, 01:14 PM | edited on 11 Jan 2023, 01:17 PM

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

 

1 Answer, 1 is accepted

Sort by
1
Accepted
Rumen
Telerik team
answered on 13 Jan 2023, 09:25 AM

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

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/.

Tags
Spreadsheet
Asked by
Efrat
Top achievements
Rank 1
Answers by
Rumen
Telerik team
Share this question
or