It would be useful if copy and paste the data have the option of fill the series or copy the value for the date format. Furthermore, copy from multiple column value and allow to paste multiple copied value from the spreadsheet will be added advantage. Thanks.
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.
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.
Add ability to add group multiple columns and add a group header for those columns.
Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown
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>
The spreadsheet doesn't provide any configuration options for the font size unit; it is always in pixels. I need to be able to specify other CSS units, such as points or ems.
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...
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.
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..
type =IF( "a"="A" ; 1 ; 0 ) and =IF( EXACT("a";"A") ; 1 ; 0 ) into Kendo Spreadsheet and Google Spreadsheet and MS Excel. There is a special EXACT function (which is also available in Kendo) to enforce case-sensitivity. By default it should be off.
It would be great to be able to put buttons inside a cell or merged cell for atomic functionality. Actually I would really need it for a project we are working on at our company.
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.
Hi,
I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).
When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.
Editing an empty row above this new row will modify one of the records created in this process.
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
Hello,
We are using Spreadsheet widget in our system and have following questions to meet the demands of our customers:
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?