The FromJson method of Telerik.Web.Spreadsheet.Workbook doesn't add images when a JSON containing an image blob is passed to it.
It would be nice if the FromJson method supports images.
When spreadsheet cells are merged and have comment, it's shown only when hovering over first cell and not shown when hovering over other cells of the merged group of cells
Example to reproduce on dojo - https://dojo.telerik.com/@Andrii/uHINuvIh
On the cell A1 there is a comment, merged cells are A1:G1, comment is shown only when hover over cell A1.
There are multiple formats for date and time in kendo and in different cultures the count increases. Is there a function in which i pass spreadsheet cell value and format and it returns that it is a date format or number format. I just want to know the type of format so i can parse the dates on my own from json on server side.
### Bug report
When the property "useCultureDecimals" is enabled in a culture where the decimal separator is the comma, the function Text() does not format numbers correctly.
### Reproduction of the problem
1. Set a culture where the decimal separator is the comma (i.e. "da-DK");
2. Create a Spreadsheet and enable the property "useCultureDecimals";
3. Enter a number with a decimal separator comma (i.e. "0,1141");
4. Format the cell by using the Text() function ( =TEXT(A1; "##0,00%") );
5. The number is not formatted properly - "011%"
A Dojo sample for reproduction: https://dojo.telerik.com/AsiLiKil/12
### Expected/desired behavior
"0,1141" should be formatted as "11,41%" as in Excel.
* **Kendo UI version: 2021.3.914
* **jQuery version: 1.12.4
* **Browser: [all]
In my application I am using the following.
Dojo example: https://dojo.telerik.com/@iankodj/aKIyEwUv
The spreadsheet component works well with the namespace, however any dialogs that the component opens do not function correctly.
For example, I am using Edge browser. If I copy a cell and they try and past the value via the context menu, a dialog appears telling me to use the keyboard.
The "ok" button of the dialog does not work. Looking at the html source that is added to the DOM, it appears that the button is trying to bind to the click event via a "data-bind" attribute rather than a "data-kendo-bind" attribute as specified via the namespace.
The attached file show the behavior with the Basic demo example having the kendo namespace set.
When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.
The value entered for the cells below is SS13, SS14 etc.
The value entered for the cells should be SS0012, SS0013 etc.
In Spreadsheet, the cell format is lost when you change its value.
The new value is not rounded as per the preset format.
The new value should respect the format set for the cell.
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.
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.
Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:
let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();
If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).
let dataURL = new kendo.ooxml.Workbook(data).toDataURL();
The generated Excel file is corrupted
The generated Excel file is not corrupted
Hi, I'm using the spreadsheet control and i'm having an issue with date columns.
When I enter a valid date, it works fine.
but when I enter an empty date (clicking delete on date column, or emptying out the contents)
the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]
obviously, this is incorrect, and it should store the value as NULL.
it happens regardless of whether the schema/model has nullable=true.
If I manually modify the dataItem via JS, it stores it correctly as null.
I have a dojo demo set up which replicates the issue.
Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.
It would be nice to have custom attributes for rows and cells so that I can track things behind the scenes such as row identifiers that could be used to update a corresponding rows in a the data base. This id would not be editable by the user. There are many more uses I would like this for and that is just one example.
I would rather not have to create a column in the spreadsheet just for this and then hide it. I find that very clunky.
Currently, in Kendo Spreadsheet multiple rows/columns can not be selected by using Shift + click. For example, in Excel, if the user clicks on the first column header, then press 'Shift' key and click on the fifth column header all five columns will be selected. The same is valid for row selection.
I would like to have the possibility for multiple rows/columns selection by using the Shift key +click In Kendo UI for jQuery Spreadsheet.
Enable Cut/Copy cell values and can Paste it in mutiple selected values
the spreadsheet component triggers no change event if the width of a column changes. Is it possible to track a change of the width of a column?
Can be reproduced with your event demo of the spreadsheet component (https://demos.telerik.com/kendo-ui/spreadsheet/events)