Approved
Last Updated: 23 Sep 2019 07:50 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Bug Report
0

Bug report

Reproducible with the Default and Bootstrap SASS themes.

Reproduction of the problem

Reproducible in the demos.

  1. Resize the browser window making it more narrow (screencast)

Current behavior

Icons are misaligned.

Expected/desired behavior

Icons are properly aligned.

Environment

  • Kendo UI version: 2019.3.917
  • jQuery version: x.y
  • Browser: [all]
In Development
Last Updated: 20 Sep 2019 14:54 by ADMIN
Scheduled for 2019.R3.SP1
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Bug Report
0

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

Pending Review
Last Updated: 17 Sep 2019 11:01 by Naveen
Created by: Naveen
Comments: 0
Category: Spreadsheet
Type: Feature Request
1

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.
Approved
Last Updated: 17 Sep 2019 08:30 by ADMIN
Created by: Chris
Comments: 3
Category: Spreadsheet
Type: Feature Request
0

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

Pending Review
Last Updated: 10 Sep 2019 10:15 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
11
On excel, you can filter merged rows. On the kendo spreadsheet widget, filtering on merged rows is not possible. It would be a very useful feature for us. 

Also worth noting is that if you convert an excel file to JSON using Telerik RadSpreadProcessing, and load the kendo widget with the JSON, the widget displays a filter icon but clicking it loads a non-functioning filter. Wouldn't it make more sense to load with a message along the lines of 'You loaded a spreadsheet with filters applied to merged rows, which is not supported in this widget'. Otherwise it's quite confusing to our users.
Approved
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.

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

When using IE 11 and using Ctrl+X to cut, this only works the first time. All subsequent attempts to use cut produce the following dialog:

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

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!

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
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]
Approved
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.
Pending Review
Last Updated: 19 Aug 2019 12:59 by xudong
Consider implementing functionality for importing and working with encrypted / password protected Excel files in the SpreadSheet component
Approved
Last Updated: 07 Aug 2019 06:54 by ADMIN
Created by: Naveen
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

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 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]
Completed
Last Updated: 22 Jul 2019 14:14 by ADMIN
Created by: 炯军
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
can add float object container ? eg:charts
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: 22 Jul 2019 14:08 by ADMIN
ADMIN
Created by: Marin Bratanov
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.
1 2 3 4 5 6