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.
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.
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.
Hi Team,
I would like to request the Kendo UI Spreadsheet to include JSZip 3.x functionality for future releases.
Thank you!
In MS Excel when you type a number you can easily go to other cells by using the arrow keys and type in another number, thus allowing for fast editing of the spreadsheet. This does not work in the spreadsheet component. this functionality only needs to work when not creating a formula.
can add float object container ? eg:charts
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.
The current context menu lets you hide a row or column, but then you cannot show it again, so the user can lose data. At present there is no context menu option to unhide it and there is no element indicating the column/row was there in the first place. This should behave like in Excel.
Set Fixed Cols/Rows etc. or setOptions( {filter: { ref: "A3:G49", columns:[]}});