Spreadsheet throws error when opening a xlsx file containing diagonal borders.
Spreadsheet crashes and throws an error Uncaught TypeError: Cannot set property 'color' of undefined
The file should open.
The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.
Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.
If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.
Reproducible in the demos. The attached video demonstrates the issue.
Recording49.zip
As shown in the video, the F column completely disappears. The column letter remains visible within the next column (G). F column's resize handle remains hidden, and it cannot be made visible.
There should be a minimum column width that should be respected on resizing. Its value should always allow the column to be resized. No column overlapping should occur.
Related To: #5500
When there are merged cells and the SUM formula is used for the merged cells the result is wrong (it depends on the count of the merged cells)
The result in the D1 cell is 20. ( value of cell * count of cells in merged range)
The result should be 5. In the same scenario, the result in Excel will be 5.
Hello,
I have some problems with setting up correct Cell Validation for my use-case. I want to create a list validation which is going to have a numeric options instead of typical string values.
So in order to achieve that I created a following cell validation:
{
dataType: "list",
showButton: true,
comparerType: "list",
from: '{1,2,3,4,5}',
allowNulls: true,
type: "reject"
}
Everything works fine in the widget, but the problems starts when I want to Export the following spreadsheet to Excel format. I'm getting the following message when trying to open such file:
In the past I had a similar problem with the list validation (but for string values) (https://www.telerik.com/account/support-tickets/view-ticket/1381434)
There you suggested to create a validation using different format for "from" property. So I decided to change it from:
from: '{1,2,3,4,5}',
to
from: '"1,2,3,4,5"',
After that I can freely export the spreadsheet without any problems, but then my list is inserting string values instead of numeric ones, therefore this solution is not suitable for my use-case.
And my question is: Is there a possibility to create a Cell validation where I can put numeric values as a possible options without breaking the export process?
Here's a example spreadsheet, which I used to reproduce this behavior: https://dojo.telerik.com/IfuMIbic
Best regards,
When using a custom cell editor in the Spreadsheet along with keyboard navigation value selection is not limited to the cell with the custom cell editor
The selected value is applied to cell other then the one using the custom cell editor
The selected value should be applied only to the cell with the custom cell editor
The select method of the range in the Spreadsheet component throws an error when we have a selected cell in the visible area of the component and try to select a range that is outside of this visible area.
The bug is replicable both when the range is passed as exact cells or row-column pair:
** This is a regression from the R3 2019 release
The following error appears in the browser's console
If you scroll to the top rows of the Spreadsheet there is a visual selection of the cells that are passed in the range
On "Select range" click the "C4:E6" cell range should be selected and the Spreadsheet should be automatically scrolled to this selection.
Here is a working demo: https://dojo.telerik.com/uRERUxOm
Hi,
I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).
When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.
Editing an empty row above this new row will modify one of the records created in this process.
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.
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 undefinedThe 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.
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.
After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.
The new values are not pasted back to the Kendo UI Spreadsheet.
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:
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().
Not all DOM elements added on SpreadSheet initialization are being removed when destroying it and removing its corresponding DOM element.
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.
The performance in the latest official version is significantly worse compared to older versions (2017.1.117 and 2018.1.118 tested).
Dojo example.
The UI freezes and remains unresponsive for minutes.
The new font size is applied without significant delay.
File:
3f0465a2-412c-4876-ba47-4b12ae46f92e_adam.zip
https://demos.telerik.com/kendo-ui/spreadsheet/index
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.
The excel is imported as expected.
When pasting data from Excel, the data is being pasted as an image instead of values
Pasting from Excel results in an image
Pasting from Excel should result in correctly filled data cells
Modified date value from Excel is not correctly updated when pasting in the Spreadsheet.
Regression introduced with 2023 R1
The updated date cell is not pasted in the Spreadsheet
The updated cell's value should be pasted in the Spreadsheet
Set Fixed Cols/Rows etc. or setOptions( {filter: { ref: "A3:G49", columns:[]}});