Completed
Last Updated: 12 Feb 2021 15:33 by ADMIN
Created by: MikeK
Comments: 1
Category: Spreadsheet
Type: Feature Request
0
Please provide the ability to specify splitter type of functionality where several rows could be static while the remainder of the screen would scroll.
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!
Completed
Last Updated: 06 Jan 2021 13:02 by ADMIN
Release R1 2021

Workaround(Approved by Admin):

<script>
    // Place/load this script after the ScriptManager
    if (Telerik.Web.UI.RadSpreadsheet) {
        Telerik.Web.UI.RadSpreadsheet.prototype.original_initialize = Telerik.Web.UI.RadSpreadsheet.prototype.initialize;
        Telerik.Web.UI.RadSpreadsheet.prototype.initialize = function () {
            this.original_initialize();
            this.add_parentShown(this.get_element());
        }
        Telerik.Web.UI.RadSpreadsheet.prototype.repaint = function () {
            this.get_kendoWidget().refresh()
        }
    }
</script>

Reproduction: 

<telerik:RadWizard runat="server" ID="RadWizard1">
    <WizardSteps>
        <telerik:RadWizardStep ID="WizardStep1" StepType="Start">
            Step 1
        </telerik:RadWizardStep>
        <telerik:RadWizardStep ID="WizardStep3">
            <telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1"></telerik:RadSpreadsheet>
        </telerik:RadWizardStep>
        <telerik:RadWizardStep ID="WizardStep4" StepType="Finish">
            Finish step
        </telerik:RadWizardStep>
        <telerik:RadWizardStep ID="WizardStep5" StepType="Complete">
            Completed!
        </telerik:RadWizardStep>
    </WizardSteps>
</telerik:RadWizard>

Completed
Last Updated: 06 Jan 2021 09:54 by ADMIN
Created by: Brad
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
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
Completed
Last Updated: 03 Nov 2020 10:16 by ADMIN
Release R3 2019
Created by: alessandro
Comments: 1
Category: Spreadsheet
Type: Feature Request
2
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


Completed
Last Updated: 03 Nov 2020 10:12 by ADMIN
Release R1 2020 SP1
Created by: Tim Barton
Comments: 2
Category: Spreadsheet
Type: Feature Request
2
The ability to add comments to a cell.   This is helpful to give users understanding of the cell values.
Completed
Last Updated: 23 Oct 2020 09:32 by ADMIN
Release R3 2020
Created by: Mamallan
Comments: 1
Category: Spreadsheet
Type: Bug Report
1

The issue is replicated when the spreadsheet is higher than the screen height. To reproduce it, scroll the page and click the last visible cell. 

Result: The page is scrolled to the beginning of the Spreadsheet element

Expected: The page is not scrolled

<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1" Height="2000px" Width="100%">
</telerik:RadSpreadsheet>

 

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: 13 Jul 2020 10:20 by ADMIN
Created by: Mamallan
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Link is not clickable when situated in a disabled cell.

Steps to reproduce.

1. Place a link in a cell or a range of cells

2. Disable the cell (range)

3. Click the link

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.
Completed
Last Updated: 06 May 2020 15:13 by ADMIN
Release R2 2020

Workaround: Placing the following script under the ScriptManager

<script>
        kendo.spreadsheet.registerEditor('_validation_list', function () {
            var context, list;
            function create() {
                var $list = $("[id$='SpreadsheetListBoxDropDown']").first();
                var element = $list.closest(".rssPopup");

                list = $find($list.attr("id"));
                if (!this._listdropdown) {
                    var dropdown = new kendo.spreadsheet.DropDown(element);
                    this._listdropdown = dropdown;

                    list.add_selectedIndexChanged(function (sender, args) {
                        dropdown.close();
                        var item = list.get_selectedItem();
                        if (item) {
                            context.callback(item.get_value());
                        }
                    });
                }

                this._listdropdown.openFor(context.view.element.find('.k-spreadsheet-editor-button'));
            }
            function open() {
                create();
                var matrix = context.validation.from.value;
                if (matrix) {

                    var items = list.get_items();
                    items.clear();
                    matrix.each(function (el) {
                        var item = new Telerik.Web.UI.RadListBoxItem();
                        item.set_text(el);
                        items.add(item);
                    });
                }
            }
            return {
                edit: function (options) {
                    context = options;
                    open();
                },
                icon: 'p-icon p-i-arrow-60-down'
            };
        });
    </script>

 

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: 24 Apr 2020 10:02 by ADMIN
There are no issues when the user makes changes to the imported Blank XLSX document.
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!
Completed
Last Updated: 19 Feb 2020 12:56 by ADMIN
Release R1 2020 SP1
Created by: MikeK
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Please provide the ability to add Tooltips to specific cells.
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
Completed
Last Updated: 02 Oct 2019 15:01 by ADMIN
Cells in Spreadsheet are automatically underlined on second save or when the file is loaded dynamically.

Code to reproduce:
        string filePath = Server.MapPath("Test.xlsx");
        Telerik.Web.Spreadsheet.Workbook wkb = Telerik.Web.Spreadsheet.Workbook.Load(filePath);
        wkb.Save(filePath);


Completed
Last Updated: 03 Sep 2019 16:06 by ADMIN
Release R3 2019
ADMIN
Created by: Marin Bratanov
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
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
Declined
Last Updated: 06 Aug 2019 09:13 by ADMIN
Created by: JF
Comments: 2
Category: Spreadsheet
Type: Bug Report
0
I have two lines that was set to a certain height,

Each time I save the sheet, those two lines expand by 8 pixels.

Does anyone are reading those bug reports?