Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.
Has anyone at Kendo ever thought of putting an OnBlur event on a Spreadsheet Cell. The purpose of the event (at least in my case) would be to cancel navigation to another cell. The Change and Changing events are close, but from what I can tell there is no way to cancel the navigation when either of these events fire. If you navigate to another cell and the data has changed, the Changing event fires before the Select event, but there is no way to stop the select event from firing once the Changing even is complete. I tried using Select from with the Changing event to set navigate back to the same cell, but there is currently an open bug in respect to that, as it does not navigate properly.
To hopefully state it more clearly, It would be nice if the Spreadsheet cell had an OnBlur Event that allows you to cancel navigation and remain in the same cell. Ideally it would word for all forms of navigation. Mouse Click on new cell or Scroll with Arrows.
When cells of the Spreadsheet that contain data are merged data loss occurs.
To prevent inappropriate merges we need to be able to handle an Merge/Unmerge event of the Component that should be preventable.
Thank you.
When the select() method is used in the Spreadsheet changing event wrong cell is selected.
Changing event is fired, but the 'B3' cell is selected instead of the 'B2'
The correct cell should be selected when using the select method inside the Spreadsheet event handlers.
Hi Support Team,
Would like to have a feature below:
Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.
Issue 1
Issue 2
In the Spreadsheet Index demo select a column. Try to place the mouse in between columns for the icon to be changed and to will be able to resize the column.
Currently, the selection in the Spreadsheet could not be expanded to multiple cells and the columns could not be resized when the Spreadsheet is used on a Microsoft Surface device.
The Spreadsheet should allow selecting multiple cells and resizing columns when opened on a Microsoft Surface device.
Hi Team,
I'd like to request the functionality to allow cell configurations to be populated by database values by default. For example, I'd like to have a value from the database populate the specific link configuration.
Thank you!
Hi,
When editing a workbook with the Spreadsheet component, if a user switches from a worksheet to another, then moves the scrollbars, when switching back, although the active cell is adequately recovered, the scrollbars are not (the user experience is that they do not react to worksheet switching).
Is this behavior planned to be changed? Is there a workaround?
Best
Currently, when the "Custom format" button in the Spreadsheet is clicked, the available predefined formats that can be applied to a cell appear as demonstrated in the below screenshot. These predefined options don't change if you set a specific Kendo UI culture.
It will be a very useful feature to be able to change the predefined custom formats. Also, it will be nice if the custom formats in the Spreadsheet can be set based on the selected Kendo UI culture.
Currently, when a custom button is configured in the Spreadsheet toolbar a separator is added before the button. I would like to have an option to configure whether such a separator is to be rendered or not.
I would like to avoid adding custom styles for hiding unneeded separators, which is needed with the current implementation (Dojo).
add search functionality to the Spreadsheet.
When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.
The bottom border and the right border are split with a white line in the middle.
The border should appear entirely filled with the selected color.
Hyperlinks in a Spreadsheet cell do not work mobile devices.
The link in the cell does not work.
The link should work
Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource
And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve
The first added cell value (or row) is removed when the user deletes an empty row.
If the ID is entered, the result is even stranger:
https://www.screencast.com/t/osmVOiY7al
It should behave and function like Excel. I think with local/static binding there are no issues.
Hi Admin,
I made the DIV where I had the Spreadsheet widget in full screen mode by: document.fullscreenElement. I have some validations configured in the spreadsheet. Apparently, in full screen mode, the prompt opens behind it. Is there a way I can do an "appendTo" to the validation prompt?
Please advise.
Thank you very much.
Best Regards,
Jenny
Currently, when working on a mobile device, the Spreadsheet doesn't have all the functionalities available when working on a desktop machine.
Providing support for the merge cell, multi-cell selection & context menu opening when working on a mobile device will be very useful for the Spreadsheet.
Hello
When we have filtered rows in a spreadsheet (some rows are hidden) and we copy a single cell and paste into a range containing the hidden rows....
The spreadsheet copies the value into all cells in the range including those that are hidden. This is not the same functionality as Excel.
That said, is the any way to skip hidden cells in the paste range?
Is there a way to override the Kendo past function to do this? Can you provide an example?
Thank you
Jeffrey Suffet
Hi there,
I'd love the ability to specify regex validation for the spreadsheet component. I saw a forum post (https://www.telerik.com/forums/spreadsheet-regex-validation) someone else had made relating to this, but couldn't find a feature request made based off of it.
(taken from the post) Ideally it'd look something like this:
var columnSens = spreadsheet.activeSheet().range("A2:A10");
columnSens.validation({
dataType: "custom",
from: 'REGEX("^(()|((?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[^\da-zA-Z]).{8,60}))$")',
type: "warning",
allowNulls: true,
titleTemplate: "Invalid Password",
messageTemplate: "Passwords must be between 8 - 60 characters long and contain the following: 1 number, 1 uppercase letter, 1 lowercase letter, and 1 special (non letter or number) character."
});