Unplanned
Last Updated: 26 Feb 2020 15:31 by ADMIN
Created by: Imported User
Comments: 1
Category: Spreadsheet
Type: Feature Request
8
Integration of the pivot control with the spreadsheet
Unplanned
Last Updated: 26 Feb 2020 15:16 by ADMIN

1. The top tab section (with the Home, Insert, Data, Undo, Redo) button of the toolbar should be configurable to be hidden, i.e. "single toolbar" configuration should be supported. Since it is possible to configure the toolbar to show custom items, it should also be possible to hide other tabs and the undo/redo button and only have a single toolbar as the configuration.

/* Style hack to hide the "Home/Insert/Data" tabstrip at the top of the spreadsheet. */
.k-spreadsheet-tabstrip.k-tabstrip {
    & > ul {
        display: none;
    }

    & .k-content {
        border-top: 0px;
    }
}

/**
 * Style hack to hide the undo/redo buttons in the quick-access toolbar.
 */
.k-tabstrip-wrapper .k-spreadsheet-quick-access-toolbar {
    display: none;
}

Unplanned
Last Updated: 26 Feb 2020 15:14 by ADMIN
Created by: Brian
Comments: 1
Category: Spreadsheet
Type: Feature Request
0

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.

Unplanned
Last Updated: 26 Feb 2020 15:13 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

Unplanned
Last Updated: 26 Feb 2020 15:12 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

Unplanned
Last Updated: 26 Feb 2020 15:06 by ADMIN
Created by: kaan
Comments: 3
Category: Spreadsheet
Type: Feature Request
0

Hello,

Is is possible to trigger validation in cells in spreadsheet control? I want to make all validation controls with a button click outside the spreadsheet control.

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.
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.
Unplanned
Last Updated: 26 Feb 2020 14:44 by ADMIN
Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown
Unplanned
Last Updated: 26 Feb 2020 14:43 by ADMIN
Created by: Tushar
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
1. Formula selection dragging

2. Formula selection resize

Details: While using cell references in formulas in a cell, user should be able to drag and resize the referenced cell selection.

Refer the video present here for details.
<https://drive.google.com/file/d/0B2aXCYXjjcD9RDZpd0lScEV3UUk/view?usp=sharing>
Unplanned
Last Updated: 26 Feb 2020 14:33 by ADMIN
Created by: Richard
Comments: 0
Category: Spreadsheet
Type: Feature Request
1
WorksheetPageSetup would be a dialog in the kendo ui spreadsheet and persist when the work book is downloaded as Excel or pdf. 
The setup values would also be used to prepopulate the settings in the download dialog.

WorksheetPageSetup would be maintained when a server-side generated Telerik.Windows.Documents.Spreadsheet.Model.Workbook is converted to a Telerik.Web.Spreadsheet.Workbook by method FromDocument().

Page setup maintains settings for printing: orientation, scaling, margins, paper size, grid lines, column headings etc...
Unplanned
Last Updated: 26 Feb 2020 14:30 by ADMIN
Created by: Otto Neff
Comments: 3
Category: Spreadsheet
Type: Feature Request
2
Unplanned
Last Updated: 26 Feb 2020 14:28 by ADMIN
The spreadsheet widget should be able to take an imported .xlsx file, such as a preconstructed template, and update bound database tables if the fields match.
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:17 by ADMIN

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);
})
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: 25 Feb 2020 15:52 by ADMIN
Created by: Imported User
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
It would be nice to have text orientation support (at least vertical) like in MS Office.
Unplanned
Last Updated: 25 Feb 2020 15:47 by ADMIN
Created by: Prasadh
Comments: 0
Category: Spreadsheet
Type: Feature Request
2
IF any custom validation available for spreadsheet cells, then while exporting the sheet, those validation error messages or formats not getting exported. So here it will be helpful if its exports validations too. So user can see error in both UI and Exported file. 
In the below example, user can see the error messages in ui but cant see on the exported file. 
https://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/how-to/validation-to-column
1 2 3 4