Hi ,
we have a requirement to disable comment option on click of few cells (which are disabled) or to show a toastr message on click of comment that user can't add comment on specific cell. Do you have any such feature or event to track this requirement .
It should be possible to define cell types (or types that are valid for the entire column) like: - Booleans (which will result in showing check boxes inside the cells)
Hi Team,
I would like to request the Kendo UI Spreadsheet to be able to validate by Text Length instead of using custom validation. This would help with importing xlsx files which have text length validation.
Thank you!
When using the bottom right corner of a cell to batch copy values across a range by dragging the corner, an error popup appears if a disabled cell is found inside the range that was dragged into. It is possible to reproduce this with this demo: https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells 1. Set the quantity column to disabled. 2. Select B3. 3. Drag the bottom right corner of B3 to D3. 4. See error: "Destination range contains disabled cells." There should be an option to allow that to copy into any enabled cells in that range and ignore the disabled ones.
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.
Support scenarios where users can use the spreadsheet component to design templates with disabled cells. I appreciate that this can be customized (as almost anything) but note this is the only cell property that is not configurable via the toolbar.
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.
Can you add feature or set option to allow text to run into adjacent cells to right?
(example in ticket 1500102)
I see some potential for improvements here, I see how the Spreadsheet entirely depends on the JSON structure. It doesn't have to be like this as the setDataSource() method shows clearly that the columns could be further configured:
https://www.telerik.com/forums/datasource---specify-columns#msCK2ytWcESxeUMs-6a3uQ
Therefore, the Sheet columns could be configured upon the widget initialization. Such configuration options could be represented in the following manner for the HTML helper version of the widget:
.Columns<Kendo.Mvc.Examples.Models.SpreadsheetProductViewModel>(columns =>
{
columns.Add(c => c.ProductId).Name("Product ID").Width(100);
columns.Add(c => c.ProductName).Name("Name").Width(415);
})
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.
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.
Working with numbers like 0.000001056 in a Spreadsheet that is bound to a dataSource, after saving the dataSource, the mentioned number will be converted to an exponential format.
The current feature request is about preventing the format changing after saving decimal numbers.
It will be very useful if we can use the Spreadsheet with dataSource binding but keep the decimal numbers as such, not converting them to exponential expressions.