Dear Concerned,

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

2. Import attached Book21.xlsx file

3. I have first row as frozen pane and columns C, D are hidden

4. Select columns B to E using mouse drag & then right click on selected column , it does not show Unhide option, because on right click it keeps the selection only on column E

It does not work if we keep Freeze Panes.

Dear Concerned,

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

2. Copy from F3:F15

3. Paste as value (ctrl+shift+v) in H3

4. See it pasted only non-empty cells

Empty cells values should be pasted as well as Excel does.

 

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.

 

Dear Concerned,

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

2. Click Background or Text Color icon , select custom color

3. See the popup UI , there is boarder and margin issues, boarder is visible on top,left & bottom side but not on right side

Bug report

When a cell/row is selected, its first cell is focused and the sheet is scrolled to show it. If a long sheet is scrolled down/right to edit cells, this scroll top/left is very annoying and user unfriendly.
In these scenarios Excel focuses the topmost/leftmost currently visible cell, avoiding sheet scrolling.

Reproduction of the problem

1. Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Scroll to the bottom row of Spreadsheet's sheet.
3. Click in cell B200 to select it.
4. Click on the header of column C to select the whole column.

NOTE: for rows reproduction select cell AX2, then click on the header of row 2 - sheet is scrolled to the left and cell A2 is focused.

Current behavior

Column C is selected, cell C1 is focused and the sheet is scrolled to top.
The used has to scroll down to the bottom row again to edit data at the bottom of the sheet.

Expected/desired behavior

Column C is selected. The currently visible topmost cell of column C is focused, without scrolling the sheet. Excel works that way

Environment

• Kendo UI version: 2019.2.619
• Browser: all

Bug report

Client-side exported Excel workbooks are exported "uncompressed" (as readable text) and their size is much greater than the original document.

Regression since R2 2019 - 2019.2.514

Reproduction of the problem

1. Go to https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Open the following file in Spreadsheet -
   Workbook Original.xlsx - 26 KB
3. Export the file to Excel

Current behavior

The exported file is 1015 KB in size. The content of the file may be read as plain text

Expected/desired behavior

The exported file is 26 KB or similar size. The content of the file is unreadable binary data

Environment

• Kendo UI version: 2019.2.619
• Browser: all

Bug report

The performance in the latest official version is significantly worse compared to older versions (2017.1.117 and 2018.1.118 tested).

Reproduction of the problem

Dojo example.

1. Click a cell
2. Press Ctrl + A
3. Select a font size from the dropdown in the Spreadsheet's toolbar

Current behavior

The UI freezes and remains unresponsive for minutes.

Expected/desired behavior

The new font size is applied without significant delay.

Environment

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

Hello!

We find a formatting problem, when we have a relatively small result, for example (0.05%) the referring component on the screen gives a strange value (-,05%) as shown in the image below.

We want to know if you can help us with this.

Thank you.

Bug report

When pasting data from Excel, the data is being pasted as an image instead of values

Reproduction of the problem

1. Open https://dojo.telerik.com/UKAFAkEn
2. Open new Excel file on your system in MS Excel application
3. Enter data 1, 2, 3, 4, 5 in A1 to A5 in sheet1
4. Copy data from A1 to A5 from the local file
5. Paste data in C3 of Spreadsheet opened in step 1
6. The pasted result is an image instead of values

Current behavior

Pasting from Excel results in an image

Expected/desired behavior

Pasting from Excel should result in correctly filled data cells

Environment

• Kendo UI version: 2019.2.514
• jQuery version: x.y
• Browser: [Chrome 74.0.3729.131 | Firefox 66.0.5 | Edge 42.17134.1.0 ]