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 ]
Unplanned
Last Updated: 28 Oct 2020 05:23 by G.K. Raju
Created by: Dimitar
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
Provide support for zooming the Spreadsheet's cells grid similar to the one provided by Excel.
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,

Unplanned
Last Updated: 27 Oct 2020 14:04 by ADMIN
Created by: G.K. Raju
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Hi Team,

I'd like to request a way to manipulate a large amount of cell groups in the Kendo UI Spreadsheet without decreasing performance.  For example, I'd like to be able to merge/unmerge and change font size to multiple specific cell groups.  I understand changing multiple DOM elements at the same time can cause sluggishness, but maybe there's a way to reduce the time. Currently, it's taking a long time to completely load.  

Thank you for investigating.

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: 29 Sep 2020 10:08 by ADMIN
Created by: Shadi
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Since the Spreadsheet does not support macros, implement error handling in the widget that notifies the user if they attempt to load a file that contains a macro. For more details see: Ticket ID: 1486172
Completed
Last Updated: 17 Sep 2020 17:30 by ADMIN
Release 2020.R2.SP.next
Created by: Imported User
Comments: 6
Category: Spreadsheet
Type: Feature Request
43
It would be great if you could put images to cells using html. E.g.: <img src="..."> would result in an image in the cell.
Unplanned
Last Updated: 24 Aug 2020 11:40 by ADMIN

Working with numbers like 0.000001056  in a Spreadsheet that is bound to a dataSource, after saving the dataSource, the mentioned number will be converted to an exponential format. 

The current feature request is about preventing the format changing after saving decimal numbers.

It will be very useful if we can use the Spreadsheet with dataSource binding but keep the decimal numbers as such, not converting them to exponential expressions.

 

Unplanned
Last Updated: 18 Aug 2020 06:27 by ADMIN
Created by: Owen
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

In the Spreadsheet control for jQuery it is possible to set cells as read-only through the use of the Enable property.

However, on calling saveAsExcel() these cells are editable. This means as a developer it is then necessary to create both the spreadsheet JSON (for Kendo Spreadsheet) as well as another spreadsheet class to export to Excel.

Could you please map the Cell.Enable property to the setting of Excel cells as disabled/read-only. Thanks 👍

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: 21 Jul 2020 07:16 by ADMIN
Created by: Dhruven
Comments: 1
Category: Spreadsheet
Type: Feature Request
4

When I use this formula 

=HYPERLINK("mailto:"&B4&"?subject=“& B5 & “&body=“ & B6,", "test")

in the excel, I am able to click on the link which opens up my mail client with compose new email window and also populates To, Subject and Body of the email from cells B4, B5, B6 respectively.

But currently, HYPERLINK formula does not support "mailto:" functionality in Kendo UI spreadsheet. I would love to see this with kendo UI spreadsheet. 

For more details you can see the discussion on the forums here

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: 08 Jul 2020 07:55 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be useful to have a method capable of executing a formula without assigning it to a cell in the Spreadsheet.
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]
Unplanned
Last Updated: 17 Jun 2020 09:41 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

Need:

Extract only the values for all Spreadsheet cells. These extracted values can be sent back to server (with minimum size) as server only needs data on each sheet. On other information required like references, formulas, images, colors etc.

 

Possible Approach:

On click of save or a separate button, which will generate a low size data file (having sheet name, cell index and value), which we can send to server.

 

It will save network traffic and also no complex parsing needed at server side to fetch data.

 

Unplanned
Last Updated: 11 Jun 2020 11:21 by Naveen
Created by: David M
Comments: 5
Category: Spreadsheet
Type: Feature Request
25
Use case:
My app doesn't know how many rows of data the excel spreadsheet will be prior to upload.  I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others.  The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition.  

As a workaround, I'm destroying and reloading the widget instance after the initial load.
1 2 3 4 5 6