While you can set the enabled state of the sheet, you can still perform the selection, columns/rows merge and resizes.

Hi,

Would like to suggest 2 features for the spreadsheet which will be very useful

 

1) Ability to delete specific cell (not just the content, but the cell itself). Currently there is way to delete row or columns, but no cell deletion.  When cell is deleted, user should be prompted whether to allow all cells below the deleted cell to shift up, or all cells on the right of it to shift left. Akin to excel

 

2) Format painter. The ability to "paint" the styles (such as font size, boldness) from existing text to another existing text. Akin to excel.

Hello there,

I am developing a Web application using  Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.

For example:

I have the following numbers on a Excel sheet:

1

0.5

0.333333333

0.25

0.2

0.166667

0.142857

0.125

0.111111

0.1

0.090909

0.083333

0.076923

0.071429

0.066667

0.0625

0.058824

0.055556

0.052632

Then, I copy them to the Kendo spreadsheet and I got the following:

100.00%

50.00%

33.33%

25.00%

20.00%

16.67%

14.29%

12.50%

11.11%

10.00%

9.09%

8.33%

7.69%

7.14%

6.67%

6.25%

5.88%

5.56%

5.26%

But when I copy them back to Excel I got this:

1

0.5

0.3333

0.25

0.2

0.1667

0.1429

0.125

0.1111

0.1

0.0909

0.0833

0.0769

0.0714

0.0667

0.0625

0.0588

0.0556

0.0526

Losing many decimals affecting the results of my computation and calculation.

Can you tell me why is this happening?

Thank you some much.

 

 

 

Set default Cell Types like Date(Time)Picker, Checkbox, 
SimpleCombo, Autocomplete or own Custom Editor (see other Feedback suggestion)

The Spreadsheet widget is a good start, here are some additional ideas:

1) Ability to assign specific data columns to a spreadsheet column in DataSource data binding and format them.
	2) Control tools that can be visible in the toolbar as well as add custom toolbar items/tabs
	3) Enabled/Disable or Show/Hide tabs in tool bar. Alternatively, be able to add custom tabs and toolbar items as well.
	4) Events! need more events. Cell selected, Range selected, column selected, etc...
	5) Disable/Enable certain commands (such as Cut, Copy, Paste, Delete) based on #4 or other criteria. Useful if I do not want specific cell or column data copied or deleted.

Hide or disable Icons, Panes / Functions in the Toolbar