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

7 posts, 0 answers
  1. chandan
    chandan avatar
    9 posts
    Member since:
    Sep 2016

    Posted 04 Oct 2016 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
    1608 posts

    Posted 06 Oct 2016 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. chandan
    chandan avatar
    9 posts
    Member since:
    Sep 2016

    Posted 06 Oct 2016 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

  4. Nencho
    Admin
    Nencho avatar
    1608 posts

    Posted 10 Oct 2016 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
  5. ullas
    ullas avatar
    2 posts
    Member since:
    Feb 2017

    Posted 22 Mar Link to this post

    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

  6. Nencho
    Admin
    Nencho avatar
    1608 posts

    Posted 24 Mar Link to this post

    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
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  7. ullas
    ullas avatar
    2 posts
    Member since:
    Feb 2017

    Posted 24 Mar in reply to Nencho Link to this post

    @nencho, the example was perfect. it works

     

Back to Top