When trying to import an Excel document into the Kendo UI Spreadsheet with a missing/corrupt image reference, the file will not show.
The Kendo UI Spreadsheet fails to load the document.
The Kendo UI Spreadsheet should handle the error and load the Spreadsheet data without the image.
As demonstrated here: https://dojo.telerik.com/oFiJOciY
I have the spreadsheet's first row and first column frozen.
I have also made the editor background red, so it is easier to visualize.
Double click any cell below the frozen parts to enter editor mode, and you will see the editor drift out of its desired rectangle by 2 pixels,
This is likely caused by the 2px border applied on the k-spreadsheet-pane
When the formula PRODUCT is used and the content of the cell based on which the formula is calculated is deleted, the result is incorrect.
The result in B1 is 1, while it should be 0
When the content of the cell used for calculation is deleted, the product formula should result to 0 (as it is in Excel).
When the Spreadsheet height is greater than the page height and the user scrolls and than enters a value in a cell, the Spreadsheet scrolls to the top.
The Spreadsheet is scrolled to the top. screencast - https://go.screenpal.com/watch/cZj220V9U6j
The Spreadsheet should persist the position.
When attempting to validate a cell value against a predefined finite list, the validation process fails to recognize valid entries that are present in the list. Instead, it incorrectly flags them as invalid. The issue occur when there is an empty space before the first value in the 'from' option.
On the first row, the 'YES' in the B1 cell is marked as invalid although it is present in the list with the valid values. the difference between row 1 and row 4 is the empty space in the validation from configuration:
"from": "{ \"YES\", \"NO\"}", //row 1
"from": "{\"YES\", \"NO\"}" //row 4
The empty space added in the from
configuration option should not affect the validation. If the cell value is present in the list, it should be marked as valid.
Bug report
Some date formats are lost when pasting from Excel and parsed as strings
Reproduction of the problem
Excel provided in Ticket ID: 1658266
copy and paste that into any Kendo Spreadsheet component.
Expected/desired behavior
Dates shall be parsed to dates
Environment
Kendo UI version: [all]
Browser: [all]
When the sheets.filter property of the Spreadsheet is configured and there is a hyperlink in a cell, the hyperlink is not clickable and cannot be accessed.
Regression introduced with 2022.1.119
The hyperlink cannot be clicked.
The hyperlink should be clickable.
Workaround
As a workaround, you can add the following style:
.k-spreadsheet-data{
z-index: 100;
}
1. The top tab section (with the Home, Insert, Data, Undo, Redo) button of the toolbar should be configurable to be hidden, i.e. "single toolbar" configuration should be supported. Since it is possible to configure the toolbar to show custom items, it should also be possible to hide other tabs and the undo/redo button and only have a single toolbar as the configuration.
/* Style hack to hide the "Home/Insert/Data" tabstrip at the top of the spreadsheet. */
.k-spreadsheet-tabstrip.k-tabstrip {
& > ul {
display: none;
}
& .k-content {
border-top: 0px;
}
}
/**
* Style hack to hide the undo/redo buttons in the quick-access toolbar.
*/
.k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
display: none;
}
Set an indicator same way that grid already does but now in sheet cells when a record is 'dirty'.
Bug report
SpreadSheet does not apply borderBottom correctly for last row
Reproduction of the problem
Dojo - https://dojo.telerik.com/UGABAnoR
Current behavior
Border is applied at the first row for the next column
Expected/desired behavior
The border shall be applied at the bottom at A2000
Environment
Kendo UI version: [all]
Browser: [all ]
When values are pasted in the Spreadsheet if the cell is not empty the previous format is taken into account
The number column is formatted as date - screencast(https://somup.com/cZeoodChyH)
The current format should be applied to the pasted data.
Hi
Is it possible to only move between "open cells for input. " With fx. using tab or enter.
When you are input finance data. It would be nice, that with a tab, it only moves between open cell. Is this possible.
On all browser, but mainly edge, chrome ,
reg. jakob
Bug report
Round Function from empty cell shows #VALUE! but in Excel, this shows 0
Reproduction of the problem
Open Dojo: https://dojo.telerik.com/aBOMoCOF
Paste in cell B1 the following formula: =ROUND(A1, 2)
The shown result is #VALUE!
In Excel the same formula returns 0
Expected/desired behavior
The shown value must be 0
Environment
Kendo UI version: [all]
Browser: [all ]
Currently, there is a KB that demonstrates how only values can be pasted into the Spreadsheet. However, to achieve pasting values the cells are modified programmatically, which leads to an improper undoRedo stack. In the knowledge base article if the user presses 'Undo' then a single cell will be undone.
We can add the editing of the cell using commands as demonstrated below, but this will require the user to undo the changes cell by cell and not the entire range at once:
spread._workbook.execute({ command: "EditCommand", options: { value: value, operatingRange: range, editRange: range}});
I think that it will be a good improvement if the Spreadsheet can be configured or if it provides a method that will allow paste-only values that will be properly added to the undoRedo stack and without additional customizations.
Regards
Structured references in MS Excel:
Example formulas that should work (Table1 is a named reference of a table):
1. =Table1[Column2] is not working in kendo
2. =Table1[#Header] -- Header, Data, All and all other specifiers.
3. =[@ColX] also not working .
In a Spreadsheet with date cell editor, the fr-CA culture does not work.
The Calendar is empty
The Calendar should display the dates defined in the validation