Currently, Kendo UI for jQuery Spreadsheet does not support many events such as style change, merge, unmerge, image insert, font change, alignment change, decimal change, filters and more.
But these events need to be captured in many cases.
Please support events for all the actions.
Custom validation error can not be handled in spreadsheet
https://dojo.telerik.com/@zdravkov/uJuruCod
go to Data->Data Validation->Custom Formula (Ignore blank, Reject input),
open the console,
than if you enter an invalid formula (<4, >A3 or something like this) and press Apply, in the console you can see an exception
The exception can't be handled
One should be able to handle the exception
workaround - https://dojo.telerik.com/@zdravkov/adEWOlOk
The Spreadsheet SLOPE and INTERCEPT functions do not calculate if arrays passed as parameters contain blank or string cells
Calculation of the SLOPE and INTERCEPT functions should be consistent with Excel
Currently, when an invalid validation formula is used, the Spreadsheet throws a js exception.
For example: https://dojo.telerik.com/AWEyIHoW
Open the Data/Data Validation dialogue on cell A3 and modify the Value of the Formula into an Invalid formula (e.g. : “>3”)
A parse error is thrown.
It would be a nice improvement, if instead of throwing a js exception, the user is notified about the invalid formula through a dialog showing a relevant message.
Dojo example.
After the initial value change the filter menu no longer shows the current value of the modified cell.
The filter menu should always show the current values of the cells.
cell connection in Spreadsheet is not working when the sheet contains 1.0 in the name
download the file from ticket - 1500102
open our demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
open the file from the ticket in the Kendo Spreadsheet
cell F17 is not connected with cell B12 from the second sheet
cell F17 is connected with cell B12 from the second sheet
note: if the name of the sheet is changed to something different than 1.00 for example 'A' the cells are connected
Can you add feature or set option to allow text to run into adjacent cells to right?
(example in ticket 1500102)
Reproducible in the demos. The attached video demonstrates the issue.
Recording49.zip
As shown in the video, the F column completely disappears. The column letter remains visible within the next column (G). F column's resize handle remains hidden, and it cannot be made visible.
There should be a minimum column width that should be respected on resizing. Its value should always allow the column to be resized. No column overlapping should occur.
when the color of the borderBottom is commented
"borderBottom": {
//"color": "black",
js error when color is not applied a cell of the Spreadsheet
kendo.all.js:61278 Uncaught TypeError: e.transform is not a function
https://dojo.telerik.com/@zdravkov/iVoJuxAZ
export to pdf
js error
the data is exported correctly
Related To: #5500
When there are merged cells and the SUM formula is used for the merged cells the result is wrong (it depends on the count of the merged cells)
The result in the D1 cell is 20. ( value of cell * count of cells in merged range)
The result should be 5. In the same scenario, the result in Excel will be 5.
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.
Values that are copied from Spreadsheet are duplicated when pasted in Excel if before that the copied cells have been cut and pasted inside the Spreadsheet.
In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied
The pasted in Excel content should contain 2 rows instead of 3
Dojo example.
The text in B2 is not unwrapped.
The merged cell prevents the unwrap. If there is no merged cell, or if the tool is used over the cell itself, wrapping/unwrapping works as expected.
The text in B2 is unwrapped.
Hi Team,
I'd like to request a built in method for finding the intersection of ranges for the Kendo UI Spreadsheet.
Thank you
Hi Team,
I would like to request the ability to set an autoFit for the rows/columns(specific or all). This would not just related to wrapping.
For example, in the following Progress Kendo UI Dojo, the user can create 3 lines by button press. But if the user replaces the contents with 1 line of text, it will keep the height of when the 3 lines were in cell.
I know I could use the rowHeight method, but it would be great if there was a way for it to resize automatically.
Thank you for your consideration.
Hi Team,
I'd like to request a way to manipulate a large amount of cell groups in the Kendo UI Spreadsheet without decreasing performance. For example, I'd like to be able to merge/unmerge and change font size to multiple specific cell groups. I understand changing multiple DOM elements at the same time can cause sluggishness, but maybe there's a way to reduce the time. Currently, it's taking a long time to completely load.
Thank you for investigating.
When multiple cells are merged in the Spreadsheet the DatePicker is not always rendered at the correct position.
The DatePicker is not always entirely visible (screencast)
DatePicker should be visible