6 Answers, 1 is accepted
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:
- Range object: http://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/range#kendospreadsheetrange
- 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
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
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
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
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
@nencho, the example was perfect. it works