Pending Review
Last Updated: 06 Aug 2017 10:54 by ADMIN
Created by: iTai
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
In the scpreadsheet you can use controls like  dropdowns & datepicker , but should be helpful if user could to customize the design and behavior. 

For example, the dropdown and any other control needs be opened since an icon at right that is displayed over the next column, As user i would like to choose how i want to be displayed the control: Open clicking on it, set expand direction, styles, etc.
Pending Review
Last Updated: 07 Aug 2017 09:59 by ADMIN
Created by: Chris
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
Additional functionality for:
-- Conditional Formatting -- coloring of cells, for example based upon a value and then be able to import from excel, and export back out.
-- Data Validation (dropdowns).  Also be able to import and export back out.
Pending Review
Last Updated: 08 Jun 2018 10:41 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
By default the items in filter are in random order. Can we sort the items in ascending order by default.
Pending Review
Last Updated: 11 Aug 2017 13:44 by ADMIN
When using the bottom right corner of a cell to batch copy values across a range by dragging the corner, an error popup appears if a disabled cell is found inside the range that was dragged into.  It is possible to reproduce this with this demo:

https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells

1.  Set the quantity column to disabled.

2. Select B3.

3.  Drag the bottom right corner of B3 to D3.

4.  See error: "Destination range contains disabled cells."

There should be an option to allow that to copy into any enabled cells in that range and ignore the disabled ones.
Pending Review
Last Updated: 08 Nov 2016 09:01 by James
Created by: Ganesan
Comments: 1
Category: Spreadsheet
Type: Feature Request
3
Show/Hide Column & Row Header
Pending Review
Last Updated: 07 Aug 2017 09:59 by ADMIN
Created by: Tom
Comments: 3
Category: Spreadsheet
Type: Feature Request
3
1. Save Excel workbook to folder on server (the Excel file can be re-purposed in many ways)
2. Better ways to send sheet data back to controller ... more JSON serialization options, csv, etc.
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
Pending Review
Last Updated: 21 Sep 2017 05:29 by ADMIN
Created by: Otto Neff
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
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.
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: 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.
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!

 

Completed
Last Updated: 13 Jan 2020 09:20 by ADMIN
Release R1 2020

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
Pending Review
Last Updated: 11 Oct 2017 14:37 by ADMIN
Created by: Geoffrey
Comments: 0
Category: Spreadsheet
Type: Feature Request
3
add indent property to spreadsheet cells to closer match excel
Pending Review
Last Updated: 22 Dec 2017 15:15 by ADMIN
I checked out the feature request provisions on your site. Since I'd like to include photos with my description, I'm hoping that it is okay that I send this to you for forwarding on to the appropriate audience.

My feature request involves the spreadsheet control in Kendo's JQuery controls

The request is for an attribute to be added to a cell of a spreadsheet which can be used by JQuery to associate the HTML dom element with the spreadsheet's javascript model. Here is why:


In needing to place things in the cells of spreadsheets (such as images and my own custom controls) as can be seen in my images 1 and 2, it is necessary to know which div.k-spreadsheet-cell corresponds with a kendo javascript spreadsheet cell. As a work around, I have given my custom controls an index number. In the kendo javascript object, I set the cell's background color to the same value as that index. This gave me two benefits: 1) it put a characteristic on the cell's div object that could identify the cell; 2) it rendered the cell even if it had no content--this is particularly important.

In my image 4, you can see the background color attribute of a cell div. In image 3, you can see my collection of custom controls. Each of my div.custom-control has a control_index property. I have a routine that runs periodically to reckon the location and size of each control whose background color is set to a value matching one of my cell's control indices. Once located, the controls are laid down onto their respective cells at their appropriate size (or made invisible if the target cell is scrolled off of the container).

This work around contains a lot of painful overhead. For instance, when a spreadsheet is first rendered, I have to traverse the div.k-spreadsheet-cell elements to check their background color attributes. If they qualify, a css class must be placed on the cell so that a black cell isn't presented in the time that it takes to reckon and position my custom controls.

If there were a 'tag' attribute that could be added to a cell's javascript model and that tag was ascribed to the div.k-spreadsheet-cell element (AND make the element render even if it is otherwise trivial), this operation would be a lot easier. I think that I'm not the only one who would like to take some control over the dom objects of the spreadsheet control. 

I would be happy to discuss this further with anybody who is interested.

Thanks,

Doug
Pending Review
Last Updated: 30 Nov 2018 12:24 by ADMIN
Created by: Abhinav
Comments: 3
Category: Spreadsheet
Type: Bug Report
3

1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.

2. Click on open button in the Toolbar of the spreadsheet.

3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.

4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.

5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.

 

Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?

In Development
Last Updated: 28 Nov 2018 08:19 by ADMIN

Currently, after export to excel and opening the exported file again in Spreadsheet, the row heights for rows with predefined height change. The above could be easily observed on the Index demo:

* initially, the height of the top row is set to 70px;

* export the Spreadsheet to Excel;

* after re-importing the above file, the height of the first row "Invoice #52" becomes 81px without any apparent reason.

Pending Review
Last Updated: 29 Dec 2018 16:20 by ADMIN

Hi,

When editing a workbook with the Spreadsheet component, if a user switches from a worksheet to another, then moves the scrollbars, when switching back, although the active cell is adequately recovered, the scrollbars are not (the user experience is that they do not react to worksheet switching).

Is this behavior planned to be changed? Is there a workaround?

Best

Pending Review
Last Updated: 06 Jul 2018 05:13 by Doug Hills
I have altered the kendo code to add row and column references to the k-spreadsheet-cell dom objects. A sample of this is: 
<div style="color: rgb(81, . . .  class="k-spreadsheet-cell r17c1 row-17 col-1"> . . . .
I have items that I wish to place on top of cells in the spreadsheet.
I can use these classes to identify the dom element corresponding to a spreadsheet cell object. I wish that this thing would let me post images. This is working really well. 
Request: It would be nice if the spreadsheet code to do this out of the box. Further, it would be beneficial to add a 'tag' property to a spreadsheet cell that would be indicated in the cell's dom object. If a cell has a tag, it should be rendered even if it doesn't have non-trivial formatting or a value.
Completed
Last Updated: 04 Jun 2019 09:24 by ADMIN
Currently the font sizes in the Spreadsheet are in pixels, while in Excel they are in points (pt). The values for the fontSize remains the same upon export / import. As a result, fonts in Excel appear lager than those in Spreadsheet.