Unplanned
Last Updated: 13 Oct 2022 11:03 by David
Created by: David
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

I have RadSpreadsheet with 5 rows. If I copy 10 rows from Excel into RadSpreadsheet, it will show error message "Cannot paste, because area not the same size".

Is it possible to get RadSpreadsheet to automatically add rows when we paste data? (similar to the Kendo Spreadsheet Widget)

Unplanned
Last Updated: 14 Jun 2021 10:57 by ADMIN
Created by: Paul
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
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.
Unplanned
Last Updated: 17 Mar 2021 10:13 by ADMIN
Created by: Oliver
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Currently, a script solution is required to pre-select a sheet different from the first one.

function pageLoadHandler() {
    var spreadsheet = $find("<%= RadSpreadsheet1.ClientID %>").get_kendoWidget();
    var sheet = spreadsheet.sheetByName("Sheet1");
    spreadsheet.activeSheet(sheet);
        
    // Sys.Application.remove_load(pageLoadHandler);  
}
Sys.Application.add_load(pageLoadHandler);  

 

This script could be entirely loaded from the server-side following this article on how to properly register a script from the code-behind:

 

 

 

Unplanned
Last Updated: 08 Jan 2021 09:54 by ADMIN
Created by: Matt
Comments: 2
Category: Spreadsheet
Type: Feature Request
1
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!
Unplanned
Last Updated: 12 Aug 2020 05:05 by ADMIN
Created by: Emanuele
Comments: 5
Category: Spreadsheet
Type: Feature Request
1

I think it might be very useful to add to cell comments a html code and be able to do it programmatically.

Thank you

Unplanned
Last Updated: 10 Aug 2020 11:33 by ADMIN
Created by: FCosta
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

Hello,

The problem is as follows:

  • I have a template file (xlsx) that defines some style settings
  • I load the template file into the component (RadSpreasheet) and the settings are assumed correctly
  • I save the changes to a new file (spreadsheet) and the settings related to the cell border lines (thickness) are not respected
Unplanned
Last Updated: 18 Jun 2020 16:30 by ADMIN
ADMIN
Created by: Peter Milchev
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
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.
Unplanned
Last Updated: 27 Apr 2020 10:42 by ADMIN
Created by: Jerry
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

The RadSpreadsheet server-side object does not support Named Ranges. 

Workaround:

Nevertheless, you can load them client-side with the code below, by saving a JSON in a hidden field and loading it via the API:

protected void Page_Init(object sender, EventArgs e)
{
    var path = Server.MapPath("~/App_Data/spreadsheet.xlsx");
    var workbook = Workbook.Load(path);
    HiddenField1.Value = workbook.ToJson();
}

<script>    
    function pageLoadHandler() {
        var spreadsheet = $find("<%= RadSpreadsheet1.ClientID %>");
        var hiddenfield = $get("<%= HiddenField1.ClientID %>");
        if (hiddenfield.value) {
            spreadsheet.get_kendoWidget().fromJSON(JSON.parse(hiddenfield.value))
            hiddenfield.value = '';
        }

        // Sys.Application.remove_load(pageLoadHandler);  
    }
    Sys.Application.add_load(pageLoadHandler);
</script>
<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1"></telerik:RadSpreadsheet>
<asp:HiddenField runat="server" ID="HiddenField1" />

 

Unplanned
Last Updated: 23 Mar 2020 16:53 by ADMIN
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!
Unplanned
Last Updated: 03 Jan 2020 17:11 by ADMIN
Created by: Steve
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
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
Unplanned
Last Updated: 09 Nov 2016 14:09 by ADMIN
ADMIN
Created by: Veselin Tsvetanov
Comments: 0
Category: Spreadsheet
Type: Feature Request
0

			
Unplanned
Last Updated: 14 Jun 2016 14:39 by Daniel
Allow to set the filename for the radspeadsheet control when a client API SaveAs is performed e.g. MyRadSpreadsheetControl.saveAsExcel("myfilename.xlsx");