The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel. Such a feature must be implemented first in the underlying Kendo Spreadsheet widget, and to this end I encourage you to cast your votes for its implementation here: http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/19240072-context-menu-option-to-unhide-row-column
Currently, the RadSpreadsheet supports only Dollar as currency. As a temporary workaround, the Kendo UI Spreadsheet (https://demos.telerik.com/kendo-ui/spreadsheet/index) can be used as demonstrated in this Dojo example: https://dojo.telerik.com/imAWasuJ - Select a cell with number as value - Open the formats dropdown - Choose the "More Formats..." option - Select "Currency" tab - Choose a currency from the dropdown - Choose the desired format.
Currently the formatting feature (Bold, Italic and Underline) applies to entire cell content. It will be nice to have a partial cell content formatting feature (including subscript and superscript), means only few characters within the cell can be formatted instead of entire cell content (same as in Excel). Thanks
In support ticket #1058916 I was told I need to use an overriding pageLoad function to focus on the top of my page if I have a Spreadsheet control at the bottom of my page to prevent it from scrolling down to the spreadsheet when somebody navigates to the page. Was the Spreadsheet control designed to be the only element on the page? By forcing focus to be in cell A1 on pageLoad, it scrolls to the spreadsheet immediately and bypasses anything I might have above it. I would rather see a property on the spreadsheet control to focus on A1 on pageLoad that is defaulted to False rather than having to add a script. When I first navigate to any page without anchor tags in the URL, I expect to see the top of the page, not something that scrolls down to the spreadsheet and ignores anything above it!
The spreadsheet adjusts the width based on how many toolbar items are available. The width property doesn't help. It would be nice to have the spreadsheet list of tools to collapse if a width is specified that is smaller than the toolbar row at the top. I don't always want the spreadsheet to be the same width as the tools that are available.
It would be helpful if there was a way to print a spreadsheet via the code behind. As it stands someone must open up a screen with the embedded spreadsheet and export it to PDF, then print from the PDF. What we would like is the ability to print the spreadsheet without having to export to PDF first and ideally without even having to show it on screen. The way we are using it you can attach a spreadsheet to any record and there many be one or more attached, plus the user may print more than one parent record at a time. When someone prints the parent records we want to print all of the attached spreadsheets at the same time without the user having to open each one up in their browser first as this can be time consuming when dealing with large amounts of data. Thank you
Please can you implement cell-based drag-and-drop in the radSpreadsheet control. The control looks amazing. This feature would enable me to completely rewrite and simplify a number of my applications and give them a much more professional look-and-feel. Regards, Paul.
Allow to set the filename for the radspeadsheet control when a client API SaveAs is performed e.g. MyRadSpreadsheetControl.saveAsExcel("myfilename.xlsx");
It would be very handy if we could set the active sheet of the spreadsheet programmatically, either from the client-side or server-side. We'd like to be able to load a spreadsheet and select a certain tab as the initial active sheet without the user having to click on it or having to have that tab be the first in the list. Thank you!
As seems to be coming also for the Spreadsheet control in Kendo UI, it would be great if the change event would be added to the spreadsheet control The event fires, whenever the cell change its value. Moreover, the onCellClick or onCellFocus would be great. In general, i strongly believe that there is a huge lack of helpful events for this control. Thanks
Can be interesting the power pivot functionality to be supported for spreadsheet control for telerik ui for Ajax.Net.
I would like to see the ability to add checkboxes to spreadsheet cells. In particular, I would like to check boxes in the top row and/or the right column to select rows or columns and then modify cell values based on the the selected checkboxes.
The Spreadsheet control looks fantastic and will help us replace existing functionality, along with building new streamlined user interfaces. Please include the ability to specify individual cells that function as drop-downs, where we could bind the data to an external source and have the user select one of the options.