Define by Settings or via API Calls custom context Menu for any Cell, like change current by Event BeforeContextMenu(ref ContextMenuElement)
For the time being the Spreadsheet parser is unable to read files which tags are not in the default namespace. Try to open the attached file in this demo project: https://demos.telerik.com/kendo-ui/spreadsheet/index.
You won't be able to load the file. If you open the file in Excel, save the file ("Ctrl+S") and try to load it in the Spreadsheet again, there will be no issues with it. The difference in file's structure before and after being saved in Excel could be seen in the attached screenshot.
The code in red is the structure of the file before saving it and the one in green is after the "save" operation. The difference between the files is that the structure of the one saved in Excel inserts the tags in the default namespace while the original document uses the "x:" namespace.
It will be very useful if we can load files with defined namespaces in their structure.
Currently the spreadsheet dynamically creates the FilterMenu for a range, that is, it's not created until someone clicks the filter dropdown, and it's destroyed if they switched tabs. There is no event that is fired when these things happen, which makes it hard to attach to, and customize, the FilterMenu without setting up some crazy listening code (setTimeout, etc.). It would be great if either (or both: - You could specify a template for the filter menu. - You could listen for a "FilterMenu Initialized" event and capture the menu there and customize it.
Is is possible to trigger validation in cells in spreadsheet control? I want to make all validation controls with a button click outside the spreadsheet control.
Please support Excel formulas copy and paste to Kendo Spreadsheet. Now is the copy only the text, not formulas.
1. Enter some text in a cell.
2. Increase the cell font size to 48.
3. Reduce the cell font size to 8.
4. Double click the row resize handler: the row height is not adjusted to correspond to font size 8.
The same behavior can be observed when opening an existing .xlsx file that has some text and font size set and following steps 3-4.
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Put some text in B2 so that it does not fit in the cell width.
3. Press Wrap Text button
4. Press Wrap Text again
5. The row height is not adjusted back to the original height (Excel does it)
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
I have observed that Conditional Formatting in Spreadhseet is not supported. Please add support for the same as it is very important feature of XLSX. during financial calculation this feature plays an important role. Here is the issue that needs a fix.
2. Check attached file CellColorFormula.xlsx, conditional formatting set for B2, C2, D2
3. Import attached file CellColorFormula.xlsx
4. Check Cells B2, C2, D2 and try to change values for A2, C2, D2
5. None of the conditional formatting is working
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.
I would like to be able to generate PDF from spreadsheet using HTML template (like http://dojo.telerik.com/Ovegu), so i could specify headers and footers for all PDFs that are created by the user.