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 ]

I am using kendo spreadsheet binding to a datasource... very similar to the demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource

Is there a way to add a two row header while binding to a data source?  For example, my first row would be a merged cell spanning all columns and would contain some text.  I can see how to do two row headers and to merge cells.. but it doesn't work when the spreadsheet is bound to a datasource as it starts the data in row 2.... where I want row 2 to be my actual field name headers.  I don't see any options to fix that.

If there is no way to do that... is there a way to alter my header style?  For example, I want a column header to be

MY FIELD NAME HERE
additional text (smaller font and color)

I know in kendo grid there is headerTemplate... but this doesn't seem to be available in kendo spreadsheet.

Thank you.

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 ]

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 ]

The spreadsheet widget has no Polish localization.

Feel free to use those: https://github.com/telerik/kendo-ui-core/pull/5310

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 ]

Describe the bug
When the Spreadsheet has locked columns and columnWidth is set, but the width of the locked exceed the width of the Spreadsheet, the widget is not rendered correctly.

To reproduce
Steps to reproduce the behavior:

1. Run the Dojo - https://dojo.telerik.com/@NeliKondova/aXUvAKeB

The columns of the Spreadsheet are visible even outside of the component.

Expected behavior
The columns should be limited to the Spreadsheet width

Affected package (please remove the unneeded items)

• theme-default
• theme-bootstrap
• theme-material

Affected suites (please remove the unneeded items)

• Kendo UI for jQuery

Affected browsers (please remove the unneeded items)

• All

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.

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

In my application I am using the following. 

kendo.ns="kendo-";

Dojo example: https://dojo.telerik.com/@iankodj/aKIyEwUv 

The spreadsheet component works well with the namespace, however any dialogs that the component opens do not function correctly.

For example, I am using Edge browser. If I copy a cell and they try and past the value via the context menu, a dialog appears telling me to use the keyboard.

The "ok" button of the dialog does not work. Looking at the html source that is added to the DOM, it appears that the button is trying to bind to the click event via a "data-bind" attribute rather than a "data-kendo-bind" attribute as specified via the namespace.

The attached file show the behavior with the Basic demo example having the kendo namespace set.

Thanks,

Darin

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]

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

Hi there,

When a spreadsheet is linked to a datasource, if you leave a gap between previously entered rows and your new data, each cell edit creates a new item in the datasource with only the cell modified.

Here is the record after adding one cell.

and after adding another cell:

This is the state of the spreadsheet:

I managed to replicate this in dojo here: https://dojo.telerik.com/eRiHocar

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]

Bug report

Custom validation error can not be handled in spreadsheet

Reproduction of the problem

https://dojo.telerik.com/@zdravkov/uJuruCod
go to Data->Data Validation->Custom Formula (Ignore blank, Reject input),
open the console,
than if you enter an invalid formula (<4, >A3 or something like this) and press Apply, in the console you can see an exception

Current behavior

The exception can't be handled

Expected/desired behavior

One should be able to handle the exception

workaround - https://dojo.telerik.com/@zdravkov/adEWOlOk

Environment

• **Kendo UI version: 2021.1.119

Bug report

The Spreadsheet SLOPE and INTERCEPT functions do not calculate if arrays passed as parameters contain blank or string cells

Reproduction of the problem

1. Run this dojo

Current behavior

1. Note that cell B3, B4, and B5 return errors as a result of the calculation
2. Same data passed to the SLOPE and INTERCEPT functions in Excel returns a valid result

Expected/desired behavior

Calculation of the SLOPE and INTERCEPT functions should be consistent with Excel

Environment

• Kendo UI version: 2020.3.118
• Browser: [all]

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 ]

Bug report

cell connection in Spreadsheet is not working when the sheet contains 1.0 in the name

Reproduction of the problem

download the file from ticket - 1500102
open our demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
open the file from the ticket in the Kendo Spreadsheet

Current behavior

cell F17 is not connected with cell B12 from the second sheet

Expected/desired behavior

cell F17 is connected with cell B12 from the second sheet

note: if the name of the sheet is changed to something different than 1.00 for example 'A' the cells are connected

Environment

• **Kendo UI version:2020.3.1118

Bug report

When importing from Excel in Spreadsheet if a date is entered, but the date format is not set explicitly, the imported date always has the following format: "mm-dd-yy". The issue is observed even if a culture is set.

Reproduction of the problem

1. Open the Dojo example
2. Import the following file
   DateFormat.xlsx

Current behavior

The value in Excel is "15.6.2020" , but the imported date in the Spreadsheet is "05-15-20" screencast

Expected/desired behavior

The format of the dates should be the same as in the imported file.

Environment

• Kendo UI version: 2020.3.1118
• Browser: [all ]

Bug report

when the color of the borderBottom is commented

  "borderBottom": {
                            //"color": "black",

js error when color is not applied a cell of the Spreadsheet

kendo.all.js:61278 Uncaught TypeError: e.transform is not a function

Reproduction of the problem

https://dojo.telerik.com/@zdravkov/iVoJuxAZ
export to pdf

Current behavior

js error

Expected/desired behavior

the data is exported correctly

Environment

• **Kendo UI version: 2020.3.1118