Unplanned
Last Updated: 17 Sep 2019 08:30 by ADMIN
Created by: Chris
Comments: 3
Category: Spreadsheet
Type: Feature Request
1

Hi

Does the kendo spreadsheet support conditional formatting / data bars (which are the background bar charts on a cell)...

See example below - and attached simple xlsx (in zip)

 



which in excel you add like

 

If not currently supported as standard, any suggested workarounds?

Thanks

 

Chris

Unplanned
Last Updated: 10 Sep 2019 08:55 by ADMIN
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently the API does not provide a way to detect when filtering occurs. It would be great if you could add a filter event.
Unplanned
Last Updated: 10 Sep 2019 08:56 by ADMIN
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Feature Request
0

The filtering on the spreadsheet component is great!!

There is however one behaviour that causes confusion for end users, and that is filtering when merged cells  are present in the selection.  
An example is available in the following dojo:
https://dojo.telerik.com/UzUMUDos

Open the dojo and filter column A on a1 and you will only see only b1 in column B, but the b1a will not be shown.

To be clear - This is also how Excel behaves...  (which is of course your prime aim so its not a bug as such)... 
Interestingly google sheets stops you putting filter on merged cells / stops you merging on filtered column.

The Excel behavior is discussed in the following threads:
https://stackoverflow.com/questions/49816515/excel-filtering-for-merged-cells
https://www.officetooltips.com/excel_2013/tips/workaround_for_sorting_and_filtering_of_merged_cells.html

Is it possible to implement something, so the end user experience would be improved? Maybe when merged cells are present :
a) if they click filter, this is detect and user is warned of this behaviour
b) if they click filter, the sheet is changed into an unmerged version (which repeats data in merged cells) as in the excel examples above.

 
Unplanned
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.
Unplanned
Last Updated: 03 Sep 2019 10:08 by ADMIN
Created by: Holly
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

We have a client that recently brought to our attention the fact that he found a case where he couldn't place his cursor in a certain spot of a formula, click a cell, and have it fill that cell in. It works if you try to do that for the first cell listed in the formula, but not the rest. I've outlined a sample case below.

You can enter a formula in a cell like =IF(A2+B2, 1, -(A2+B2), 2). Then, highlight a cell, like A2 below, and delete it by hitting backspace or delete.

After hitting delete, leave the cursor in the same location of the formula and click a new cell, like A4.

For this case, since it's the first cell in the formula, it will insert the cell you just clicked on in the correct location. However, next try highlighting the next cell referenced, hitting delete, and clicking on a new cell to have it insert the cell into the formula. In this case, we highlighted and deleted B2, then tried to click on B4.

You'll see that, for this one, instead of inserting B4, it gives an error message. Our client said that it significantly slows him down when he has to manually type in each change to the formula, so is there any way we could have it insert the cell you click on for all cases? It doesn't look like this is a current feature, so would you be able to add it, please? Thank you!

Unplanned
Last Updated: 22 Aug 2019 10:51 by ADMIN
Created by: G.K. Raju
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Currently there is no suitable event to detect cell styling changes. Such event could be implemented similar to the formatChange event but for the styling changes.
Unplanned
Last Updated: 09 Oct 2019 15:13 by ADMIN
Consider implementing functionality for importing and working with encrypted / password protected Excel files in the SpreadSheet component
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: 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!

 

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: 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: 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: 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.
Unplanned
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

 

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: 29 Mar 2019 15:22 by ADMIN
Created by: Telerik Admin
Comments: 0
Category: Spreadsheet
Type: Feature Request
4
Currently filtering is not supported for a Spreadsheet which has its Sheet bound to a Kendo DataSource.
Unplanned
Last Updated: 29 Mar 2019 15:22 by ADMIN
Created by: Telerik Admin
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
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.

Unplanned
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.