When importing from Excel in Spreadsheet if a date is entered, but the date format is not set explicitly, the imported date always has the following format: "mm-dd-yy". The issue is observed even if a culture is set.
The value in Excel is "15.6.2020" , but the imported date in the Spreadsheet is "05-15-20" screencast
The format of the dates should be the same as in the imported file.
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 ]
Hi there,
When a spreadsheet is linked to a datasource, if you leave a gap between previously entered rows and your new data, each cell edit creates a new item in the datasource with only the cell modified.
Here is the record after adding one cell.
and after adding another cell:
This is the state of the spreadsheet:
I managed to replicate this in dojo here: https://dojo.telerik.com/eRiHocar
When an Excel file with 'Set precision as displayed' option enabled is imported in the Spreadsheet the calculations are not the same as in the Excel file.
Reproduction:
1. Open the Spreadsheet demo
2. Import the excel file from the zip. in the Excel file the following option is enabled - File->Options->Advanced->When Calculating this workbook-> Set precision as displayed
The value in Excel in C1 column is 399.96, while the value displayed in the Spreadsheet is 400.00
I would like to have support in Spreadsheet for Excel files with 'Set precision as displayed' option enabled.
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]
When the background tool is displayed in the overflow menu of the toolbar and the user tries to change the background color or text color an error: e[this._property] is not a function
is thrown.
An error e[this._property] is not a function
is thrown and the background color is not changed.
There should be no error in the console and the color should be changed accordingly.