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 ]
Bug report
Reproduction of the problem
- Run the attached page in the browser.
- Take a 20 sec long heap snapshot. During these 20 sec click the "change" button to make changes to a specific node's data in the observable.
Current behavior
There are multiple detached span elements: screenshot
Memory consumption increases with every change: screenshot
Expected/desired behavior
Environment
- Kendo UI version: 2019.2.619
- jQuery version: x.y
- Browser: [all ]
The issue is reproducible when the grid consists only from Multi-header columns, the setDataSource() method has been used and one of the columns is initially hidden.
After setting the new data source, the last header gets hidden. The "display: none;" style has been applied to the "th" HTML element.
Steps to reproduce:
1. Create a grid with multi-header columns only.
2. Hide one column initially.
3. Set a new data source via the setDataSource() method.
4. The last column gets hidden.
Sample Dojo:
https://dojo.telerik.com/AcipENOt
Kendo UI version: 2019.1.220
Bug report
An error occurs on components' initialization when using a custom Kendo UI build which includes PDFviewer
Reproduction of the problem
- Go to Kendo UI Custom Download page
- In the "WEB" section select random components including the Grid and PDFviewer
- Download the custom build(kendo.custom.min.js file) and put it in the same folder with an HTML file with the following structure.
<!DOCTYPE html>
<html>
<head>
<style>
html {
font-size: 14px;
font-family: Arial, Helvetica, sans-serif;
}
</style>
<title></title>
<link rel="stylesheet" href="https://kendo.cdn.telerik.com/2019.2.514/styles/kendo.default-v2.min.css" />
<script src="https://kendo.cdn.telerik.com/2019.2.514/js/jquery.min.js"></script>
<script src="./kendo.custom.min.js"></script>
</head>
<body>
<div id="example">
<div id="grid"></div>
<script>
$(document).ready(function () {
$("#grid").kendoGrid({
dataSource: {
type: "odata",
transport: {
read: "https://demos.telerik.com/kendo-ui/service/Northwind.svc/Customers"
},
pageSize: 20
},
height: 550,
groupable: true,
sortable: true,
pageable: {
refresh: true,
pageSizes: true,
buttonCount: 5
},
columns: [{
template: "<div class='customer-name'>#: ContactName #</div>",
field: "ContactName",
title: "Contact Name",
width: 240
}, {
field: "ContactTitle",
title: "Contact Title"
}, {
field: "CompanyName",
title: "Company Name"
}, {
field: "Country",
width: 150
}]
});
});
</script>
</div>
</body>
</html>- The following error appears:
Uncaught TypeError: Cannot read property 'Toolbar' of undefined
Current behavior
Expected/desired behavior
A Grid should be initialized properly and without errors if a custom build is including the PDFviewer
Environment
- Kendo UI version: 2019.2.514
- jQuery version: x.y
- Browser: [all]
Bug report
When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.
Reproduction of the problem
- Go to Spreadsheet Basic usage demo
- Add a new sheet
- Type
ab113abababab11abin A1 - Enter the following formula in B1
=SUBSTITUTE(A1, "ab", "")
NOTE: substituting ab with another string, e.g. cd, replaces all instances of ab as expected.
Current behavior
113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string
Expected/desired behavior
11311
Environment
- Kendo UI version: 2019.2.514
- Browser: all
Bug report
Client-side exported Excel workbooks are exported "uncompressed" (as readable text) and their size is much greater than the original document.
Regression since R2 2019 - 2019.2.514
Reproduction of the problem
- Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
- Open the following file in Spreadsheet -
Workbook Original.xlsx - 26 KB - Export the file to Excel
Current behavior
The exported file is 1015 KB in size. The content of the file may be read as plain text
Expected/desired behavior
The exported file is 26 KB or similar size. The content of the file is unreadable binary data
Environment
- Kendo UI version: 2019.2.619
- Browser: all
When a ContextMenu is opened for the first time, the animation is not executed. Every consequent open trigger the animation successfully.
The issue can be observed in the following Dojo.
Steps to reproduce:
- Open the ContextMenu and notice there is no animation.
- Open the ContextMenu again and notice the default animation is triggered.
Bug report
When a cell/row is selected, its first cell is focused and the sheet is scrolled to show it. If a long sheet is scrolled down/right to edit cells, this scroll top/left is very annoying and user unfriendly.
In these scenarios Excel focuses the topmost/leftmost currently visible cell, avoiding sheet scrolling.
Reproduction of the problem
- Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
- Scroll to the bottom row of Spreadsheet's sheet.
- Click in cell B200 to select it.
- Click on the header of column C to select the whole column.
NOTE: for rows reproduction select cell AX2, then click on the header of row 2 - sheet is scrolled to the left and cell A2 is focused.
Current behavior
Column C is selected, cell C1 is focused and the sheet is scrolled to top.
The used has to scroll down to the bottom row again to edit data at the bottom of the sheet.
Expected/desired behavior
Column C is selected. The currently visible topmost cell of column C is focused, without scrolling the sheet. Excel works that way
Environment
- Kendo UI version: 2019.2.619
- Browser: all
Bug report
The current client-side export functionality does not preserve the number of columns.
Reproduction of the problem
Load the following file in the Spreadsheet which contains columns up to "BA".
Export the file
Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".
Current behavior
Client-side export does not preserve the number of columns greater than "AX".
Expected/desired behavior
Client-side export does not preserve the exact number of columns.
Environment
- Kendo UI version: 2019.2.619
- Browser: [all]
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
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.
Bug report
Spreadsheet SUMIF function returns #NA when Excel returns the correct result. The issue is observed when the criteria range and sum range have different sizes.
Reproduction of the problem
Run the Spreadsheet demo page
Open the attached file
Formula in cell B3 returns #NA!
Current behavior
The formula in cell B3 returns #NA!
Expected/desired behavior
The formula in cell B3 should return the correct value
Environment
Kendo UI version: 2019.3.1023
Browser: [all]
Bug report
When you click and hold on the Button, and then drag outside, the Button remains highlighted.
This is a regression in version 2019.1.115.
Reproduction of the problem
Open this Dojo example. Click and hold the Button, and then drag to the right.
Current behavior
The Button remains highlighted, and the k-state-active class is not removed.
Expected/desired behavior
The Button should not be highlighted if the mouse cursor is not on the button on mouseup.
Workaround in this Dojo.
Environment
- Kendo UI version: 2019.1.115
- Browser: [all]
Dear Concerned,
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import attached Book21.xlsx file
3. I have first row as frozen pane and columns C, D are hidden
4. Select columns B to E using mouse drag & then right click on selected column , it does not show Unhide option, because on right click it keeps the selection only on column E
It does not work if we keep Freeze Panes.
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.
Hi,
We are using the Kendo Multi Select widget, and it was just reported that you can't remove a tag from the list when clicking on the Close (X) icon when using Safari on iPadOS 13.1.3. I was also able to reproduce this on the multiselect demo here - https://demos.telerik.com/kendo-ui/multiselect/index. We are currently on version 2019.2.619, however I also tried it on the latest with the demo and it also didn't seem to work.
Is this a known defect?
Thanks,
Emily
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)
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
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
When exporting a diagram as a PDF, hidden shapes still visible.
Reproduction of the problem
1. Run this dojo - https://dojo.telerik.com/oRUPUHOb/4
2. Click on "Mask" button
3. Click on "Save as PDF"
4. Open the exported PDF file
The shape State 1 must not be present on the exported PDF
Actual behavior:
User uses down key or mouse scroll to change the time. A 00:00 hour is set instead of chosen hour on blur.
Expected behavior:
A value chosen by user remains selected. It's not changed by the timepicker.
Additional Context:
This problem occurs only when picker.enable(true) is called after component creation and user uses down arrow / mouse scroll to get to the the 'previous' day. When no .enable method is called everything works fine. Please see attached code snippets and gifs.
Dojo link: https://dojo.telerik.com/OZEDuFEg
Bug can be reproduced using the following code snippet:
$(document).ready(function () {
// create TimePicker from input HTML element
var picker = $("#timepicker").kendoTimePicker({
dateInput: true,
format: 'HH:mm'
}).data('kendoTimePicker');
picker.enable(true)
});Removing
picker.enable(true)
fixes the issue