When using IE 11 and using Ctrl+X to cut, this only works the first time. All subsequent attempts to use cut produce the following dialog:
Reproducible in the demos.
The link does not work. It does if you specify a "friendly name":
The link works with and without a "friendly name" specified, as in Excel.
The current client-side export functionality does not preserve the number of columns.
Load the following file in the Spreadsheet which contains columns up to "BA".
Export the file
Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".
Client-side export does not preserve the number of columns greater than "AX".
Client-side export does not preserve the exact number of columns.
When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.
=SUBSTITUTE(A1, "ab", "")
ab with another string, e.g.
cd, replaces all instances of
ab as expected.
113ab11 - when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string
When destroying a SpreadSheet and removing its corresponding DOM element, there are some DOM nodes added on SpreadSheet's initialization which are not removed after the execution of .destroy() and .remove().
Not all DOM elements added on SpreadSheet initialization are being removed when destroying it and removing its corresponding DOM element.
After destroying a SpreadSheet and removing its corresponding DOM element, no DOM nodes added on component's initialization should be presented in the DOM tree.
Errors are encountered. Even if resolving the errors bold styles are not applied as they are part of the font definition and not of the inlineStyles.
The excel is imported as expected.
2. Open Workbook(1).xlsx (attached)
3. Edit B2, D2, F2 with some new values
4. See the results in B4, D4, F4
Calculations are different in Excel.
2. Try to select columns B to D using mouse
3. Click on column B, keeping mouse clicked, move your mouse towards C then D
4. It does not allow to select B,C,D where as it is possible in Excel.
It is serious issue for me as I could not proceed with Hide/Unhide columns and some other features depend on multiple columns selection
Note: if we add a blank row at first position then it works well, seems like first with merged columns is creating problem.
I made research about Kendo Spreadsheet control and I found some of unlogical things in example:
1. When I made changes (kendoSpreadsheetCancelChanges.png) in spreadsheet and click on CANCEL CHANGES button, all of these changes aren't removed.
2. Manually reading spreadsheet datasource, all of these changes aren't removed. For example, when I type in console
$("#spreadsheet").data("kendoSpreadsheet").options.sheets.dataSource.read();, datasource is reading, but almost all changes are shown. Why?
I am developing a Web application using Kendo UI Spreadsheet control, but I noticed that when I copy some numbers from a Excel sheet to the spreadsheet and then copy back to Excel, the decimal values are quite different, I mean, the decimal precision has been affected.
I have the following numbers on a Excel sheet:
Then, I copy them to the Kendo spreadsheet and I got the following:
But when I copy them back to Excel I got this:
Losing many decimals affecting the results of my computation and calculation.
Can you tell me why is this happening?
Thank you some much.