Completed
Last Updated: 21 May 2019 10:46 by ADMIN
Created by: Imported User
Comments: 9
Category: Spreadsheet
Type: Feature Request
62
Currently the API is very much limited to what is possible in the frontend in my opinion. It would be great if you could add events like:
- A cell/range was selected
- A cell was cut/pasted/copied
- The context menu was initialized
- A row/column was added
- A row was added/deleted/hidden
- A cell's content was modified
...
...
Completed
Last Updated: 21 Oct 2016 05:26 by James
Created by: Otto Neff
Comments: 12
Category: Spreadsheet
Type: Feature Request
59
Set default Cell Types like Date(Time)Picker, Checkbox, 
SimpleCombo, Autocomplete or own Custom Editor (see other Feedback suggestion)
Completed
Last Updated: 22 Jul 2019 13:44 by ADMIN
I know that Kendo Spreadsheet works like most popular Spreadsheets (Excel and Google Spreadsheet) where, if you copy or drag and paste values from cells, you will copy also the styles, validations, etc from that cell to the new one (unless you select "paste values only" in a context menu or ctrl + shift + v). 

It would be awesome if we can set how this works by configuring a property in the Spreadsheet configuration, something like pasteValuesOnly: false/true or even more complex with an object where you can choose if paste values, validations, formulas, styles or whatever. Also you could attach this functionalities to a context menu (as Google Spreadsheet does) and be able to paste everything, values only, format only, formulas or data validation.
Completed
Last Updated: 27 May 2019 10:16 by ADMIN
Created by: Jati
Comments: 0
Category: Spreadsheet
Type: Feature Request
34
For KendoUI Spreadsheet, it should have the ability to add images or logo into the spreadsheet. This feature is already available in Handsontable component.
Completed
Last Updated: 27 May 2019 10:18 by ADMIN
Completed
Last Updated: 05 Oct 2016 12:09 by ADMIN
Created by: Otto Neff
Comments: 2
Category: Spreadsheet
Type: Feature Request
12
Hide or disable Icons, Panes / Functions in the Toolbar
Completed
Last Updated: 18 Nov 2019 08:53 by ADMIN
Release 2019.R3.SP.next
### 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 ] 

Completed
Last Updated: 22 Jul 2019 14:11 by ADMIN
Created by: Martin
Comments: 2
Category: Spreadsheet
Type: Feature Request
3
Ability to hover over a cell and see a tooltip
Completed
Last Updated: 08 Nov 2019 11:52 by ADMIN
Release 2019.R3.SP.next

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
Completed
Last Updated: 10 Oct 2019 07:24 by ADMIN
Release 2019.R3.SP.next
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
2

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

Completed
Last Updated: 02 Sep 2019 09:38 by ADMIN
Release 2019.R3

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
Completed
Last Updated: 01 Jul 2019 10:47 by ADMIN

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
image

Expected/desired behavior

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

Environment

  • Kendo UI version: 2019.2.619
  • Browser: all
Completed
Last Updated: 08 Nov 2019 13:21 by ADMIN
Release 2019.R3.SP.next

Bug report

The current client-side export functionality does not preserve the number of columns.

Reproduction of the problem

  • Load the following file in the Spreadsheet which contains columns up to "BA".

  • Export the file

  • Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".

Current behavior

Client-side export does not preserve the number of columns greater than "AX".

Expected/desired behavior

Client-side export does not preserve the exact number of columns.

Environment

  • Kendo UI version: 2019.2.619
  • Browser: [all]
Completed
Last Updated: 06 Dec 2019 10:35 by ADMIN
Release 2019.R3.SP.next

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.

Completed
Last Updated: 28 Nov 2019 14:23 by ADMIN

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.

 

Completed
Last Updated: 20 Nov 2019 14:23 by ADMIN
Release 2019.R3.SP.next

Bug report
Spreadsheet SUMIF function returns #NA when Excel returns the correct result. The issue is observed when the criteria range and sum range have different sizes.

Reproduction of the problem
Run the Spreadsheet demo page
Open the attached file
Formula in cell B3 returns #NA!

Current behavior
The formula in cell B3 returns #NA!

Expected/desired behavior
The formula in cell B3 should return the correct value

Environment
Kendo UI version: 2019.3.1023
Browser: [all]

Completed
Last Updated: 22 Jul 2019 13:48 by ADMIN
In MS Excel when you type a number you can easily go to other cells by using the arrow keys and type in another number, thus allowing for fast editing of the spreadsheet. This does not work in the spreadsheet component.
this functionality only needs to work when not creating a formula.
Completed
Last Updated: 04 Jun 2019 09:24 by ADMIN
Currently the font sizes in the Spreadsheet are in pixels, while in Excel they are in points (pt). The values for the fontSize remains the same upon export / import. As a result, fonts in Excel appear lager than those in Spreadsheet.
Completed
Last Updated: 21 May 2019 09:09 by ADMIN
Release 2019.R2.SP.Next

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
spreadsheet_paste

Expected/desired behavior

Pasting from Excel should result in correctly filled data cells
spreadsheet_paste1

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 ]
Completed
Last Updated: 20 Nov 2019 14:22 by ADMIN
Release 2019.R3.SP.next

Hi Kendo Team,

The exported excel file from spreadsheet can not be opened in Microsoft excel when the spreadsheet has both a comment and a image.

You can reproduce the issue at your demo site https://demos.telerik.com/kendo-ui/spreadsheet/index

First add a comment for cell D3, then add a image, then export as xlsx.

Try open the export excel file, and you will see the error popup says "we found a problem with some content in workbook.xlsx ......"

It works when exporting comment and image separately.

1 2