In Development
Last Updated: 29 Oct 2020 08:14 by ADMIN
Scheduled for 2020.R3.SP.next

Bug report

When multiple cells are merged in the Spreadsheet the DatePicker is not always rendered at the correct position.

Reproduction of the problem

  1. Open the Demo
  2. Merge the cells vertically for rows 6-20.
  3. Reduce the browser size to set the scrollbars, so the Spreadsheet scrollbar to not be at its top position.
  4. Open the DatePicker.

Current behavior

The DatePicker is not always entirely visible (screencast)

Expected/desired behavior

DatePicker should be visible

Environment

  • Kendo UI version: 2020.3.915
  • Browser: [all ]
Completed
Last Updated: 27 Oct 2020 14:22 by ADMIN
Created by: Naveen
Comments: 3
Category: Spreadsheet
Type: Bug Report
8

Dear Concerned,

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Select Column B11, click wrap text from Home toolbar.

3. Start typing in B11 & see cell editor keeps growing and goes beyond screen.

4. This is not user friendly, it should be same as Excel

5. Any alternative or quick fix would be appreciable

In Development
Last Updated: 27 Oct 2020 14:17 by ADMIN

Hello,

 

I have some problems with setting up correct Cell Validation for my use-case. I want to create a list validation which is going to have a numeric options instead of typical string values.

So in order to achieve that I created a following cell validation:


{
    dataType: "list",
    showButton: true,
    comparerType: "list",
    from: '{1,2,3,4,5}',
    allowNulls: true,
    type: "reject"
}

 

Everything works fine in the widget, but the problems starts when I want to Export the following spreadsheet to Excel format. I'm getting the following message when trying to open such file:

 

In the past I had a similar problem with the list validation (but for string values) (https://www.telerik.com/account/support-tickets/view-ticket/1381434)

There you suggested to create a validation using different format for "from" property. So I decided to change it from:

from: '{1,2,3,4,5}',

to

from: '"1,2,3,4,5"',

 

After that I can freely export the spreadsheet without any problems, but then my list is inserting string values instead of numeric ones, therefore this solution is not suitable for my use-case.


And my question is: Is there a possibility to create a Cell validation where I can put numeric values as a possible options without breaking the export process? 

 

Here's a example spreadsheet, which I used to reproduce this behavior: https://dojo.telerik.com/IfuMIbic

 

Best regards,

Completed
Last Updated: 21 Oct 2020 06:43 by ADMIN

Bug report

Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:

let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();

If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).

let dataURL = new kendo.ooxml.Workbook(data).toDataURL();

Reproduction of the problem

Dojo example.

  1. Click the "To Json" button above the Spreadsheet.
  2. Try to open the generated file in Excel.

Current behavior

The generated Excel file is corrupted

Expected/desired behavior

The generated Excel file is not corrupted

Environment

  • Kendo UI version: 2020.2.617
  • jQuery version: x.y
  • Browser: [all]
Completed
Last Updated: 13 Oct 2020 14:13 by ADMIN
Release 2020.R3.SP.next
Created by: Account Manager
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

There is no TypeScript definition for defineFunction and no custom functions can be created in TypeScript context using the approach demonstrated in this Custom functions article.

Reproduction of the problem

Try defining a new function using:
kendo.spreadsheet.defineFunction("Mask",mask).args(maskArgs)

Current behavior

The following error appears:

Propery "defineFunction" does not exist on type 'typeof spreadsheet'

Expected/desired behavior

There shouldn't be any errors

Environment

  • Kendo UI version: 2019.3.1023
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 11 Aug 2020 08:41 by Naveen

Bug report

Reproduction of the problem

Use the Events demo to reproduce, since the events are logged in the console: https://demos.telerik.com/kendo-ui/spreadsheet/events

  1. Add a new sheet
  2. Drag left the newly added sheet, to make it first
  3. Click "Invoice", hold down the mouse button and drag the Invoice sheet back to first place

Current behavior

The Invoice sheet is selected but the selectSheet event does not fire.

Expected/desired behavior

