Dear Concerned,

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Select Column B11, click wrap text from Home toolbar.

3. Start typing in B11 & see cell editor keeps growing and goes beyond screen.

4. This is not user friendly, it should be same as Excel

5. Any alternative or quick fix would be appreciable

Bug report

Reproduction of the problem

Reproducible in the demos.

1. Use the HYPERLINK function in a cell:

=HYPERLINK("https://google.com")

Current behavior

The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")

Expected/desired behavior

The link works with and without a "friendly name" specified, as in Excel.

Environment

• Kendo UI version: 2019.2.619
• jQuery version: x.y
• Browser: [all]

Bug report

When the INDEX formula is used in combination with LINEST the Spreadsheet displays an empty cell. In case such formula is imported from Excel file '#VALUE' is displayed.

Reproduction of the problem

1. Open the Dojo
2. Observe the content of the cell with the pink background.

behavior when importing:

1. Import the file in the Spreadsheet demos
   LINEST_INDEX.xlsx

Current behavior

The content of the formula cell that includes LINEST and INDEX is empty. When clicking on the cell the formula is displayed in the formula bar. When importing the content in some cases the content is '#VALUE'.

Expected/desired behavior

The LINEST should work as expected in combination with the INDEX formula.

Environment

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

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.

Bug report

Office 365 Comment are shown with a warning:
"[Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Reproduction of the problem

go to demo - https://demos.telerik.com/kendo-ui/spreadsheet/index

Current behavior

import a file from ticket - 1447268

A warning is displayed

Expected/desired behavior

No warning is displayed

Environment

• **Kendo UI version: 2019.3.1023

Dear Concerned,

 

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Try to select columns B to D using mouse

3. Click on column B, keeping mouse clicked, move your mouse towards C then D

4. It does not allow to select B,C,D where as it is possible in Excel.

It is serious issue for me as I could not proceed with Hide/Unhide columns and some other features depend on multiple columns selection

Note: if we add a blank row at first position then it works well, seems like first with merged columns is creating problem.

Dear Concerned,

1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index

2. Open Workbook(1).xlsx (attached)

3. Edit B2, D2, F2 with some new values

4. See the results in B4, D4, F4

Calculations are different in Excel.

 

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

2. Background color and text color buttons are initialized as a group. These buttons are not working if we put them in a group

3. If we keep them separate, outside group, the buttons work as expected.

### Bug report
The Ctrl + Shift + Arrow key keyboard shortcut should select a range in the row/column starting with the active cell and ending with the first cell in the row/column that has a value: [list of shortcuts](https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/end-user/list-of-shortcuts) used by the Spreadsheet. It works similarly in Excel. 


### Current behavior
The selection does not end at the first cell that has a value, it ends with the last cell of the row/column.  

### Expected/desired behavior
The expected behavior should be as described in the documentation: "Extends the selection of cells to the last nonblank cell in the same row or column as the active cell."

### Environment

* **Kendo UI version:** 2018.2.620
* **Browser:** [all ] 

To reproduce
Steps to reproduce the behavior:

step1: Make a cell become wrap text and text something

 

step2: Export to pdf file:

 

Expected behavior
Text display same as on safari

Please fix this problem asap!!!.

In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell.  Next I name the single cell D5, and call it MyAnswer.  I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.

Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.

Can you please advise when this issue will be fixed in Telerik.

I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".

Thank you so much.

Bug report

Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:

let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();

If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).

let dataURL = new kendo.ooxml.Workbook(data).toDataURL();

Reproduction of the problem

Dojo example.

1. Click the "To Json" button above the Spreadsheet.
2. Try to open the generated file in Excel.

Current behavior

The generated Excel file is corrupted

Expected/desired behavior

The generated Excel file is not corrupted

Environment

• Kendo UI version: 2020.2.617
• jQuery version: x.y
• Browser: [all]

Bug report

