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.
In the Spreadsheet control for jQuery it is possible to set cells as read-only through the use of the Enable property.
However, on calling saveAsExcel() these cells are editable. This means as a developer it is then necessary to create both the spreadsheet JSON (for Kendo Spreadsheet) as well as another spreadsheet class to export to Excel.
Could you please map the Cell.Enable property to the setting of Excel cells as disabled/read-only. Thanks 👍
When I use this formula
=HYPERLINK("mailto:"&B4&"?subject=“& B5 & “&body=“ & B6,", "test")
in the excel, I am able to click on the link which opens up my mail client with compose new email window and also populates To, Subject and Body of the email from cells B4, B5, B6 respectively.
But currently, HYPERLINK formula does not support "mailto:" functionality in Kendo UI spreadsheet. I would love to see this with kendo UI spreadsheet.
For more details you can see the discussion on the forums here.
Extract only the values for all Spreadsheet cells. These extracted values can be sent back to server (with minimum size) as server only needs data on each sheet. On other information required like references, formulas, images, colors etc.
On click of save or a separate button, which will generate a low size data file (having sheet name, cell index and value), which we can send to server.
It will save network traffic and also no complex parsing needed at server side to fetch data.
Use case: My app doesn't know how many rows of data the excel spreadsheet will be prior to upload. I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others. The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition. As a workaround, I'm destroying and reloading the widget instance after the initial load.
2. select row header of row 10, go to Insert tab
3. click insert row below, it inserts row successfully after row 10, it adjust formulas of row 12, and other rows there after which is good.
4. But issue is - it neither keep format of row 10 in new row & nor it add formulas to various columns in new row(e.g. F11, E11)
Please suggest how can we achieve it, it is very common and useful feature which excel have. if you do not have any ready solution then please suggest workaround for the same as it is urgent for my client.
Additional functionality for: -- Conditional Formatting -- coloring of cells, for example based upon a value and then be able to import from excel, and export back out. -- Data Validation (dropdowns). Also be able to import and export back out.
I want to highlight spreadsheet on cell hover. But I just want to highlight row and column until cell. Is there any way to do this ?
In example, When my mouse on cell E11.
In Excel it is possible to select several rows and increase/decrease all selected rows height. In the Spreadsheet this works only for the last selected row. The following steps demonstrate the behavior:
2. Click on the header of row 6, hold and drag until rows 6, 7, 8, 9 , 10 are selected.
3. Click the handle below row 10's header and drag to increase the height of the rows. The Spreadsheet increases only the last row's height.
Currently, the sheets in the Spreadsheet component can be reordered. It will be a very useful feature if we can configure the component in a way this reordering can be disabled.
Thus the users won't be able to move the sheets' tabs.
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.
It would be great if you would add accessabbility to the spreadsheet as it seems to be the last control without this feature.
Currently the focus gets trapped inside its grid and the user cannot leave the spreadsheet with the TAB key. At least this should be avoided. It would be also better if only the first cell would be focusable and you then could navigate with the arrow keys, as with thousands of cells it is not very comfortable to use the TAB key.
Load big excel files stored on the server
Load on demand data:
First load the file structure (sheets name, column names and number of rows)
Then load data when sheet is selected or scrolled