Completed
Last Updated: 13 Aug 2021 08:13 by ADMIN
Release R3 2021

Repro: 

<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet1" />
<telerik:RadSpreadsheet runat="server" ID="RadSpreadsheet2" />

protected void Page_Load(object sender, EventArgs e)
{
    var workbook = new Workbook();
    var sheet1 = workbook.AddSheet();

    AddDateRow(sheet1);

    sheet1.Columns = new List<Column>() { new Column() { Index = 1, Width = 150 } };

    RadSpreadsheet1.Sheets.Add(sheet1);
    RadSpreadsheet2.Sheets.Add(sheet1);

    RadSpreadsheet1.ColumnsCount = 5;
    RadSpreadsheet1.RowsCount = 10;
}

private void AddDateRow(Worksheet sheet1)
{
    var row = new Row() { Index = 0 };
    Cell firstCell = new Cell() { Index = 0, Value = "Select Date:", Bold = true };
    row.AddCell(firstCell);

    Cell secondCell = new Cell() { Index = 1, Value = "", Bold = true, Background = "#fef0cd", Format = "mmmm d, yyyy" };

    secondCell.Validation = new Validation()
    {
        AllowNulls = true,
        DataType = "date",
        ShowButton = true,
        ComparerType = "between",
        From = "DATEVALUE(\"1/1/2000\")",
        To = "DATEVALUE(\"12/31/2020\")",
        Type = "reject",
        TitleTemplate = "Invalid date selected",
        MessageTemplate = "Select a date between year 2000 and 2020."
    };

    row.AddCell(secondCell);
    sheet1.AddRow(row);
}

 

 

 

 

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.
Completed
Last Updated: 09 Jun 2021 16:43 by ADMIN

In Internet Explorer version 11.418.18362.0, when hovering over the lower-right dot the cursor doesn't change to the expected cross-hair. 

 

To Reproduce:

1. Open IE11

2. Navigate to the ASP.NET Spreadsheet Demo

3. Highlight a few cells

4. Hover the cursor over the lower-right dot

Expected Behavior:

The cursor changes to a thin cross-hair icon but it doesn't change in IE 11.

Completed
Last Updated: 28 May 2021 17:46 by ADMIN
Created by: MikeK
Comments: 1
Category: Spreadsheet
Type: Feature Request
0
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.
Unplanned
Last Updated: 28 May 2021 17:35 by ADMIN
Created by: Jared
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Please add a cell Name field visible on the client and server side. If this name could be grabbed from an excel spreadsheet using the naming functionality built into excel, that would be a major plus.
Declined
Last Updated: 28 May 2021 14:54 by ADMIN
Created by: Trent
Comments: 1
Category: Spreadsheet
Type: Feature Request
0
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. 
Declined
Last Updated: 27 May 2021 18:29 by ADMIN
Can be interesting the power pivot functionality to be supported for spreadsheet control for telerik ui for Ajax.Net.
Completed
Last Updated: 27 May 2021 15:32 by ADMIN
Created by: Matt
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
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.
Unplanned
Last Updated: 27 May 2021 08:36 by ADMIN
The SpreadProcessing library gets into account the current server culture and the SpreadsheetDocumentProvider uses different decimal and list separators based on the culture while the RadSpreadsheet control supports only comma as a list separator and dot as a decimal separator. 

The JavaScript error that is thrown when using the "sv-SE" culture is caused by the fact that this culture uses the comma as a decimal separator and semicolon as a list separator. 

One possible workaround is to change the current thread's culture before creating the Spreadsheet's provider and then restore the culture.
Completed
Last Updated: 17 May 2021 09:14 by ADMIN
Created by: JF
Comments: 1
Category: Spreadsheet
Type: Bug Report
0
Problem with simple excel behavior.

In excel when you type a string longer than the cell, text is not clipped and shows over other cells.  Then, if you fill adjacent cell, text is then clipped.

I've been able to mimic this behaviour using this css:

.RadSpreadsheet .rssPane .k-spreadsheet-cell {
    overflow: visible !important;
  }

But then, If you highlite those cells with background color  the text is again clipped.  The background color wipe the text.

Attached is a small png to show the problem.

Please fix this to work as excel.  Users are complaining non stop.

Thanks.
Completed
Last Updated: 26 Mar 2021 15:06 by ADMIN
Release R1 2021 SP2

Getting these errors when trying to update spreadsheet cells. Uncaught TypeError: Cannot read property 'offsetWidth' of undefined


The issue is happening even on the demo component when editing a cell:

https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/overview/defaultcs.aspx

Workaround from Admin: 

Load the following script under the ScriptManager:

<script>
    if (kendo && kendo.spreadsheet && kendo.spreadsheet.SheetEditor) {
        kendo.spreadsheet.SheetEditor.fn.activate = function (options) {
            var viewElement = this.view.element, viewWidth, scrollerElement, scrollbarWidth;
            this._active = true;
            this._rect = options.rect;
            this._range = options.range;
            this.cellInput.position(options.rect);
            this.cellInput.resize(options.rect);
            this.cellInput.tooltip(options.tooltip);
            this.cellInput.activeCell = this.barInput.activeCell = this._range.topLeft();
            this.cellInput.activeSheet = this.barInput.activeSheet = this._range._sheet;
            if (viewElement) {
                viewWidth = viewElement.width();
                scrollerElement = viewElement.find('.' + kendo.spreadsheet.View.classNames.scroller)[0];
                scrollbarWidth = scrollerElement.offsetWidth - scrollerElement.clientWidth;
                this.cellInput.element.css('max-width', viewWidth - scrollbarWidth - this.cellInput.element.position().left + 'px');
            }
            this.trigger('activate');
            return this;
        }
    }
</script>

  

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:

 

 

 

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

1 2 3