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);
})
;
})
)
6 Answers, 1 is accepted
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
The Feature is not yet included in the Spreadsheet control.
Thank you for your understanding.
Regards,
Eduardo Serra
Progress Telerik
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