The selectSheet event fires

Environment

  • Kendo UI version: 2020.2.617
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 06 Aug 2020 08:18 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.

Reproduction of the problem

  1. Open our Spreadsheet demo in Chrome.
  2. Import the attached Spreadsheet.
  3. Open the Task Manager to check Chrome memory usage, and switch sheets to see the navigation speed.
  4. Open DevTools and check memory usage again. Note that switching sheets is also significantly slower.

Current behavior

Memory usage increased and slower sheet change.

Expected/desired behavior

Memory usage should not be increased and sheet navigation should not be slow.

Environment

  • Kendo UI version: 2020.2.619
  • Browser: [all]
Unplanned
Last Updated: 14 Jul 2020 07:25 by Naveen

Bug report

The AND formula, when used as part of an array formula, does not evaluate the whole array.

{=AND(A1:D1="")} would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE) would return FALSE if value is entered in any cell in range A1:D1

Reproduction of the problem

  1. Run this dojo
  2. Select cell E1, press F2 to edit formula and press Ctrl+Shift+Enter to enter as an array formula

Current behavior

  1. Enter a value in cell B1 - Array formula evaluates as TRUE, Non-array formula as FALSE
  2. Only if a value is entered in A1 the Array formula will evaluate as FALSE

Expected/desired behavior

Array formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.

Environment

  • Kendo UI version: 2020.2.617
  • Browser: [all]
Unplanned
Last Updated: 25 Jun 2020 07:12 by Naveen

Bug report

When using a custom cell editor in the Spreadsheet along with keyboard navigation value selection is not limited to the cell with the custom cell editor

Reproduction of the problem

  1. Run the Custom Editors Demo
  2. Click on cell B2 and open the list popup with available values for selection
  3. Press the right arrow key on the keyboard
  4. Select a value from the list
  5. The selected value will be applied to cell C2

Current behavior

The selected value is applied to cell other then the one using the custom cell editor

Expected/desired behavior

The selected value should be applied only to the cell with the custom cell editor

Environment

  • Kendo UI version: 2020.2.617
  • Browser: [all]
Unplanned
Last Updated: 22 Jun 2020 18:18 by Vamsi
Created by: Vamsi
Comments: 0
Category: Spreadsheet
Type: Bug Report
1

Bug report

Reproduction of the problem

Reproducible in this demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource

  1. Scroll down to row 78
  2. Focus A78 and drag to E78. Copy the data
  3. Paste over the empty 79 row's first cell
  4. Press Ctrl + Z to undo the changes.
  5. Open the browser's dev tools network tab and press the "Save" button above the Spreadsheet.

Current behavior

The data cleared by the "undo" shortcut is saved and sent to the server

A different behavior is exhibited if the data is pasted over the row header instead of the row's first cell. Follow the same steps, but on step 3. instead of pasting over the first cell, paste the data over the row 79 header. After undo and then clicking "Save", the fields have null values.

Expected/desired behavior

No data is sent with the request

Environment

  • Kendo UI version: 2020.2.617
  • jQuery version: x.y
  • Browser: [all]
Completed
Last Updated: 24 Mar 2020 17:11 by ADMIN
Release 2020.R1.SP.next

Bug report

The select method of the range in the Spreadsheet component throws an error when we have a selected cell in the visible area of the component and try to select a range that is outside of this visible area.
The bug is replicable both when the range is passed as exact cells or row-column pair:

  • sheet.range(3,2,3,3).select();
  • sheet.range("C4:E6").select();

** This is a regression from the R3 2019 release

Reproduction of the problem

  1. Open this Dojo
  2. Scroll to row 70+ and select a random cell
  3. Press the "Select range" button

Current behavior

The following error appears in the browser's console
image

If you scroll to the top rows of the Spreadsheet there is a visual selection of the cells that are passed in the range

Expected/desired behavior

On "Select range" click the "C4:E6" cell range should be selected and the Spreadsheet should be automatically scrolled to this selection.

Here is a working demo: https://dojo.telerik.com/uRERUxOm

