Completed
Last Updated: 24 Jun 2022 13:09 by ADMIN
Completed
Last Updated: 22 Jun 2022 10:48 by ADMIN
ADMIN
Created by: Ivan Danchev
Comments: 1
Category: Spreadsheet
Type: Bug Report
1

			
Completed
Last Updated: 11 Mar 2022 19:40 by Beth
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);
}

 

 

 

 

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.

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>

  

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: 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: 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

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: 24 Apr 2020 10:02 by ADMIN
There are no issues when the user makes changes to the imported Blank XLSX document.
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);


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?
Completed
Last Updated: 18 Apr 2019 07:43 by ADMIN
If you put a radspreadsheet inside a radtabstrip with multipage, the controls do not render properly.

In my scenario, I have a tabstrip embedded within a tabstrip, and a grid in the nested tabstrip.  That works fine.  Once you put a spreadsheet control in the multipage, the controls do not render properly. 

However, I was able to reproduce the results with the first scenario above, which is the most simple.
Unplanned
Last Updated: 17 Apr 2019 14:23 by ADMIN
Created by: JF
Comments: 0
Category: Spreadsheet
Type: Bug Report
0
When I load the radspreadsheet from an excel file, the foreground color is not loaded.

A workaround is to use the Kendo Spreadsheet widget directly which imports fore color: https://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export

Repro steps 
    go to https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/import-export/defaultcs.aspx
    add some text with specific fore color
    save the excel file
    import the excel file

Expected: there is no change

Actual: the fore color is not imported. Also, font size changes, but see the related item for that
Unplanned
Last Updated: 17 Apr 2019 14:21 by ADMIN
ADMIN
Created by: Marin Bratanov
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

The default font size on the client is not saved explicitly on the Excel file, so the Excel defaults take over (11px Calibri), so upon subsequent import all cells will have that font. Steps to repro: go to https://demos.telerik.com/aspnet-ajax/spreadsheet/examples/import-export/defaultcs.aspx export the file import the file Expected: nothing changes Actual: all cells are 11px Calibri

Workaround: Set a default font when the cell font is null

 

public override void SaveWorkbook(Workbook workbook)
{
    string path = "C:\\path-to-output.xlsx";
     
    for (int i = 0; i < workbook.Sheets.Count; i++)
    {
        for (int j = 0; j < workbook.Sheets[i].Rows.Count; j++)
        {
            for (int l = 0; l < workbook.Sheets[i].Rows[i].Cells.Count; l++)
            {
                string fontFamily = workbook.Sheets[i].Rows[i].Cells[l].FontFamily;
                workbook.Sheets[i].Rows[i].Cells[l].FontFamily = !string.IsNullOrEmpty(fontFamily) ? fontFamily : "Courier New";
 
                double? fontSize = workbook.Sheets[i].Rows[i].Cells[l].FontSize;
                workbook.Sheets[i].Rows[i].Cells[l].FontSize = fontSize.HasValue ? fontSize : 12;
            }
        }
    }
    workbook.Save(path);
}

 

Completed
Last Updated: 17 Apr 2019 08:29 by ADMIN
Created by: JF
Comments: 3
Category: Spreadsheet
Type: Bug Report
0
The lines shifts badly after line 10 

You think you are on line 17  but the cursor is on line 16.  Very annoying bug for those using this control.  Please fix and give us an update.

Look the attached file.
1 2