Unplanned
Last Updated: 29 Sep 2022 07:43 by ADMIN

Bug report

Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.

Reproduction of the problem

Issue 1

  1. Open the Spreadsheet Index demo on a Microsoft Surface device.
  2. Click in a cell and try to drag the selection to select multiple cells

Issue 2
In the Spreadsheet Index demo select a column. Try to place the mouse in between columns for the icon to be changed and to will be able to resize the column.

Current behavior

Currently, the selection in the Spreadsheet could not be expanded to multiple cells and the columns could not be resized when the Spreadsheet is used on a Microsoft Surface device.

Expected/desired behavior

The Spreadsheet should allow selecting multiple cells and resizing columns when opened on a Microsoft Surface device.

Environment

  • Kendo UI version: 2022.2.510
  • jQuery version: x.y
  • Browser: [all ]
Unplanned
Last Updated: 09 Sep 2022 20:56 by Matouš
Created by: Matouš
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

Hi Team,

I'd like to request the functionality to allow cell configurations to be populated by database values by default.  For example, I'd like to have a value from the database populate the specific link configuration.

Thank you!

Unplanned
Last Updated: 06 Sep 2022 13:30 by Sam

Hi,

When editing a workbook with the Spreadsheet component, if a user switches from a worksheet to another, then moves the scrollbars, when switching back, although the active cell is adequately recovered, the scrollbars are not (the user experience is that they do not react to worksheet switching).

Is this behavior planned to be changed? Is there a workaround?

Best

Unplanned
Last Updated: 06 Sep 2022 12:14 by Sam

Currently, when the "Custom format" button in the Spreadsheet is clicked, the available predefined formats that can be applied to a cell appear as demonstrated in the below screenshot. These predefined options don't change if you set a specific Kendo UI culture. 

It will be a very useful feature to be able to change the predefined custom formats. Also, it will be nice if the custom formats in the Spreadsheet can be set based on the selected Kendo UI culture. 

In Development
Last Updated: 02 Sep 2022 09:32 by ADMIN
Created by: Jose
Comments: 1
Category: Spreadsheet
Type: Bug Report
1

Bug report

The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.

Reproduction of the problem

Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.

Expected/desired behavior

If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.

Environment

  • Kendo UI version: 2022.2.802
  • jQuery version: All Supported
  • Browser: all
In Development
Last Updated: 02 Sep 2022 08:48 by ADMIN

Bug report

Dates and times entered (or pasted) in the spreadsheet are incorrectly parsed and do not respect the specified format. For example, dd.MM.yyyy HH:mm becomes MM.dd.yyyy HH:mm. The issue is replicated even if a culture is set.

Reproduction of the problem

  1. Open the Dojo
  2. Add the following date in Excel file and paste it in the Spreadsheet - 10.01.2022 09:00

Current behavior

The Spreadsheet does not parse the dates correctly.
10.01.2022 09:00 (january 10th) becomes 01.10.2022 09:00 (october 1st)
13.01.2022 09:00 is not affected by this issue.
10.01.2022 (january 10th, without time) is not affected by this issue.

Expected/desired behavior

Spreadsheet should parse the dates as they are. Copy dates such as 10.01.2022 09:00 should remain 10.01.2022 09:00 without switching the month and date values

Environment

  • Kendo UI version: 2022.2.621
  • jQuery version: x.y
  • Browser: [all ]
Completed
Last Updated: 06 Jul 2022 11:37 by ADMIN
Release 2020.R2.SP.next
Created by: Imported User
Comments: 8
Category: Spreadsheet
Type: Feature Request
44
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.
Completed
Last Updated: 16 Jun 2022 13:05 by ADMIN
Release 2022.R2
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
7
Dear Concerned,

1. Open https://dojo.telerik.com/IjasAbeC/11

2. Check split button is not prefixed with a separator, where as all other buttons comes with prefixed separator

It seems a bug, please provide a fix.
Unplanned
Last Updated: 16 Jun 2022 12:42 by John

Currently, when a custom button is configured in the Spreadsheet toolbar a separator is added before the button. I would like to have an option to configure whether such a separator is to be rendered or not.

I would like to avoid adding custom styles for hiding unneeded separators, which is needed with the current implementation (Dojo). 

 

In Development
Last Updated: 13 Jun 2022 12:47 by ADMIN

Bug report

Spreadsheet throws error when opening a xlsx file containing diagonal borders.

Reproduction of the problem

  1. Try to open a xlsx file, containing a cell with diagonal borders:
    image
    Sample File:
    DiagonalBorderTest.xlsx

Current behavior

Spreadsheet crashes and throws an error Uncaught TypeError: Cannot set property 'color' of undefined

Expected/desired behavior

The file should open.

