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

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

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

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

When an Excel file with 'Set precision as displayed' option enabled is imported in the Spreadsheet the calculations are not the same as in the Excel file.

Reproduction:

1. Open the Spreadsheet demo

2. Import the excel file from the zip. in the Excel file the following option is enabled - File->Options->Advanced->When Calculating this workbook-> Set precision as displayed

The value in Excel in C1 column is 399.96, while the value displayed in the Spreadsheet is 400.00

I would like to have support in Spreadsheet for Excel files with 'Set precision as displayed' option enabled.

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

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

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.

Currently, the Spreadsheet does not appear and does not function properly when the 'k-rtl' class is applied.

Dojo

Please provide Right-To-Left support for the Spreadsheet widget. 

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

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 ]

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 ]

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]

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 ]

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). 

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 ]

To whom it may concern,

I am having a problem with the AGGREGATE function in the spreadsheet control. Cell H7 does not give me a value.

I have attached a dojo saved file, the tutorial documentation I was following (please see pages 4 & 5), a screenshot of the function in dojo and an excel file with the aggregate function working.

Thank you advance.

Hi

Is it possible to only move between "open cells for input. " With fx. using tab or enter. 

When you are input finance data. It would be nice, that with a tab, it only moves between open cell. Is this possible. 

On all browser, but mainly edge, chrome , 

reg. jakob