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.
Bug report
The computed range when pasting data into the spreadsheet is incorrect.
Reproduction of the problem
Dojo: https://dojo.telerik.com/eToXOQOL/9
1. Open a Notepad, and create the following structure:
a
b[tab]c[tab]d
e[tab]f[tab]g
Between each element on rows 2 and 3, there is a [tab] character. This will make sure that the data pasted into Spreadsheet will land on different columns.
2. Copy the entire content of the Notepad document and paste it in cell A1. After the paste operation, you will notice under the Spreadsheet component an output with the range that was passed to the change event.
Problem:
The computed range is A1:A3 while the expected value is A1:C3
Expected behaviour
The expected value is A1:C3
Environment
Kendo UI version: 2021.1.224 or newer
Browser: [all]
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 ]
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
When an Excel File that contains VLOOKUP and calculated columns is imported in Excel, this results to CIRCULAR value for the cells, although ther are no circular formulas in the file.
The values in the Spreadsheet are imported as '#CIRCULAR' although there are no circular formulas.
When the VLOOKUP in cell L2 is deleted the values are imported as '#VALUE'
The values in the Excel file should be imported correctly.
When the scale and layout setting of the machine is different than 100% the keyboard navigation does not work properly. The issue occurs with different scales on each machine. For example, on some machines, it could work with all scales, but on others, it may not work with a scale of 125% or 175%, even if this is the recommended value.
Note, that you may need to test with different scales to manage to replicate the issue.
The navigation does not work. The cell selection does not work or goes to a wrong cell.
The Spreadsheet navigation should work with all screen scales.
Bug report
Dropdownlist editor remains visible on scroll of the Scheduler
Reproduction of the problem
Dojo: https://dojo.telerik.com/iLusiHAm
Open the DropsDownList editor in B2 cell
Scroll down the sceduler
Expected/desired behavior
DropsDownList editor shall close
Environment
Kendo UI version: [all]
Browser: [all]
When exporting a Spreadsheet with a set background to a PDF file, some of its borders are not displayed.
Some borders of the Spreadsheet are missing in the exported PDF file.
All borders of the Spreadsheet should be displayed in the PDF file.
Bug report
YEAR, MONTH and DATE functions do not return the same value on a black cell as in MS Excel
Reproduction of the problem
Apply the Year, Month or Date functions on any blank cell, it returns #VALUE!, where as Excel returns the respective value.
Environment
Kendo UI version: [all]
Browser: [all]
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.
In the Spreadsheet, if you freeze too many columns and then try to export to Excel, the file is corrupted.
If you reduce the number of columns in the example below, the issue does not occur.
The exported file is corrupted and cannot be opened
The file should not be corrupted
In Firefox with Windows 11, the Spreadsheet cannot be scrolled using the scrollbars.
The Spreadsheet cannot be scrolled through the scrollbars
The Spreadsheet should be scrolled through the scrollbars
Spreadsheet: Improper copy paste to Excel when merged cells are present and one column in the merged cells range is hidden. If the column containing the first merged cell is hidden all the rows on that row will be shifted to the left.
After pasting, the merged cell consists of 4 cells, as expected, but the cell data is shifted to the left and the hidden column contains the cell data of the next column
The cells after the merged cell should not be shifted.
To whom it may concern,
I am having a problem with the AGGREGATE function in the spreadsheet control. Cell H7 does not give me a value.
I have attached a dojo saved file, the tutorial documentation I was following (please see pages 4 & 5), a screenshot of the function in dojo and an excel file with the aggregate function working.
Thank you advance.
When the select() method is used in the Spreadsheet changing event wrong cell is selected.
Changing event is fired, but the 'B3' cell is selected instead of the 'B2'
The correct cell should be selected when using the select method inside the Spreadsheet event handlers.
When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.
The bottom border and the right border are split with a white line in the middle.
The border should appear entirely filled with the selected color.
Hyperlinks in a Spreadsheet cell do not work mobile devices.
The link in the cell does not work.
The link should work
Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.
Issue 1
Issue 2
In the Spreadsheet Index demo select a column. Try to place the mouse in between columns for the icon to be changed and to will be able to resize the column.
Currently, the selection in the Spreadsheet could not be expanded to multiple cells and the columns could not be resized when the Spreadsheet is used on a Microsoft Surface device.
The Spreadsheet should allow selecting multiple cells and resizing columns when opened on a Microsoft Surface device.