Completed
Last Updated: 25 Jan 2024 14:10 by ADMIN

Bug report

Reproduction of the problem

Reproducible in the demos:

  1. Create a second sheet.
  2. Select the new sheet ("Sheet1") and scroll the horizontally to column U. Add a value to the U1 cell.
  3. Select the first sheet ("Food Order").
  4. Select A17 and enter the following value: =SUM(C5,
  5. Select "Sheet1" and try to navigate to U1 either through the keyboard or through scrolling the sheet.

Current behavior

A popup with an error message appears.

Expected/desired behavior

The user should be able to navigate to the desired cell, in order to add it as a reference to the formula.

Environment

  • Kendo UI version: 2021.2.511
  • jQuery version: x.y
  • Browser: [all]
Completed
Last Updated: 10 Jan 2024 14:18 by ADMIN
Release R1.2024-Increment.2(31.Jan.2024)
Created by: José Carlos
Comments: 1
Category: Spreadsheet
Type: Bug Report
1

Bug report

Reproduction of the problem

Dojo example: https://dojo.telerik.com/UWicoqeJ

  1. Focus an empty cell and paste the following formula: =IF(AND(H4-I4>=B4, H4+I4<=C4), "OK", "NO OK")

Current behavior

The cell will display: "NO OK"

Expected/desired behavior

The cell should display: "OK" as it does in Excel.

Environment

  • Kendo UI version: 2022.3.1109
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 30 Jun 2023 07:01 by star
Currently, the diagonal borders are lost on server importing or exporting a file that has diagonal borders applied to cells.
Completed
Last Updated: 12 Jun 2023 13:05 by ADMIN
Release R2.2023-Increment.3(7.June.2023)

Bug report

When dragging a cell to edit other cells in the Spreadsheet, the Change event of the DataSource is not fired.
The issue is a regression starting with Kendo - 2022.2.621

Reproduction of the problem

  1. Open the following dojo:
    https://dojo.telerik.com/OyAmimaH/2

Try to edit multiple cells by dragging a cell.

Current behavior

The Change event is not triggered.

Expected/desired behavior

The Change event should be fired.

Environment

  • Kendo UI version: 2022.2.621
  • Browser: [all ]
Completed
Last Updated: 31 Jan 2023 07:00 by ADMIN

Bug report

Reported in Ticket ID: 1529288

Reproduction of the problem

Create an MVC application:

View:

@{
	ViewBag.Title = "Home Page";
	string sfile = System.IO.Path.Combine(Server.MapPath("~"), "File1.xlsx");
}

@Html.Kendo().Spreadsheet().Name("spreadsheet"))

<br />	
<br />	
<button class="k-button k-primary" id="export" onclick="ExportExcel()">Export Spreadsheet content</button>
<script>
    function ExportExcel() {
        var spread = $('#spreadsheet').getKendoSpreadsheet();
        var data = JSON.stringify(spread.toJSON());

        var fd = new FormData();
        fd.append('wbook', data);
        fd.append('sfile', "File1.xlsx");

        $.ajax({
            url: "@Url.Action("SaveFileExcel", "Home")",
            data: fd,
            contentType: "application/x-www-form-urlencoded",
            processData: false,
            contentType: false,
            type: "POST",
            statusCode: {
                200: function (xhr, status, err) {
                    console.log('File exported!');
                },
                500: function (xhr, status, err) {
                    console.log('Internal Server Error!');
                }
            }
        });
    }
</script>

Controller:

[HttpPost]
public ActionResult SaveFileExcel(string wbook, string sFile)
{
    var workbook = Telerik.Web.Spreadsheet.Workbook.FromJson(wbook);
    string physicalPath = Path.Combine(Server.MapPath("~/"), sFile);
    //workbook.Save("C:/inetpub/wwwroot/" + sFile
    workbook.Save(physicalPath);
    return new EmptyResult();
}
  1. Add the application to a Docker container.
  2. Place a breakpoint in the SaveFileExcel action.
  3. Run the app and click the button below the Spreadsheet.

