Duplicated
Last Updated: 26 Feb 2020 14:27 by ADMIN
total row count should display on footer like in excel , row count should change after each filter , also option for to add "action link" to the columns so that we can navigate/popup to other pages..
Unplanned
Last Updated: 26 Feb 2020 14:18 by ADMIN
When we use custom validation for a cell using below method
kendo.spreadsheet.defineFunction("CUSTOM_VALIDATION", function(num){});
its triggered for each cell. Let say i have applied this validation method for 100 cells. If i changed any one cell then this method got invoked 100 times. Instead it should execute single time i.e, for that changed cell only. We cant keep 100 different methods for 100 cells. This will impact more on performance. Please look it on this and fix accordingly. 
This feature will be helpful for complex usage.
Unplanned
Last Updated: 26 Feb 2020 14:09 by ADMIN
Created by: Dave
Comments: 2
Category: Spreadsheet
Type: Feature Request
1

The sheets bar should be configurable with some configuration options to control the ability to..

1. Add sheets

2. Remove sheets

3. Rename sheets

4. Reorder sheets


Unplanned
Last Updated: 26 Feb 2020 14:08 by ADMIN
Created by: Dimitar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Provide support for zooming the Spreadsheet's cells grid similar to the one provided by Excel.
Unplanned
Last Updated: 26 Feb 2020 14:07 by ADMIN

Hello,

We are using Spreadsheet widget in our system and have following questions to meet the demands of our customers:

  1. How can the filters be limited to valid choices by type of column? For example a numeric column does not need Filter By Condition options by date or by text containing values.
  2. On initial drop down of the filter the Filter by Value section opens, since most of our columns are numeric that isn't useful. How could we collapse the filter by value option on initial opening of the filter?

Currently we use spreadsheet filtering configuration according to this example:

            $("#spreadsheet").kendoSpreadsheet({
                sheets: [
                {
                    name: "OrdersLog",
                    mergedCells: [
                        "A1:G1",
                        "A2:F2"
                    ],
                    filter: {
                        ref: "A3:G49",
                        columns:[]
                    },

Can you please provide us with working examples of configuration (or required code adjustments) that will help us to meet the requrements above?

Unplanned
Last Updated: 07 Feb 2020 21:16 by ADMIN
Created by: George
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Ability to set a cell with font Strikethrough
Unplanned
Last Updated: 26 Feb 2020 15:14 by ADMIN
Created by: Brian
Comments: 1
Category: Spreadsheet
Type: Feature Request
1

It would be nice to have custom attributes for rows and cells so that I can track things behind the scenes such as row identifiers that could be used to update a corresponding rows in a the data base. This id would not be editable by the user. There are many more uses I would like this for and that is just one example.

I would rather not have to create a column in the spreadsheet just for this and then hide it. I find that very clunky.

 

Thanks.

Declined
Last Updated: 26 Feb 2020 14:16 by ADMIN
Please see Demo https://dojo.telerik.com/UNOPUvaB/2

In first data row (Row 3) I create a range of numeric values from a , middle and maximum value.
Validation works perfectly, e.g. when manipulating the Middle value, I cannot go below minimum cell value and not above maximum cell value, until adjusted.

I want to accomplish the same with dates in second data row (Row 4 when I reference another "C4", it looks like validation works as expected, but the Date Picker is broken.
Under Review
Last Updated: 26 Feb 2020 14:50 by ADMIN
Presently in Spreadsheet tooltip is not working for filter applied range 
so tooltip should display for each cell in which the range of filter is applied
Unplanned
Last Updated: 26 Feb 2020 14:56 by ADMIN
Created by: SHIVANG
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
I am working on a project where i am using KendoUI components. I have to show a financial sheet. All formulas are working fine like SUM,INDIRECT etc. but IRR not working as expected.

Tested IRR formula outside my project and the same happened.
Declined
Last Updated: 26 Feb 2020 14:54 by ADMIN
Created by: Victor
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
I need the way to get a user the opportunity to set the columns headers. Moreover, the columns headers should be saved separately from the main spreadsheet data.

Of course, the possible variant is to have two spreadsheets: the one – for the data, the second (with one row) – for the headers.

But the better way is to get a user the opportunity to set the spreadsheet columns headers.
It would be ideally if a user could change “A”, “B”, “C” for “ID”, “Product”, “Quantity” …
Not to have a first row for headers, but change the spreadsheet columns headers!
Moreover, we have the context menu on the columns headers and it is possible to add one more item “Edit” in it.
Unplanned
Last Updated: 26 Feb 2020 14:48 by ADMIN
Created by: Ashvinkumar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
Add ability to add group multiple columns and add a group header for those columns.
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.
Declined
Last Updated: 26 Feb 2020 14:05 by ADMIN
This will help doing data entry in column for scenarios like entering tax details for different years in columns and also user can keep on entering new year info in rew-row right most column.
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
Declined
Last Updated: 27 Feb 2020 16:06 by ADMIN
Created by: Robert
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Add menu item that allows end users to style background and text color based on rules (if cell value > 0 then green)
Declined
Last Updated: 26 Feb 2020 14:01 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
It would be great if there is a cell (and column) type that lets you choose from a defined list (manually defined list or based on a cell-range). It should be possible to make multple selections and the output should be put into the cell separated with semi-colons.
Declined
Last Updated: 26 Feb 2020 14:46 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
1
Declined
Last Updated: 27 Feb 2020 16:04 by ADMIN
Declined
Last Updated: 26 Feb 2020 14:03 by ADMIN
Created by: Otto Neff
Comments: 1
Category: Spreadsheet
Type: Feature Request
1