Approved
Last Updated: 05 Apr 2019 08:52 by ADMIN
Created by: Martin
Comments: 6
Category: Spreadsheet
Type: Feature Request
31
Ability for spreadsheet row height to be auto set from the row contents. This is to support wrapped text.
Approved
Last Updated: 03 May 2019 10:29 by ADMIN
Created by: David M
Comments: 4
Category: Spreadsheet
Type: Feature Request
17
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.
Approved
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

Approved
Last Updated: 22 Jul 2019 13:56 by ADMIN
Enable Cut/Copy cell values and can Paste it in mutiple selected values
Approved
Last Updated: 29 Mar 2019 15:22 by ADMIN
Created by: Telerik Admin
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
Currently filtering is not supported for a Spreadsheet which has its Sheet bound to a Kendo DataSource.
Approved
Last Updated: 18 Jun 2019 09:30 by Steven

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
Approved
Last Updated: 01 Aug 2019 08:34 by ADMIN

Other spreadsheet applications (Excel and Google Sheets, to name two) offer the ability to insert individual cells into a sheet without inserting a whole row/column. Most importantly, this feature updates cell references in formulas, which is not something that can be done with copy and paste.

For example, in the following spreadsheet (screenshot from Excel), I've right-clicked cell A2 and chosen "Insert" on the context menu. There is also a button on the ribbon that opens the same "Insert" dialog.

I want to shift the cells down, so I click OK in the dialog. Note that the formulas update accordingly: the sum range expands to A1:A5, while the individual cell references remap.

Can this feature please be added to Kendo spreadsheet? Otherwise, our clients will have to continue manually re-writing formulas after they copy/cut and paste to achieve a similiar-looking (but functionally different) result.

Thanks!

 

Approved
Last Updated: 03 Jun 2019 12:18 by ADMIN
Created by: Naveen
Comments: 3
Category: Spreadsheet
Type: Feature Request
2

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

 

Approved
Last Updated: 03 Sep 2019 10:53 by ADMIN
I need some event which gets fired when cell data validation gets failed, with entered what value got entered by the user and cell row and column index.
Approved
Last Updated: 12 Apr 2019 10:47 by ADMIN
Created by: Naveen
Comments: 2
Category: Spreadsheet
Type: Feature Request
2

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

Approved
Last Updated: 19 Mar 2019 11:28 by ADMIN
Created by: Sebastien
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
While you can set the enabled state of the sheet, you can still perform the selection, columns/rows merge and resizes.
Approved
Last Updated: 01 Apr 2019 11:52 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
2

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.

Approved
Last Updated: 29 Mar 2019 15:22 by ADMIN
Created by: Telerik Admin
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
Currently sorting is not supported for a Spreadsheet which has its Sheet bound to a Kendo DataSource.
Approved
Last Updated: 05 Apr 2019 13:48 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

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

Approved
Last Updated: 13 Feb 2019 15:07 by ADMIN

Hello there,

I am developing a Web application using  Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.

For example:

I have the following numbers on a Excel sheet:

10.50.3333333330.250.20.1666670.1428570.1250.1111110.10.0909090.0833330.0769230.0714290.0666670.06250.0588240.0555560.052632

Then, I copy them to the Kendo spreadsheet and I got the following:

100.00%50.00%33.33%25.00%20.00%16.67%14.29%12.50%11.11%10.00%9.09%8.33%7.69%7.14%6.67%6.25%5.88%5.56%5.26%

But when I copy them back to Excel I got this:

10.50.33330.250.20.16670.14290.1250.11110.10.09090.08330.07690.07140.06670.06250.05880.05560.0526

Losing many decimals affecting the results of my computation and calculation.

Can you tell me why is this happening?

Thank you some much.

 

 

 

Approved
Last Updated: 24 Apr 2019 12:02 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
1

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.

 

Approved
Last Updated: 22 May 2019 14:20 by ADMIN

Wanting to format a subset of a single cell with text styling different from the rest of the cell contents.  Something like the following:

or

 

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

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.

Approved
Last Updated: 25 Jul 2019 13:04 by ADMIN

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]
Approved
Last Updated: 30 Aug 2019 04:59 by ADMIN

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]
1 2