Environment

  • Kendo UI version: 2021.1.330
  • Browser: [all]
Unplanned
Last Updated: 08 Jun 2022 12:52 by serge
Created by: Doron Naveh
Comments: 1
Category: Spreadsheet
Type: Feature Request
16
 add search functionality to the Spreadsheet.
Unplanned
Last Updated: 07 Jun 2022 13:26 by Jose

Bug report

When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.

Reproduction of the problem

  1. Open the Dojo example.

Current behavior

The bottom border and the right border are split with a white line in the middle.

Expected/desired behavior

The border should appear entirely filled with the selected color.

Environment

  • Kendo UI version: 2022.2.510
  • Browser: [all ]
Completed
Last Updated: 25 May 2022 11:43 by ADMIN
Release 2022.R2.SP.next

Bug report

When defaultCellStyle is used the configured font is applied to the cells in the Spreadsheet. However, the font is not applied when adding new rows.

Reproduction of the problem

  1. Open the Dojo.
  2. Enter some text in the cells
  3. Insert a new row
  4. Enter text in the newly inserted row.

Current behavior

The configured font in the defaultCellStyle is not taken into account. The font in the newly inserted row is Arial 12, while in the example it should be 'Courier New' 18.

Expected/desired behavior

The font configured by using the defaultCellStyle option should be applied to all cells in the Spreadsheet, even if inserted after initialization.

Environment

  • Kendo UI version: 2022.1.412
  • Browser: [all ]
Unplanned
Last Updated: 19 May 2022 10:05 by George

Bug report

Hyperlinks in a Spreadsheet cell do not work mobile devices.

Reproduction of the problem

  1. Open this example on a mobile device - https://dojo.telerik.com/ahixOKep
  2. Try to click on the links in the Product column.

Current behavior

The link in the cell does not work.

Expected/desired behavior

The link should work

Environment

  • Kendo UI version: 2022.2.510
  • Browser: [all]
Completed
Last Updated: 16 May 2022 12:46 by ADMIN
Release 2022.R2.SP.next
Created by: Stephen
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

Hi, I'm using the spreadsheet control and i'm having an issue with date columns.

When I enter a valid date, it works fine.

but when I enter an empty date (clicking delete on date column, or emptying out the contents)

the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]

obviously, this is incorrect, and it should store the value as NULL.

it happens regardless of whether the schema/model has nullable=true.

If I manually modify the dataItem via JS, it stores it correctly as null. 

I have a dojo demo set up which replicates the issue.

https://dojo.telerik.com/oFowivUN

 

Steps:

  1. select the ItemDate column of the first row in the spreadsheet
  2. type in a valid date (e.g. 1/1/2020)
  3. Click View ItemDate button (It should show the correct date)
  4. Select the ItemDate column and empty it out (e.g. click delete)
  5. Click View ItemDate button. (it should now show the incorrect date!)

Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.

Thanks

Completed
Last Updated: 16 May 2022 12:41 by ADMIN
Release 2022.R2.SP.next

Bug report

When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.

Reproduction of the problem

  1. Go to the Basic Usage example - https://demos.telerik.com/kendo-ui/spreadsheet/index
  2. Enter "SS0012" as value in a random cell.
  3. Grab the handle at the bottom right of the cell and drag down.

Current behavior

The value entered for the cells below is SS13, SS14 etc.

Expected/desired behavior

The value entered for the cells should be SS0012, SS0013 etc.

Environment

  • Kendo UI version: 2021.3.914
  • Browser: [all]
Completed
Last Updated: 12 May 2022 12:26 by ADMIN
Release 2022.R1.SP2
Created by: David M
Comments: 7
Category: Spreadsheet
Type: Feature Request
35
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.
Unplanned
Last Updated: 06 May 2022 20:29 by Jocelyn

Reproduction of the problem

Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource

And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve

Current behavior

The first added cell value (or row) is removed when the user deletes an empty row.
If the ID is entered, the result is even stranger:
https://www.screencast.com/t/osmVOiY7al

Expected/desired behavior

It should behave and function like Excel. I think with local/static binding there are no issues.

Unplanned
Last Updated: 19 Apr 2022 13:26 by sitefinitysteve
Created by: sitefinitysteve
Comments: 0
Category: Spreadsheet
Type: Feature Request
0
The isValid() method should check for any validation errors on the Sheet. It should return true/false value.
Unplanned
Last Updated: 08 Apr 2022 08:34 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently, the '@'  Implicit intersection operator could not be used in the Spreadsheet formula (Example: =VLOOKUP(@$G:$G,$C:$D,2, FALSE)). Also, it could not be imported from an Excel file as the result is '#N/A!'. Please add support for the '@' operator, so it could be used in the Kendo UI for jQuery Spreadsheet.
1 2 3 4 5 6