This is a migrated thread and some comments may be shown as answers.

How to delete cells from the radspreadsheet

1 Answer 152 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Saifulla
Top achievements
Rank 1
Saifulla asked on 04 Oct 2018, 08:15 AM
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.

1 Answer, 1 is accepted

Sort by
0
Vessy
Telerik team
answered on 05 Oct 2018, 03:17 PM
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.
Tags
Spreadsheet
Asked by
Saifulla
Top achievements
Rank 1
Answers by
Vessy
Telerik team
Share this question
or