In Development
Last Updated: 23 May 2022 08:59 by ADMIN

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]
Unplanned
Last Updated: 16 May 2022 11:15 by John Tobin

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 ]
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.
Completed
Last Updated: 05 Apr 2022 09:19 by ADMIN
Release 2022.R1.SP.next

Bug report

When pasting content to a Spreadsheet that has only one column(columns: 1), the data is not pasted in the targeted cell and a JS error appears in the browser's console.

The issue appears only in scenarios where the columns configuration is set to 1.

  • The reported behavior is a regression bug introduced in 2021 R1 SP1 - version 2021.1.224
    Here is a Dojo example with 2021 R1 in which the described above issue is not replicable.

Reproduction of the problem

  1. Open this project and run it
  2. Copy random text
  3. Select a random cell(do not double click the cell) and press Ctrl + V to paste the copied content

Current behavior

No data is pasted in the selected cell and the below error appears in the console:
image

Expected/desired behavior

The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.

Environment

  • Kendo UI version: 2022.1.301
  • jQuery version: x.y
  • Browser: [all]
Unplanned
Last Updated: 28 Mar 2022 14:21 by ADMIN

Hi Admin,

 

 I made the DIV where I had the Spreadsheet widget in full screen mode by: document.fullscreenElement.  I have some validations configured in the spreadsheet.  Apparently, in full screen mode, the prompt opens behind it.  Is there a way I can do an "appendTo" to the validation prompt?

Please advise.

Thank you very much.

 

Best Regards,

Jenny

Completed
Last Updated: 11 Mar 2022 13:33 by ADMIN
Release 2022.R1.SP.next
Created by: Chris
Comments: 2
Category: Spreadsheet
Type: Bug Report
0

Hi

We have noticed that spreadsheet filter box (click on filter down arrow) didnt appear when clicked on certain environment (win10, surface pro 7), but works on others.

What happens is you click the down arrow, a scroll bar appears on rhs, which i think is suggesting the popup has positioned soemwhere off visible area.

This happens in each browser - edge (94.0.992.50 ), chrome (95.0.4638.54 ) and firefox (93.0). Plug ins disabled.   Windows 10.0.19043

 

Wondered if about high res screens or display settings?

 

Recreated with kendo demo 

https://dojo.telerik.com/aruPOzEx

 

then tried each kendo version going back in time, and basically version 2020 R2 SP1 it worked (see attached working.. shot), and anything since it fails. 

In the shots i am clicking on company filter arrow.   the failversion-before is before i click, failversion-after is after click - where you can see extra vertical scrollbar

 

Regards

Chris

Completed
Last Updated: 10 Mar 2022 16:26 by ADMIN
Release 2022.R1.SP.next

Bug report

Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.

Reproduction of the problem

  1. Open this Dojo example - https://dojo.telerik.com/UwexICot/4

Current behavior

The value of the B1:B2 merged cell is not displayed.

Expected/desired behavior

The value of the B1:B2 merged cell should be displayed.

Environment

  • Kendo UI version: 2022.1.119
  • Browser: [all]
Completed
Last Updated: 10 Mar 2022 15:46 by ADMIN
Release 2022.R1.SP.next

Hello,

When spreadsheet cells are merged and have comment, it's shown only when hovering over first cell and not shown when hovering over other cells of the merged group of cells

Example to reproduce on dojo - https://dojo.telerik.com/@Andrii/uHINuvIh

On the cell A1 there is a comment, merged cells are A1:G1, comment is shown only when hover over cell A1.

Unplanned
Last Updated: 09 Mar 2022 10:34 by George
Created by: do van
Comments: 3
Category: Spreadsheet
Type: Feature Request
23

Currently, when working on a mobile device, the Spreadsheet doesn't have all the functionalities available when working on a desktop machine.  

Providing support for the merge cell, multi-cell selection  & context menu opening when working on a mobile device will be very useful for the Spreadsheet. 

 

 
Unplanned
Last Updated: 01 Mar 2022 11:49 by ADMIN
Created by: Jeffrey
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hello

When we have filtered rows in a spreadsheet (some rows are hidden) and we copy a single cell and paste into a range containing the hidden rows....

The spreadsheet copies the value into all cells in the range including those that are hidden.  This is not the same functionality as Excel.

That said, is the any way to skip hidden cells in the paste range?

Is there a way to override the Kendo past function to do this?  Can you provide an example?

Thank you

Jeffrey Suffet

 

Declined
Last Updated: 21 Feb 2022 13:05 by ADMIN

### Bug report

When the property "useCultureDecimals" is enabled in a culture where the decimal separator is the comma, the function Text() does not format numbers correctly.

### Reproduction of the problem

1. Set a culture where the decimal separator is the comma (i.e. "da-DK");

2. Create a Spreadsheet and enable the property "useCultureDecimals";

3. Enter a number with a decimal separator comma (i.e. "0,1141");

4. Format the cell by using the Text() function ( =TEXT(A1; "##0,00%") );

5. The number is not formatted properly - "011%"

A Dojo sample for reproduction: https://dojo.telerik.com/AsiLiKil/12


### Expected/desired behavior
"0,1141" should be formatted as "11,41%" as in Excel.

### Environment

* **Kendo UI version: 2021.3.914
* **jQuery version: 1.12.4
* **Browser: [all]

Unplanned
Last Updated: 14 Feb 2022 07:57 by ADMIN
Created by: Aaron
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hi there,

I'd love the ability to specify regex validation for the spreadsheet component. I saw a forum post (https://www.telerik.com/forums/spreadsheet-regex-validation) someone else had made relating to this, but couldn't find a feature request made based off of it.

(taken from the post) Ideally it'd look something like this:


var columnSens = spreadsheet.activeSheet().range("A2:A10");

columnSens.validation({
  dataType: "custom",
  from: 'REGEX("^(()|((?=.*[a-z])(?=.*[A-Z])(?=.*\d)(?=.*[^\da-zA-Z]).{8,60}))$")',
  type: "warning",
  allowNulls: true,
  titleTemplate: "Invalid Password",
  messageTemplate: "Passwords must be between 8 - 60 characters long and contain the following: 1 number, 1 uppercase letter, 1 lowercase letter, and 1 special (non letter or number) character."
});

Completed
Last Updated: 10 Feb 2022 13:20 by ADMIN
Release 2022.R1.SP.next

Bug report

When trying to select multiple cells in Spreadsheet, an error "n._ref.height is not a function" occurs.

Regression introduced with R3 2021.

Reproduction of the problem

  1. Open this demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
  2. Try to select multiple cells using CTRL.

Current behavior

An error "n._ref.height is not a function" occurs and cells are not selected.

Expected/desired behavior

No error should occur and cells should be selected.

Environment

  • Kendo UI version: 2022.1.119
  • Browser: [all]
Completed
Last Updated: 20 Jan 2022 12:37 by ADMIN

Currently, after export to excel and opening the exported file again in Spreadsheet, the row heights for rows with predefined height change. The above could be easily observed on the Index demo:

* initially, the height of the top row is set to 70px;

* export the Spreadsheet to Excel;

* after re-importing the above file, the height of the first row "Invoice #52" becomes 81px without any apparent reason.

1 2 3 4 5 6