Lock/disable column

[Omar]

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);
})

;
})
)

[Eduardo Serra]

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

 

 

[Markos]

Is the Spreadsheet column lock feature available now?

[Eduardo Serra]

Hello Markos,

The Feature is not yet included in the Spreadsheet control.

Thank you for your understanding.

Regards,
Eduardo Serra
Progress Telerik

[Maxwell]

Any chance this is available yet?

[Tsvetomir]

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

[Maxwell]

Thank you.