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..
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.
The Excel file downloaded from Spreadsheet does not maintain leading spaces. In other words, the internal sharedString.xml should use <t xml:space="preserve"> when necessary.
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...
DefaultCellStyle property in spreadsheet has a field “Wrap”, but doesn’t have a field “Format”. For example, if I need to process all cells as text, I must set the field “Format” on a client side: sheet.range("A1:AX200").wrap(true).format("@"); It works. But the initialization of the range ("A1:AX200") takes time… It is not very fast… It would be better to have the field “Format” in the DefaultCellStyle property in spreadsheet…
We have clients with large spreadsheets that print out across multiple pages, which can mean losing track of which column refers to what on new pages after a page break, so they want to be able to assign a row of column headers to be printed on new pages above each column to keep track
E.g. italian culture uses ";" as parameter separator in formulae. Our client will adopt spreadsheet component on a global basis and users need to be able to e.g. copy/paste from excel to spreadsheet component using their culture
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.
add a double line border single or multiple cell.
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>
Expose a property on the range object of the spreadsheet component which shows whether a range is currently hidden or shown
Allowing custom editors to be inline would be very helpful. In particular, inline editors using other Kendo controls (e.g. masked textbox, numeric textbox) should be possible.
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.
I have a first example using the Kendo Toolbar widget and I was able to get an Angular button rendered in the toolbar: http://dojo.telerik.com/ucIfin When I tried to do the same thing in the Kendo Spreadsheet widget toolbar, it failed to compile my template: http://dojo.telerik.com/UseWI In general Angular directives are not compiled properly when specified in the template of a Spreadsheet Toolbar item. I am aware of a workaround for the kendo-button specific case, but I would like the template to work for custom Angular directives as well.
Need a default cell format, in addition to rowHeight and columnWidth including: - font size, - font-family, - font weight - (see other toolbar options) Default cell format would set the default values for all cells and toolbar options.
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.