Disable Auto-Fill ?

3 posts, 1 answers
  1. Greg
    Greg avatar
    8 posts
    Member since:
    Apr 2018

    Posted 11 May 2018 Link to this post

    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

  2.
  3. Answer
    Neli
    Admin
    Neli avatar
    428 posts

    Posted 15 May 2018 Link to this post

    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
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  5. Greg
    Greg avatar
    8 posts
    Member since:
    Apr 2018

    Posted 17 May 2018 in reply to Neli Link to this post

    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

Back to Top