How to customise row and column header in kendo spreadsheet Is there any Cell template is available for kendo spreadsheet

[chandan]

How to customise row and column header in kendo spreadsheet 
Is there any Cell/Row template is available for kendo spreadsheet

Support for Item edit template

Support for different edit controls for different types of columns/rows

[Nencho]

Hello chandan,

Regarding your first question - you can use the SpreadsheetRange object, in order to acquire a reference to the Tittle cells and define the needed background color, font etc. More information could be found below:

1. Range object: http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range#kendospreadsheetrange
2. Change background: http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range#methods

As for the cell/row template - I am afraid that the Spreadsheet does not provide such a feature. However, you can again use the range object to predefine certain layout, emptymessage or validation for a given set of cells (or rows) using methods such as validation:

http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range#methods-validation

As for your last question - please refer to this demo, illustrating this functionality:

http://demos.telerik.com/kendo-ui/spreadsheet/custom-editors

Hope this information helps.

Regards,
Nencho
Telerik by Progress

[chandan]

Hi Nencho

I want to change the name of the colmun header for A B.. etc to some custum name(DataBase Column Name etc).

As per our requirement we want to add image or comment to the cell.[Same way in xls you can add comment to any cell].

And one more question regarding to column repositioning[Drag and Drod]. Is this possible with spreadsheet.

Thanks in Advance

[Nencho]

Hello chandan,

I am afraid that the Spreadsheet does not allow changing the Column headers in the requested approach. You can however, use the row after the A, B, C... in order to set custom Header, as in the following dojo:

http://dojo.telerik.com/aSOLO/3

I am afraid, however, that the second and third requests are not supported with the Spreadsheet. You can use the portal, in order to submit a feature request though:

http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/category/170283-spreadsheet

Please let me know, should you have any further questions.

Regards,
Nencho
Telerik by Progress

[ullas]

Hi ,

I am working in kendo ui spreadsheet. I have some challenges to add new row to it.

datasource.insertRow(1). this is working

the same i want to insertRow with values

Please anybosy having idea please share

[Nencho]

Hello,

I am afraid that there the spreadsheet does not contain a single method, responsible for dynamic row add with cell values at the same time. This is why, you can add the new row, using the insertRow method and set the values for the range, corresponding to the new row:


http://dojo.telerik.com/@nenchef/EVuNeQ/4

See the documentation for Client API of the Spreadsheet:

http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range


Regards,
Nencho
Telerik by Progress

[ullas]

@nencho, the example was perfect. it works