Environment

  • Kendo UI version: 2020.1.219
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 10 Mar 2020 09:51 by Naveen

Bug report

The Spreadsheet doesn't' load correctly Excel files which definition of the tag is a single cell, instead of a cell range.

Test files: test-2.zip

Reproduction of the problem

  1. Download the test-2.zip file and load the "test.xlsx" file in the Spreadsheet here.
  2. The file has data in the “AZ” and “BA” columns and once it is imported in the Spreadsheet the data from the “BA” column is imported in the “AX” column and the values in the AZ column are missing.
  • If the above file is saved in Excel it is correctly loading in the Spreadsheet. In the attached archive there is the “test-copy.xlsx” file which is the saved and correctly working one. Below is the structure of the two files. The one in red is from the "test.xlsx" file and the code in green is from the "test-copy.xlsx" file.

MicrosoftTeams-image

Current behavior

The The "test.xlsx" file is not loading correctly in the Spreadsheet and loses data

Expected/desired behavior

The "test.xlsx" file should load correctly in the Spreadsheet without losing data

Environment

  • Kendo UI version: 2020.1.219
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 04 Mar 2020 15:54 by Vasanth

Bug report

When the Spreadsheet is bound to a DataSource upon making multiple selections in the Spreadsheet and deleting the selected ranges a JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.

Reproduction of the problem

  1. Run the demo on DataSource binding
  2. Make random multiple selections
  3. Delete selection using the Delete key

Current behavior

A JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.

Expected/desired behavior

Upon an attempt to delete multiple selections a popup should be displayed with a warning that this operation is not supported, similar to trying Copy/Paste multiple selections.

Environment

  • Kendo UI version: 2020.1.219
  • Browser: [all]
Declined
Last Updated: 26 Feb 2020 15:15 by ADMIN
Created by: Paul
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

Bug in js\spreadsheet\numformat.js makeDateFormat

 

You appear to be using the wrong indices inside a nested loop.

if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {

Should be (switch i to j)

if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {

Getting error

Uncaught TypeError: Cannot read property 'type' of undefined
     at Object.<anonymous> (numformat.js:630)

 

Note: Version is actually 2018.3.1114 from npm

Unplanned
Last Updated: 26 Feb 2020 15:11 by ADMIN
Created by: CCAC
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

Spreadsheet saveAsExcel split is not a function error (kendo.all.js:3436) after upgrade to Kendo 2019.2.514.

Unplanned
Last Updated: 26 Feb 2020 15:07 by ADMIN
Created by: Sandeep
Comments: 3
Category: Spreadsheet
Type: Bug Report
0

Hi team,

In kendo spreadsheet if you disable any row by adding enable property to false and apply sort from data tab, then the disable row is changing based on the sort. instead of applying to particular row  it is applying to perticular range and while sorting the row items are changing. The cell properties are not applying there while sorting.

 

link for example: https://dojo.telerik.com/IkoJeMIz

 

please let me know if I am doing anything wrong here.

 

thanks.

Completed
Last Updated: 26 Feb 2020 14:10 by ADMIN

Hi,

 

I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).

When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.

Editing an empty row above this new row will modify one of the records created in this process.

Unplanned
Last Updated: 25 Feb 2020 15:27 by ADMIN
Created by: Abhinav
Comments: 3
Category: Spreadsheet
Type: Bug Report
3

1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.

2. Click on open button in the Toolbar of the spreadsheet.

3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.

4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.

5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.

 

Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?

Unplanned
Last Updated: 13 Feb 2020 14:04 by ADMIN

This is observed also in online demos:

Steps:

  1. Open demo
  2. Edit a cell and enter text
  3. Press Alt+Enter and enter more text
  4. Press Alt+Enter

    Result: the last letter of the row is transferred to the new row

Under Review
Last Updated: 12 Feb 2020 12:54 by ADMIN
Created by: Sandeep
Comments: 8
Category: Spreadsheet
Type: Bug Report
1

Hi Team,

I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please 

check the URL

https://dojo.telerik.com/

1 2 3