Unplanned
Last Updated: 05 Apr 2019 08:52 by ADMIN
Created by: Martin
Comments: 6
Category: Spreadsheet
Type: Feature Request
33
Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.
Unplanned
Last Updated: 03 Jan 2020 15:36 by ADMIN
Created by: Imported User
Comments: 5
Category: Spreadsheet
Type: Feature Request
26
It would be great if you could put images to cells using html. E.g.: <img src="..."> would result in an image in the cell.
Unplanned
Last Updated: 03 May 2019 10:29 by ADMIN
Created by: David M
Comments: 4
Category: Spreadsheet
Type: Feature Request
20
Use case:
My app doesn't know how many rows of data the excel spreadsheet will be prior to upload.  I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others.  The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition.  

As a workaround, I'm destroying and reloading the widget instance after the initial load.
Unplanned
Last Updated: 21 Jan 2020 11:55 by ADMIN
Created by: Jiri
Comments: 3
Category: Spreadsheet
Type: Feature Request
15
I want to be able to double click a column header  to set column width to max width of entries - autoresize
Unplanned
Last Updated: 04 Dec 2019 09:10 by ADMIN
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
Unplanned
Last Updated: 04 Dec 2019 09:02 by ADMIN
Created by: Naveen
Comments: 5
Category: Spreadsheet
Type: Feature Request
10

Dear Concerned,

I have observed that Conditional Formatting in Spreadhseet is not supported. Please add support for the same as it is very important feature of XLSX.  during financial calculation this feature plays an important role. Here is the issue that needs a fix.

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

2. Check attached file CellColorFormula.xlsx, conditional formatting set for B2, C2, D2

3. Import attached file CellColorFormula.xlsx

4. Check Cells B2, C2, D2 and try to change values for A2, C2, D2

5. None of the conditional formatting is working

 

Unplanned
Last Updated: 13 Dec 2019 15:32 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
8

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

1. Enter some text in a cell.

2. Increase the cell font size to 48.

3. Reduce the cell font size to 8.

4. Double click the row resize handler: the row height is not adjusted to correspond to font size 8.

The same behavior can be observed when opening an existing .xlsx file that has some text and font size set and following steps 3-4.

Unplanned
Last Updated: 30 Oct 2019 15:32 by ADMIN

Add option for manual calculation of formulas, as available in Excel.

It would be a great feature to have to save time for inputting values without updating other dependent cells and once data entry is done user could press "Calculate Now" and all of the cells updated in one go, same as we do have this feature in MS Excel 365.

Unplanned
Last Updated: 24 Jun 2019 07:59 by ADMIN

On Internet Explorer-11, UI is getting blocked while performing comparatively fast data entries, it is not only too slow but values are getting truncated as well.

 

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

2. Start editing cells C3 to C12 and enter value 1234 in each cell as fast as possible

3. 1234 enter, 1234 enter , 1234 enter and so on without waiting for UI rendering completion as UI freezes for few seconds, and then all cells get updated in one go

4. below is the result, few cells are having wrong values 

5. Its very serious issue

Note: Excel 365, Excel and GoogleSheet works fine in such cases

Unplanned
Last Updated: 25 Jun 2019 07:29 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
7

Dear Concerned,

 

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

2. Open Attached Test.xlsx file

3. Check the value of A2, it is different than Excel

Note: Cell format of A2 is set as below, if I select only $ format then it is working.

Unplanned
Last Updated: 07 Aug 2019 06:54 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
7

Dear Concerned,

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

2. Import attached Dummy.xlsx file

3. No data loaded

4. please check

 

 

Unplanned
Last Updated: 24 Sep 2019 08:01 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
7

Currently, the Spreadsheet component doesn't have the functionality to create a formula using the keyboard arrows.

For example:

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

2. Select C12 and type =SUM( to set formula 

3. Use the arrow keys to select the starting cell. This functionality is not available.

Please provide the described above functionality.
Unplanned
Last Updated: 11 Dec 2019 15:32 by ADMIN
Different scroll position should be persisted for each sheet.
Unplanned
Last Updated: 10 Dec 2019 08:54 by ADMIN

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

2. Put some text in B2 so that it does not fit in the cell width.

3. Press Wrap Text button 

4. Press Wrap Text again

5.  The row height is not adjusted back to the original height (Excel does it)

Unplanned
Last Updated: 09 Dec 2019 13:50 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Dear Concerned,

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

2. Import attached Book1.xlsx. Observe Cell F4 of Sheet1 has a font size of 72.

3. Change it to 8, row height does not change automatically

4. It should be same as Excel behavior


Please provide a fix or any workaround in the meanwhile.
Unplanned
Last Updated: 26 Nov 2019 12:29 by ADMIN
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Dear Concerned,

It would be very useful if Kendo can provide two more functions like fromJSON & toJSON in a Spreadsheet as mentioned below

fromStream() - to load an excel file form an Excel stream string so that the developer does not need to convert it to blob etc.

toStream() - to return excel stream string, it would good if it is possible to get stream without blocking UI operation. As of now, we first call toJSON & then call kendo.ooxml.Workbook(jsonSpreadsheetData).toDataURL(); to get excel stream and it is time consuming operation.

Use case: keeping excel file/stream on the server and fetching it using API on UI and then using fromStream to load & render it. And toStream is the same as toJSON to save modified stream back to the server since stream size is very low as compared to json.

Please see if it is feasible to provide these features.
Unplanned
Last Updated: 17 Dec 2019 12:21 by ADMIN
Created by: 경태
Comments: 0
Category: Spreadsheet
Type: Feature Request
7
Please support Excel formulas copy and paste to Kendo Spreadsheet.

Now is the copy only the text, not formulas.
Unplanned
Last Updated: 12 Apr 2019 10:47 by ADMIN
Created by: Naveen
Comments: 2
Category: Spreadsheet
Type: Feature Request
7

Dear Concerned,

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

2. Start editing cells D3 to D11 as fast as possible (like type 45 enter, 45 enter, 45 enter and so on) (refer attached videos)

3. UI freezes for few seconds, and then all cells get updated in one go

4. But Excel 365, Excel and GoogleSheet work fine in such cases

5. Please make similar UI behavior as in Excel.

 

Check attached Excel Data Entry & Kendo Data Entry video recordings

Unplanned
Last Updated: 05 Apr 2019 13:48 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
7

Dear Concerned,

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

2. Upload the attached sample.xlsx file.

3. Cell B1 getting value from cell A1 using formula "=TEXT(A1, "$#,###")"

4. Delete(Blank) the value of cell A1, see error #VALUE! in cell B1.

5. The same is working fine in Excel.

6. Please suggest any workaround or quick fix.

 

 

Check attached Sample.xlsx file in Sample.zip folder

Unplanned
Last Updated: 01 Nov 2019 09:08 by ADMIN
Currently, when trying to load a corrupt XLSX file, the Spreadsheet will freeze and no message will be returned to the user. Improve the widget to unfreeze the view and notify the user about the problem.
1 2 3