Current behavior

The Save method throws System.ExecutionEngineException

Expected/desired behavior

The file is saved.

Environment

  • Kendo UI version: 2021.2.616
  • jQuery version: x.y
  • Browser: [all]
Declined
Last Updated: 19 Jan 2023 13:47 by ADMIN

Bug report

When we want to add a formula in a given cell in the Spreadsheet, we double-click it and enter the "=" in it as an identifier that a formula definition will follow. If we want to include in the formula a cell that is not inside the visible range of the Spreadsheet, we scroll to that cell and select it. In Internet Explorer, if we scroll to a given cell using the arrows of the Spreadsheet's scrollbar the "double-clicked" cell becomes just a selected one and the "=" sign is converted to a string value.

Reproduction of the problem

  1. Open this Dojo example in Internet Explorer 11
  2. Select the A1 cell and enter "=" in it.
  3. Press the "down" direction arrow of the Spreadsheet trying to reach cell A50.
  4. With the first click on the arrow, the A1 cell is no more "double-clicked" and the "=" inside it is converted to a string

Current behavior

When building a formula in a given cell and trying to navigate to a cell using the scrollbar, this usage stops the formula building and converts the "=" into a string.

Expected/desired behavior

When a user creates a formula for a given cell, they should be able to navigate through the Spreadsheet using its scrollbars.

Environment

  • Kendo UI version: 2019.2.619
  • jQuery version: x.y
  • Browser: IE 11.950.17134.0
Completed
Last Updated: 25 May 2022 11:36 by ADMIN
Release 2022.R2.SP.next

Bug report

Reproduction of the problem

Dojo example.

  1. Open Company filter menu.
  2. Uncheck All and check only "Excella". Click Apply.
  3. Open the same filter menu and check "Complete Tech". Click Apply.
  4. Click the "Undo" button

Current behavior

All filters are cleared.

Expected/desired behavior

The Spreadsheet shows Company filtered by value "Excella". This is the behavior when different columns are filtered consecutively and then "Undo" is clicked.

Environment

  • Kendo UI version: 2021.2.616
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 23 May 2022 08:39 by David
Created by: David
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Implement an option to format a range of cells as table using predefined table formats, similar to the Excel's "Format as table" functionality.
Unplanned
Last Updated: 30 Sep 2021 08:16 by Brynley

Bug report

Reproduction of the problem

If you want to have only some of the default tools, you cannot do that with the Spreadsheet wrapper.

  1. Declare the tools you want, e.g.,
.Toolbar(t =>
{
	t.Home(h =>
	{
		h.ExportAs();
	});
})

Current behavior

All the tools are displayed.

Expected/desired behavior

Only the ExportAs tool is displayed.

Environment

  • Kendo UI version: 2021.3.914
  • jQuery version: x.y
  • Browser: [all ]
Unplanned
Last Updated: 28 Jul 2021 17:19 by Akash

Bug report

Reproduction of the problem

Dojo: https://dojo.telerik.com/iMuMedOd

  1. Focus a cell and use one of the following shortcuts: Ctrl + B (Bold), Ctrl + I (Italic)

Current behavior

A js exception is thrown:
Uncaught TypeError: Cannot read property 'click' of undefined
kendo.all.js:168073

Expected/desired behavior

With the toolbar disabled the shortcuts should do nothing. There should be no exceptions.

Environment

  • Kendo UI version: 2021.2.616
  • jQuery version: x.y
  • Browser: [all ]
Unplanned
Last Updated: 11 Jun 2021 13:11 by ADMIN
Created by: Moishy
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Create a Telerik.Web.Spreadsheet NuGet package for UI for ASP.NET MVC.
Completed
Last Updated: 10 Jun 2021 06:31 by ADMIN
Release 2019.R3.SP1
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

Regression introduced in R3 2019.

Reproduction of the problem

