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

4 posts, 0 answers
  1. chandan
    chandan avatar
    5 posts
    Member since:
    Sep 2016

    Posted 04 Oct Link to this post

    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

  2. Nencho
    Admin
    Nencho avatar
    1458 posts

    Posted 06 Oct Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET MVC is VS 2017 Ready
  4. chandan
    chandan avatar
    5 posts
    Member since:
    Sep 2016

    Posted 06 Oct Link to this post

    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

  5. Nencho
    Admin
    Nencho avatar
    1458 posts

    Posted 10 Oct Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top
UI for ASP.NET MVC is VS 2017 Ready