Bug report
SpreadSheet does not apply borderBottom correctly for last row

Reproduction of the problem

Dojo - https://dojo.telerik.com/UGABAnoR

Current behavior
Border is applied at the first row for the next column

Expected/desired behavior

The border shall be applied at the bottom at A2000

Environment
Kendo UI version: [all]
Browser: [all ]

Dear Kendo,

I made research about Kendo Spreadsheet control and I found some of unlogical things in example:

1. When I made changes (kendoSpreadsheetCancelChanges.png) in spreadsheet and click on CANCEL CHANGES button, all of these changes aren't removed.

2. Manually reading spreadsheet datasource, all of these changes aren't removed. For example, when I type in console

$("#spreadsheet").data("kendoSpreadsheet").options.sheets[0].dataSource.read();, datasource is reading, but almost all changes are shown. Why?

Kind Regards,

Marin

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

Hi,

We are using Kendo spreadsheet one of our applications. We wanted to get applied filters and set back to the Kendo spreadsheet. Not able to find a documentation for that. Can you please anyone help to sort this issue out?

Thanks

Bug report

Reproduction of the problem

Dojo: https://dojo.telerik.com/eToXOQOL/9

1. Open a Notepad, and create the following structure:

a
b[tab]c[tab]d
e[tab]f[tab]g

Between each element on rows 2 and 3, there is a [tab] character. This will make sure that the data pasted into Spreadsheet will land on different columns.

 2. Copy the entire content of the Notepad document and paste it in cell A1. After the paste operation, you will notice under the Spreadsheet component an output with the range that was passed to the change event.

Problem:
The computed range is A1:A3 while the expected value is A1:C3

Expected behaviour

The expected value is A1:C3

Environment
Kendo UI version: 2021.1.224 or newer
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 in js\spreadsheet\numformat.js makeDateFormat

You appear to be using the wrong indices inside a nested loop.

if (/^(?:date|time|ampm)$/.test(section.body[i].type)) {

Should be (switch i to j)

if (/^(?:date|time|ampm)$/.test(section.body[j].type)) {

Getting error

Uncaught TypeError: Cannot read property 'type' of undefined
     at Object.<anonymous> (numformat.js:630)

Note: Version is actually 2018.3.1114 from npm

Bug report

When exporting a Spreadsheet with a set background to a PDF file, some of its borders are not displayed.

Reproduction of the problem

1. Open the following Dojo example - https://dojo.telerik.com/IZUhIDeV
2. Export the Spreadsheet to PDF

Current behavior

Some borders of the Spreadsheet are missing in the exported PDF file.

Expected/desired behavior

All borders of the Spreadsheet should be displayed in the PDF file.

Environment

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

Spreadsheet saveAsExcel split is not a function error (kendo.all.js:3436) after upgrade to Kendo 2019.2.514.

Bug report

In the Spreadsheet, if you freeze too many columns and then try to export to Excel, the file is corrupted.

If you reduce the number of columns in the example below, the issue does not occur.

Reproduction of the problem

1. Open this example
2. Click the frozen rows button
3. Click the Export to Excel button

Current behavior

The exported file is corrupted and cannot be opened

Expected/desired behavior

The file should not be corrupted

Environment

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

Hi,

I want to highlight spreadsheet on cell hover. But I just want to highlight row and column until cell. Is there any way to do this ? 

In example, When my mouse on cell E11.

Best Regards,

Kaan

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

Set Fixed Cols/Rows etc. or setOptions( {filter: { ref: "A3:G49", columns:[]}});

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

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.