In percent-formatted cells, Excel will place a '%' as the user types. This allows 50% to be entered as '50'. Steps (excel and kendo): 1. Format a cell as percent 2. Enter 50 Excel shows "50.00%". The actual value is .5 Kendo widget shows "5000.00%". The actual value is 50
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.
I have altered the kendo code to add row and column references to the k-spreadsheet-cell dom objects. A sample of this is: <div style="color: rgb(81, . . . class="k-spreadsheet-cell r17c1 row-17 col-1"> . . . . I have items that I wish to place on top of cells in the spreadsheet. I can use these classes to identify the dom element corresponding to a spreadsheet cell object. I wish that this thing would let me post images. This is working really well. Request: It would be nice if the spreadsheet code to do this out of the box. Further, it would be beneficial to add a 'tag' property to a spreadsheet cell that would be indicated in the cell's dom object. If a cell has a tag, it should be rendered even if it doesn't have non-trivial formatting or a value.
Hi Progress - just some quick feedback: 1. Telerik Control Panel updates - it feels like a lot of the time, when the TCP needs updating the user has to manually uninstall the old version and the install the new one using the .exe installer. If the TCP could automatically handle this process, that would be appreciated. 2. The various Telerik Spread Processing libraries (and other document processing libraries) can only be installed as an included component of the Telerik "UI for X" library installations. It would be great if there was an option in the TCP to do a standalone installation of just the Spread Processing libraries. Thanks and kind regards, - Lawrence
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.
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...
I want to know the combination keys that generate the paste event Thx,
Hi again :)
I see that in the configuration I can specify the max number of rows/column. However, I can do it per component basis, and I would like to have that on a per-sheet basis. Any way I can implement this?
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.
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
When typing a formula and selecting another cell in Excel we can press F2 to be able to change the formula manually, however when using the spreadsheet when trying to change the formula with the arrow left or right button we select another cell.