Lock/disable column

7 posts, 0 answers
  1. Omar
    Omar avatar
    3 posts
    Member since:
    Sep 2016

    Posted 29 Sep 2016 Link to this post

    Is it possible to lock/disable first two columns in my below code. Instead of cell lock I want to do column level lock.

    @(Html.Kendo().Spreadsheet()
    .Name("spreadsheet")
    .Sheetsbar(false)
    .Toolbar(x => x.Data(false).Insert(false))
    .HtmlAttributes(new { style = "width:100%;" })
    .Rows(5000)
    .Events(e => e.ExcelImport("niinStockImport"))
    .Sheets(sheets =>
    {
    sheets.Add()
    .Name("NiinStock")
    .DataSource<DynMRO.DTO.Logistics.Planning.NiinStockSearchResultDTO>(ds => ds
    .Ajax()
    .Batch(true)
    .Read(r => r.Action("NiinStockBulkSearchResults", "Logistics").Data("getCriteria"))
    .Update(u => u.Action("NiinStockBulkUpdate", "Logistics").Data("getCriteria"))
    .Events(e => e.Change("onChange"))
    .Model(m =>
    {
    m.Id(p => new { p.NiinStockID, p.ORGID });
    })
    )
    .Columns(columns =>
    {
    columns.Add().Width(100);
    columns.Add().Width(415);
    columns.Add().Width(0);
    columns.Add().Width(0);
    columns.Add().Width(145);
    })

    ;
    })
    )

  2. Eduardo Serra
    Admin
    Eduardo Serra avatar
    119 posts

    Posted 30 Sep 2016 Link to this post

    Hello Omar,

    The feature you describe is not available at the moment of the latest release. I invite you to participate in the Kendo UI Feedback and Feature Request Portal so you can voice your opinion and it might get implemented in future releases; you can find the portal here.

    I hope this helps!

    Regards,
    Eduardo Serra
    Telerik by Progress
     
    Get started with Kendo UI in days. Online training courses help you quickly implement components into your apps.
     
  3. Markos
    Markos avatar
    5 posts
    Member since:
    Jan 2010

    Posted 05 Dec 2017 in reply to Eduardo Serra Link to this post

    Is the Spreadsheet column lock feature available now?
  4. Eduardo Serra
    Admin
    Eduardo Serra avatar
    119 posts

    Posted 06 Dec 2017 Link to this post

    Hello Markos,

    The Feature is not yet included in the Spreadsheet control.

    Thank you for your understanding.

    Regards,
    Eduardo Serra
    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. Maxwell
    Maxwell avatar
    4 posts
    Member since:
    Jun 2018

    Posted 23 Oct 2018 in reply to Eduardo Serra Link to this post

    Any chance this is available yet?
  6. Tsvetomir
    Admin
    Tsvetomir avatar
    649 posts

    Posted 24 Oct 2018 Link to this post

    Hi Maxwell,

    I am pleased to inform you that this feature is already available. In order to set frozen columns, use the frozenColumns property as follows: 

    $("#spreadsheet").kendoSpreadsheet({
                   sheets: [
                   {
                       frozenColumns: 2,
                       name: "Orders"

    If you have additional questions, feel free to contact us.


    Kind regards,
    Tsvetomir
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
  7. Maxwell
    Maxwell avatar
    4 posts
    Member since:
    Jun 2018

    Posted 24 Oct 2018 in reply to Tsvetomir Link to this post

    Thank you.
Back to Top