Currently, when trying to load a corrupt XLSX file, the Spreadsheet will freeze and no message will be returned to the user. Improve the widget to unfreeze the view and notify the user about the problem.

Add option for manual calculation of formulas, as available in Excel.

It would be a great feature to have to save time for inputting values without updating other dependent cells and once data entry is done user could press "Calculate Now" and all of the cells updated in one go, same as we do have this feature in MS Excel 365.

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

It would be great if you would add accessabbility to the spreadsheet as it seems to be the last control without this feature.

Currently the focus gets trapped inside its grid and the user cannot leave the spreadsheet with the TAB key. At least this should be avoided. It would be also better if only the first cell would be focusable and you then could navigate with the arrow keys, as with thousands of cells it is not very comfortable to use the TAB key.

Excel supports deselecting cells from selected ranges, e.g. selecting a range from cell A1 to A10 results in a range A1:A10. Then deselecting cell A5 from that range produces two new ranges - A1:A4 and A6:A10.

Now a more complex example - selecting multiple ranges with intersecting cells - A1:B10, A5:D10, A9:C14 and A9:G9.


Deselecting cell B9 in Excel produces a new range with cell A9 only and then a range C9:G9. And B9 should be excluded from the other 3 ranges.

Currently the Spreadsheet widget does not know how to do this. There is no logic to decide what new ranges should be created on such operation. What it currently knows is creating new ranges and these ranges may overlap. Thus clicking on cell B9 creates a new range with cell B9, instead of deselecting B9 from the already selected ranges.

### Bug report
The Ctrl + Shift + Arrow key keyboard shortcut should select a range in the row/column starting with the active cell and ending with the first cell in the row/column that has a value: [list of shortcuts](https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/end-user/list-of-shortcuts) used by the Spreadsheet. It works similarly in Excel. 


### Current behavior
The selection does not end at the first cell that has a value, it ends with the last cell of the row/column.  

### Expected/desired behavior
The expected behavior should be as described in the documentation: "Extends the selection of cells to the last nonblank cell in the same row or column as the active cell."

### Environment

* **Kendo UI version:** 2018.2.620
* **Browser:** [all ] 

Dear Concerned,

1. Open https://dojo.telerik.com/IjasAbeC/11

2. Check split button is not prefixed with a separator, where as all other buttons comes with prefixed separator

It seems a bug, please provide a fix.

Dear Concerned,

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

2. Copy from F3:F15

3. Paste as value (ctrl+shift+v) in H3

4. See it pasted only non-empty cells

Empty cells values should be pasted as well as Excel does.

 

1. Open https://dojo.telerik.com/IjasAbeC/3

2. Background color and text color buttons are initialized as a group. These buttons are not working if we put them in a group

3. If we keep them separate, outside group, the buttons work as expected.

The spreadsheet widget has no Polish localization.

Feel free to use those: https://github.com/telerik/kendo-ui-core/pull/5310

I am using kendo spreadsheet binding to a datasource... very similar to the demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource

Is there a way to add a two row header while binding to a data source?  For example, my first row would be a merged cell spanning all columns and would contain some text.  I can see how to do two row headers and to merge cells.. but it doesn't work when the spreadsheet is bound to a datasource as it starts the data in row 2.... where I want row 2 to be my actual field name headers.  I don't see any options to fix that.

If there is no way to do that... is there a way to alter my header style?  For example, I want a column header to be

MY FIELD NAME HERE
additional text (smaller font and color)

I know in kendo grid there is headerTemplate... but this doesn't seem to be available in kendo spreadsheet.

Thank you.

 

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:[] },

Bug report

Reported in ticket № 1429260

Reproduction of the problem

1. Create a date in a cell in Excel, e.g. 9/9/2019 with format type as "Date";
2. Shrink the column so that the date is displayed as hash tags ####;
3. Select the cell and copy it
4. Paste it in any Kendo UI Spreadsheet cell

Current behavior

The date is pasted as string with value of hash tags.

Expected/desired behavior

The date is pasted as a date

Notes

The e.ClipboardContent.data contains the hash tag string as value, so the issue should be somewhere in the clipboard pasting logic

Dear Concerned,

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

2. Click Background or Text Color icon , select custom color

3. See the popup UI , there is boarder and margin issues, boarder is visible on top,left & bottom side but not on right side

Currently, the Spreadsheet component doesn't have the functionality to create a formula using the keyboard arrows.

For example:

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

2. Select C12 and type =SUM( to set formula 

3. Use the arrow keys to select the starting cell. This functionality is not available.

Please provide the described above functionality.

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

Currently the API does not provide a way to detect when filtering occurs. It would be great if you could add a filter event.

The filtering on the spreadsheet component is great!!

There is however one behaviour that causes confusion for end users, and that is filtering when merged cells  are present in the selection.  
An example is available in the following dojo:
https://dojo.telerik.com/UzUMUDos

Open the dojo and filter column A on a1 and you will only see only b1 in column B, but the b1a will not be shown.

To be clear - This is also how Excel behaves...  (which is of course your prime aim so its not a bug as such)... 
Interestingly google sheets stops you putting filter on merged cells / stops you merging on filtered column.

The Excel behavior is discussed in the following threads:
https://stackoverflow.com/questions/49816515/excel-filtering-for-merged-cells
https://www.officetooltips.com/excel_2013/tips/workaround_for_sorting_and_filtering_of_merged_cells.html

Is it possible to implement something, so the end user experience would be improved? Maybe when merged cells are present :
a) if they click filter, this is detect and user is warned of this behaviour
b) if they click filter, the sheet is changed into an unmerged version (which repeats data in merged cells) as in the excel examples above.

 

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:

Bug report

Reproduction of the problem

Reproducible in the demos.

1. Use the HYPERLINK function in a cell:

=HYPERLINK("https://google.com")

Current behavior

The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")

Expected/desired behavior

The link works with and without a "friendly name" specified, as in Excel.

Environment

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