Values that are copied from Spreadsheet are duplicated when pasted in Excel if before that the copied cells have been cut and pasted inside the Spreadsheet.

Reproduction of the problem

1. Open this Dojo project
2. Cut B3:C3
3. Paste the copied content to A1:B1
4. Copy A1:B2
5. Paste to Excel

Current behavior

In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied

Expected/desired behavior

The pasted in Excel content should contain 2 rows instead of 3

Environment

• Kendo UI version: 2020.3.1021
• jQuery version: x.y
• Browser: [all]

[Edited]

Bug report

After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.

Reproduction of the problem

1. Open the Kendo UI Spreadsheet Overview
2. Copy Data C7:D8 from Kendo Spreadsheet
3. Paste data to MS Excel (used: Microsoft 365 MSO version 2309)
4. Edit values in MS Excel.
5. Copy from MS Excel
6. Paste new values to a Kendo UI Spreadsheet.

Expected/desired behavior

The new values are not pasted back to the Kendo UI Spreadsheet.

Environment

• Kendo UI version: 2023.3.1114
• jQuery version: All Supported Versions
• Browser: all

1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.

2. Click on open button in the Toolbar of the spreadsheet.

3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.

4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.

5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.

 

Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?

Bug report

When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.

Reproduction of the problem

1. Go to Spreadsheet Basic usage demo
2. Add a new sheet
3. Type ab113abababab11ab in A1
4. Enter the following formula in B1 =SUBSTITUTE(A1, "ab", "")

NOTE: substituting ab with another string, e.g. cd, replaces all instances of ab as expected.

Current behavior

113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string

Expected/desired behavior

11311

Environment

• Kendo UI version: 2019.2.514
• Browser: all

Bug report

Reproduction of the problem

Dojo example.

1. Hide the second row.
2. Slowly scroll the Spreadsheet horizontally (left and right).

Current behavior

Column lines disappear and row lines appear (columns G, M, N, O). In Chrome values disappear as well, observe the value in column F. The configuration options required for reproducing the behavior are mergedCells and frozenRows.

Expected/desired behavior

No changes to the column/row lines and no disappearing values on scrolling.

Environment

• Kendo UI version: 2021.1.119
• jQuery version: x.y
• Browser: [all ]

Bug report

Reproduction of the problem

Use the Events demo to reproduce, since the events are logged in the console: https://demos.telerik.com/kendo-ui/spreadsheet/events

1. Add a new sheet
2. Drag left the newly added sheet, to make it first
3. Click "Invoice", hold down the mouse button and drag the Invoice sheet back to first place

Current behavior

The Invoice sheet is selected but the selectSheet event does not fire.

Expected/desired behavior

The selectSheet event fires

Environment

• Kendo UI version: 2020.2.617
• jQuery version: x.y
• Browser: [all]

Bug report

Reproduction of the problem

Dojo example.

1. Change a value in the second column, for example change 8 to 7.
2. Open the column filter menu. The filter menu properly shows the current values (5 and 7).
3. Close the filter menu and change the cell value again.
4. Open the column filter menu.

Current behavior

After the initial value change the filter menu no longer shows the current value of the modified cell.

Expected/desired behavior

The filter menu should always show the current values of the cells.

Environment

• Kendo UI version: 2020.3.1118
• jQuery version: x.y
• Browser: [all]

Bug report

Reproduction of the problem

Dojo example.

1. Click column "B"'s header to select the column.
2. Use the "Wrap text" tool from the toolbar. The text in B2 is wrapped.
3. While the column is still selected, use the "Wrap text" tool again.

Current behavior

The text in B2 is not unwrapped.

The merged cell prevents the unwrap. If there is no merged cell, or if the tool is used over the cell itself, wrapping/unwrapping works as expected.

Expected/desired behavior

The text in B2 is unwrapped.

Environment

• Kendo UI version: 2020.3.1021
• jQuery version: x.y
• Browser: [all]