Disable Auto-Fill ?

[Greg]

Is there a way to disable auto-fill on the spreadsheet?  We don't want our clients to accidentally activate it and over-write data they've already entered in the spreadsheet.

Thanks.

Greg

[Neli]

Hi Greg,

A possible approach is to prevent the AutoFillCommand from being triggered.

kendo.spreadsheet.Workbook.fn._sheetCommandRequest = function (e) {
           if (e.command === "AutoFillCommand") {
               return;
           }
             this.trigger("commandRequest", e);
       }

Another possibility is to customize the kendo.spreadsheet.AutoFillCommand and clear its implementation.

On the linked Dojo example the first approach is implemented.
I hope this helps.

Regards,
Neli
Progress Telerik

[Greg]

Neli,

Thank you for the direction on how to override the method.  It worked as you described.

One thing, you should mention that you have to override the method BEFORE the spreadsheet is instantiated for it to take effect.

Thanks again.

Greg