How to delete cells from the radspreadsheet

2 posts, 0 answers
  1. Saifulla
    Saifulla avatar
    15 posts
    Member since:
    Sep 2018

    Posted 04 Oct 2018 Link to this post

    I am trying to create a dynamic html table generator using ken-do Rad Spreadsheet. I am creating my custom toolbar that works fine but my question is, how can i remove Formula Bar, Column Header, Row Header and cells. I have attach a image, that is actually i am trying to achieve. can someone suggest me how can i do this am new to telerik.
  2. Vessy
    Admin
    Vessy avatar
    2097 posts

    Posted 05 Oct 2018 Link to this post

    Hi,

    You can hide the formula bar and headers of the rows and columns of the Spreadsheet with the following CSS style. You will also need to set the Speadsheet's headerHeight and headerWidth properties to 0 in order to avoid the top and left of the widget's content:
    div.k-spreadsheet-formula-bar,
    div.k-spreadsheet-row-header,
    div.k-spreadsheet-column-header,
    div.k-spreadsheet-top-corner
    {
        display: none;
    }

    As for the cells - you can change their border in order to match the cell backgrounf in this way:
    html .k-spreadsheet-pane .k-spreadsheet-haxis,
    html .k-spreadsheet-pane .k-spreadsheet-vaxis {
      border-color: #fff;
    }


    A sample demonstrating the above settings is available here:
    http://dojo.telerik.com/ACAGihof/3

    Regards,
    Vessy
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top