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

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

 

 

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: 25 Jun 2019 07:29 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

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: 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: 04 Dec 2019 09:02 by ADMIN
Created by: Naveen
Comments: 5
Category: Spreadsheet
Type: Feature Request
4

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: 27 May 2019 10:09 by ADMIN
Created by: Daniel
Comments: 1
Category: Spreadsheet
Type: Feature Request
0
Provide support for images client-side import/export through Telerik Document Processing.
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: 12 Apr 2019 10:47 by ADMIN
Created by: Naveen
Comments: 2
Category: Spreadsheet
Type: Feature Request
3

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: 05 Apr 2019 13:48 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
2

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: 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: 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.
Declined
Last Updated: 03 May 2019 10:31 by ADMIN
Created by: Bryan
Comments: 5
Category: Spreadsheet
Type: Feature Request
0

In my testing of utilizing the spreadsheet component and starting off with for example 100 rows in the configuration options, using insert row typically seems to shift the data down (if you have anything below the cursor). It does not actually increase the number of rows in the sheet. 

 

For example if I initialize the spreadsheet with the following info:

$("#spreadsheet").kendoSpreadsheet({
        rows: 100,
        columns: 26
});

 

This will create the spreadsheet with 100 rows and columns A-Z as expected.

Now going anywhere in the sheet (or the end) and inserting a row above/or below will not add row 101, 102, 103, etc. In fact, if you are in the very last row and hit insert row below it will come up with a message regarding a possible loss of data. 

A couple things I have tried:

  • Utilizing the insertRow event and setting a flag for when the next render call happens to recreate the sheet using the fromJSON() function.This mostly works actually, however if you try this while the cursor is near the last row (within 1-2 cells) there seems to be some sort of bug that the data from toJSON() removes the data from rows 1 and 2, but only after column 2. For example see attached screenshot
  • Utilizing the insertRow event and updating event.sender.options.rows to increase by 1, it does something meaning the container expands in height by a little bit, but its an empty "row" with no grids and you cannot add content (it also does not have an # for the row). Looking at the actual JSON data it appears there are a lot of other locations rows is set, in the sheet, in the view, grid, etc.

 

So with that said, is it at all possible to actually add a row to the sheet as one would expect the behavior to be. This obviously still needs to call the internal functions to recalculate the ranges and data throughout the sheet; but somehow re-fresh or re-render the UI component (just calling render again doesn't fix it).

 

 

I appreciate your help with this.

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: 18 Mar 2019 09:44 by ADMIN
Created by: Zhiding
Comments: 0
Category: Spreadsheet
Type: Feature Request
0

Hi,

Would like to suggest 2 features for the spreadsheet which will be very useful

 

1) Ability to delete specific cell (not just the content, but the cell itself). Currently there is way to delete row or columns, but no cell deletion.  When cell is deleted, user should be prompted whether to allow all cells below the deleted cell to shift up, or all cells on the right of it to shift left. Akin to excel

 

2) Format painter. The ability to "paint" the styles (such as font size, boldness) from existing text to another existing text. Akin to excel.

Pending Review
Last Updated: 26 Feb 2019 09:25 by ADMIN
Created by: Jeffrey
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hello

We are trying to use the Kendo Jquery spreadsheet but are running across some issues in terms of setting up for printing and/or exporting to PDF.

 

Currently, we let the user modify the spreadsheet to suit their needs.  The problem is there is no way to see page breaks at this time...that we know of.  The users stretch columns and row to suit their needs but the only way to see if they 'broke' across a page is to export to pdf to see...

 

We would like one or two options...

1. We know what our page size is - 8 1/2 x 11.  Is there a way to fix the max size of the spreadsheet so it's 1 page wide?  If the user inserts columns then the other columns just get smaller and smaller - proportionally - but ultimately the sheet is as only as wide as 1 page...

 

2. The ability to see where the page breaks are so they can set up the sheet correctly.

 

Please let me know if one of these options is feasible or are we stuck?

 

Thank you

Jeffrey Suffet

Pending Review
Last Updated: 21 Feb 2019 06:52 by ADMIN
How to add Superscript, Subscript HTML Entities to Kendo Spreadsheet Cell Data
Pending Review
Last Updated: 11 Feb 2019 09:23 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
Make Spreadsheet xlsx import failure more user friendly. Currently, when xlsx import fails, the UI thread is blocked and the user needs to reload the page in the browser. The import operation instead could process the file in the background and could return meaningful message without blocking the UI.
Pending Review
Last Updated: 11 Feb 2019 08:57 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
3

Dear Concerned,

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

2. Open attached MultipleSheetsRowHeightIssue.xlsx

3. Please notice there are 3 sheets with default row height 20, 30, 40 respectively (you can check in MS Excel)

4. Now Click export, and open the exported file again 

5. Now we have an issue here - all sheets set to default row height to 40. (It seems that it is setting the last sheet's default row height to all sheets)

Its severe issue, please share a fix or at least provide some workaround.

 

Pending Review
Last Updated: 31 Jan 2019 07:38 by Kathy

I see some potential for improvements here, I see how the Spreadsheet entirely depends on the JSON structure. It doesn't have to be like this as the setDataSource() method shows clearly that the columns could be further configured: 

https://www.telerik.com/forums/datasource---specify-columns#msCK2ytWcESxeUMs-6a3uQ

Therefore, the Sheet columns could be configured upon the widget initialization. Such configuration options could be represented in the following manner for the HTML helper version of the widget:

.Columns<Kendo.Mvc.Examples.Models.SpreadsheetProductViewModel>(columns =>
{
    columns.Add(c => c.ProductId).Name("Product ID").Width(100);
    columns.Add(c => c.ProductName).Name("Name").Width(415);
})
Pending Review
Last Updated: 24 Jan 2019 07:07 by ADMIN
Created by: Michael
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

Hi,

We are using Kendo spreadsheet one of our applications. We wanted to get applied filters and set back to the Kendo spreadsheet. Not able to find a documentation for that. Can you please anyone help to sort this issue out?

Thanks