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>
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.
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.
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?
It would be nice to have text orientation support (at least vertical) like in MS Office.
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
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…
By default the items in filter are in random order. Can we sort the items in ascending order by default.
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.
add indent property to spreadsheet cells to closer match excel
Currently only the global culture is used to parse dates. This behavior differs from Excel as I can enter 1/1/19 to parse to 1/1/2019. I would like the widget to format using the chosen date culture (mm/dd/yyyy), but parse in an optional way, such as mm/dd/yy.
add a double line border single or multiple cell.
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.
Ability to dynamically bound the DropDown editor to an array of objects
I would like to be able to do conditional formatting against other columns and not just the existing conditional formatting. For example: Column 1 = 1.2 Column 2 = 1.5 If the value of Column 2 is greater than the value of Column 1, I want the color to be green. If the value of Column 2 is less than the value of Column 1, I want the color to be red. If the value of Column 2 is equal to the value of Column 1, I want the color to be black.