total row count should display on footer like in excel , row count should change after each filter , also option for to add "action link" to the columns so that we can navigate/popup to other pages..

Bug report

When pasting data from Excel, the data is being pasted as an image instead of values

Reproduction of the problem

1. Open https://dojo.telerik.com/UKAFAkEn
2. Open new Excel file on your system in MS Excel application
3. Enter data 1, 2, 3, 4, 5 in A1 to A5 in sheet1
4. Copy data from A1 to A5 from the local file
5. Paste data in C3 of Spreadsheet opened in step 1
6. The pasted result is an image instead of values

Current behavior

Pasting from Excel results in an image

Expected/desired behavior

Pasting from Excel should result in correctly filled data cells

Environment

• Kendo UI version: 2019.2.514
• jQuery version: x.y
• Browser: [Chrome 74.0.3729.131 | Firefox 66.0.5 | Edge 42.17134.1.0 ]

Bug report

File:
3f0465a2-412c-4876-ba47-4b12ae46f92e_adam.zip

https://demos.telerik.com/kendo-ui/spreadsheet/index

Reproduction of the problem

1. Import the file

Current behavior

Errors are encountered. Even if resolving the errors bold styles are not applied as they are part of the font definition and not of the inlineStyles.

Expected/desired behavior

The excel is imported as expected.

Environment

• Kendo UI version: 2019.2.514
• Browser: all

Bug report

The performance in the latest official version is significantly worse compared to older versions (2017.1.117 and 2018.1.118 tested).

Reproduction of the problem

Dojo example.

1. Click a cell
2. Press Ctrl + A
3. Select a font size from the dropdown in the Spreadsheet's toolbar

Current behavior

The UI freezes and remains unresponsive for minutes.

Expected/desired behavior

The new font size is applied without significant delay.

Environment

• Kendo UI version: 2019.2.514
• jQuery version: x.y
• Browser: [all]

The spreadsheet widget should be able to take an imported .xlsx file, such as a preconstructed template, and update bound database tables if the fields match.

Bug report

When destroying a SpreadSheet and removing its corresponding DOM element, there are some DOM nodes added on SpreadSheet's initialization which are not removed after the execution of .destroy() and .remove().

Reproduction of the problem

1. Open this Dojo and run it.
2. Open browser's console and see the output in it. The initial number of the children nodes in the body is 2 and the children nodes after adding and removing a SpreadSheet are 5.
   
3. Right-click the blank page in right and inspect it. Navigate to the body in the iframe and see the additional nodes in it
   

Current behavior

Not all DOM elements added on SpreadSheet initialization are being removed when destroying it and removing its corresponding DOM element.

Expected/desired behavior

After destroying a SpreadSheet and removing its corresponding DOM element, no DOM nodes added on component's initialization should be presented in the DOM tree.

Environment

• Kendo UI version: 2019.2.514
• jQuery version: x.y
• Browser: [all]

WorksheetPageSetup would be a dialog in the kendo ui spreadsheet and persist when the work book is downloaded as Excel or pdf. 
The setup values would also be used to prepopulate the settings in the download dialog.

WorksheetPageSetup would be maintained when a server-side generated Telerik.Windows.Documents.Spreadsheet.Model.Workbook is converted to a Telerik.Web.Spreadsheet.Workbook by method FromDocument().

Page setup maintains settings for printing: orientation, scaling, margins, paper size, grid lines, column headings etc...

I want to know the combination keys that generate the paste event 

Thx,

The spreadsheet doesn't provide any configuration options for the font size unit; it is always in pixels. I need to be able to specify other CSS units, such as points or ems.

1. Formula selection dragging

2. Formula selection resize

Details: While using cell references in formulas in a cell, user should be able to drag and resize the referenced cell selection.

Refer the video present here for details.
<https://drive.google.com/file/d/0B2aXCYXjjcD9RDZpd0lScEV3UUk/view?usp=sharing>

Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown

We have a client that recently brought to our attention the fact that he found a case where he couldn't place his cursor in a certain spot of a formula, click a cell, and have it fill that cell in. It works if you try to do that for the first cell listed in the formula, but not the rest. I've outlined a sample case below.

You can enter a formula in a cell like =IF(A2+B2, 1, -(A2+B2), 2). Then, highlight a cell, like A2 below, and delete it by hitting backspace or delete.

After hitting delete, leave the cursor in the same location of the formula and click a new cell, like A4.

For this case, since it's the first cell in the formula, it will insert the cell you just clicked on in the correct location. However, next try highlighting the next cell referenced, hitting delete, and clicking on a new cell to have it insert the cell into the formula. In this case, we highlighted and deleted B2, then tried to click on B4.

You'll see that, for this one, instead of inserting B4, it gives an error message. Our client said that it significantly slows him down when he has to manually type in each change to the formula, so is there any way we could have it insert the cell you click on for all cases? It doesn't look like this is a current feature, so would you be able to add it, please? Thank you!

When typing a formula and selecting another cell in Excel we can press F2 to be able to change the formula manually, however when using the spreadsheet when trying to change the formula with the arrow left or right button we select another cell.

When using IE 11 and using Ctrl+X to cut, this only works the first time. All subsequent attempts to use cut produce the following dialog:

Hi

Does the kendo spreadsheet support conditional formatting / data bars (which are the background bar charts on a cell)...

See example below - and attached simple xlsx (in zip)

 

which in excel you add like

 

If not currently supported as standard, any suggested workarounds?

Thanks

 

Chris

Enhancement

Please refer to this Dojo example - https://dojo.telerik.com/IRIRahoS/2.

Current behavior

Currently, if the filter configuration is not explicitly set, the filter button from the toolbar seem inefficient. If you toggle a filter for a column, that filter is applied for that column only. In Excel, the filter will be applied for all columns. Also, you need to manually select all the cells that you wish to filter/sort.

Steps to observe the above:
In the Dojo example, toggle filter for a column only (without manually selecting cells).

You can see that the filter will be applied for that column only. Please compare to Excel.

You will see that there is no content to be filtered/sorted. You need to select manually. Again, please compare to Excel.

Expected/desired behavior

When the filter button is pressed, execute the filter configuration logic, so that it will behave as Excel.
filter: { ref: "A3:G49", columns:[] },

Add ability to add group multiple columns and add a group header for those columns.

Error occurred in browser console after select cell with value, pressing cut scissors button on top and press undo shortcut key combination (Ctrl+Z at windows or Cmd+Z at macos)

Uncaught TypeError: Cannot read property 'row' of undefined
    at init.setState (kendo.all.js:130820)
    at init.setState (kendo.all.js:125407)
    at init.undo (kendo.all.js:125401)
    at init.undo (kendo.all.js:72253)
    at init.onEntryAction (kendo.all.js:138955)
    at init.handleEvent (kendo.all.js:127458)
    at init.keyDown (kendo.all.js:127401)
    at HTMLDivElement.dispatch (jquery-1.12.4.min.js:3)
    at HTMLDivElement.r.handle (jquery-1.12.4.min.js:3)
setState @ kendo.all.js:130820
setState @ kendo.all.js:125407
undo @ kendo.all.js:125401
undo @ kendo.all.js:72253
onEntryAction @ kendo.all.js:138955
handleEvent @ kendo.all.js:127458
keyDown @ kendo.all.js:127401
dispatch @ jquery-1.12.4.min.js:3
r.handle @ jquery-1.12.4.min.js:3

The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.

Hi Kendo Team,

The exported excel file from spreadsheet can not be opened in Microsoft excel when the spreadsheet has both a comment and a image.

You can reproduce the issue at your demo site https://demos.telerik.com/kendo-ui/spreadsheet/index

First add a comment for cell D3, then add a image, then export as xlsx.

Try open the export excel file, and you will see the error popup says "we found a problem with some content in workbook.xlsx ......"

It works when exporting comment and image separately.