1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.
2. Click on open button in the Toolbar of the spreadsheet.
3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.
4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.
5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.
Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?
To reproduce
Steps to reproduce the behavior:
step1: Make a cell become wrap text and text something
step2: Export to pdf file:
Expected behavior
Text display same as on safari
Please fix this problem asap!!!.
There is an issue with the Date type fields validation in the Spreadsheet.
Here are the reproduction steps:
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import attached xlsx file.
3. There are two date cells (B1 & B2), B2 has a data validation (Date between B1 to ToDay)
4. Try to edit the date using the calendar icon from B2. An empty calendar appears
Note: If I change data validation (remove reference of B1 and put hardcoded date) as below then it works.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Open Workbook(1).xlsx (attached)
3. Edit B2, D2, F2 with some new values
4. See the results in B4, D4, F4
Calculations are different in Excel.
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
Hi Team,
I would like to request the Kendo UI Spreadsheet to include JSZip 3.x functionality for future releases.
Thank you!
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.
The Spreadsheet supports names that are defined within the global worksheet level (Workbook). However, when uploading a file that contains defined names, which scope is the local worksheet level (for example, Sheet1), the names are not available.
For example, upload the attached file in the Spreadsheet in the following online demo.
https://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export
The name defined in the scope of "Sheet1" is not available:
Please improve the Spreadsheet to support names defined in the scope of the sheet?
Cannot delete defined names in the name box of the Spreadsheet when clicking the delete button.
Regression introduced with 2022.1.119
The items cannot be deleted.
The following error appears in the browser console:
Uncaught TypeError: Cannot read properties of undefined (reading 'name')
The items in the name box should be deleted and an error should not appear.
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]
Hi Team,
I would like to request the functionality to be able support multiple languages for the Excel file. It would be great if there was a way to make the file content automatically change to a specific language.
For example, if we could use a collection of <English key, French strings> of a selected language e.g. French, and all Excel text strings matching with the English key would convert to the French text.
Thank you!
Hi Team,
I would like to request a way to include commas for the sheets.rows.cells.validation.from values.
For example:
Instead of:
Additionally, it would be nice to be able to use another delimiter instead of commas.
Thank you!
If you copy a cell whose text contains multiple spaces from one Spreadsheet and try to paste it in another, the multiple spaces are lost
The pasted content contains only one spaces instead of three, as in the original cell content
All the spaces should be preserved when pasting in another Spreadsheet.
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]
When the Spreadsheet is bound to a DataSource upon making multiple selections in the Spreadsheet and deleting the selected ranges a JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.
A JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.
Upon an attempt to delete multiple selections a popup should be displayed with a warning that this operation is not supported, similar to trying Copy/Paste multiple selections.
After the 2022 R2 SP1 version. there is a bug in the spreadsheet data source. when dill down the cell, the data source will not be changed. only input text can trigger the change event.
Reproduction steps:
Expected:
Button is enabled
Actual:
Button not enabled
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