Open this Spreadsheet demo. Even though the Toolbar configuration is set to false, it is not hidden. This applies only for ASP.Net Core and ASP.Net MVC.

Current behavior

The Toolbar is visible when set to false.

Expected/desired behavior

The Toolbar should be hidden.

Environment

  • Kendo UI version: 2019.3.917
  • Browser: [all]
Duplicated
Last Updated: 02 Mar 2021 10:50 by ADMIN

When the Scheduler control is bound a datasource that includes a Boolean value/column in the database the Spreadsheet column presents this as "true" or "false" strings.

 

Allow alternate strings such as  "Yes" or "No" to represent a Boolean. Would of course need to update the datasource appropriately on Edit of a cell that uses this presentation.

Unplanned
Last Updated: 23 Feb 2021 15:45 by ADMIN
Created by: Peter
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
At present, opening csv files directly from the "Open" tool in the Spreadsheet's toolbar is not possible. Only xlsx files are allowed.
Completed
Last Updated: 03 Feb 2021 15:05 by ADMIN
Release 2021.R1.SP.next
Created by: Heiko
Comments: 1
Category: Spreadsheet
Type: Bug Report
0
The toolbar for "Insert" on Spreadsheet component has "Add column left" twice. "Add column right" is missing. The bug is found in UI for ASP.NET MVC and UI for ASP.NET Core, but not in UI for jQuery.
Unplanned
Last Updated: 12 Jan 2021 10:34 by ADMIN

Currently, only the List and Number validation rules are supported when using Workbook.ToDocument();

 

It happens when the type of validation is text or custom 

for example:

If I saved :

"validation": {
                "type": "reject",
                "comparerType": "custom",
                "dataType": "custom",
                "from": "AND(LEN(A2)<3)",
                "showButton": true,
                "allowNulls": true
              }

I get back:

"validation": {
                "type": "reject",
                "comparerType": "equalTo",
                "dataType": "number",
                "from": "=AND(LEN(A2)<3)",
                "to": "\"=\"",
                "allowNulls": true
              }

It happens also when the comparer type is text - it saves it as a number

Also when I use the create validator with your UI and choose a custom formula it can't be saved because the compare type is null. As a result, I must define manually the custom validator

 

 

Declined
Last Updated: 04 Dec 2020 09:32 by ADMIN
Created by: Heiko
Comments: 5
Category: Spreadsheet
Type: Bug Report
0

Tested on demo-page. The export of an Excel-file containing defined names with a period such as "test.name" will result in an error.

Steps to reproduce:

  1. Create an Excel-file that has a defined name like "test.name"
  2. Open the file on the demo page
  3. Click on any of the "Save as..." buttons
  4. An error page is shown

 

Declined
Last Updated: 18 Nov 2020 16:11 by ADMIN
Created by: Heiko
Comments: 1
Category: Spreadsheet
Type: Bug Report
0
The strings for all toolbar-buttons in spreadsheet component are only available in en-US and missing in all other languages.
Unplanned
Last Updated: 30 Oct 2020 08:05 by ADMIN
Created by: Rakesh
Comments: 2
Category: Spreadsheet
Type: Feature Request
1

Hi There,

I am facing one issue in kendo spreadsheet onchange event.

Suppose I have applied formula on one cell A1 and formula is =SUM(B1:B3)

Now one change of values in B1 to B3 on change event gets fired but whenever cell A1 values gets updated i.e. on entering value in B1 to B2, on change event doesn’t get fired.

How can I make onchange event fire for formula cell.

 

Thank you,

Rakesh

Unplanned
Last Updated: 07 Oct 2020 07:44 by ADMIN
The Spreadsheet does not support cell formatting with exponent (scientific) notation.  For example, a cell currently displays a value as 0.0000000177 while the formula bar displays it as 1.77e-8. When working with scientific data the ability to format a cell value using exponent (scientific) notation would be an extremely valuable feature.
1 2