Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Start editing cells D3 to D11 as fast as possible (like type 45 enter, 45 enter, 45 enter and so on) (refer attached videos)
3. UI freezes for few seconds, and then all cells get updated in one go
4. But Excel 365, Excel and GoogleSheet work fine in such cases
5. Please make similar UI behavior as in Excel.
Check attached Excel Data Entry & Kendo Data Entry video recordings
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Upload the attached sample.xlsx file.
3. Cell B1 getting value from cell A1 using formula "=TEXT(A1, "$#,###")"
4. Delete(Blank) the value of cell A1, see error #VALUE! in cell B1.
5. The same is working fine in Excel.
6. Please suggest any workaround or quick fix.
Check attached Sample.xlsx file in Sample.zip folder
Hi,
Would like to suggest 2 features for the spreadsheet which will be very useful
1) Ability to delete specific cell (not just the content, but the cell itself). Currently there is way to delete row or columns, but no cell deletion. When cell is deleted, user should be prompted whether to allow all cells below the deleted cell to shift up, or all cells on the right of it to shift left. Akin to excel
2) Format painter. The ability to "paint" the styles (such as font size, boldness) from existing text to another existing text. Akin to excel.
Hello there,
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.
For example:
I have the following numbers on a Excel sheet:
1 | 0.5 | 0.333333333 | 0.25 | 0.2 | 0.166667 | 0.142857 | 0.125 | 0.111111 | 0.1 | 0.090909 | 0.083333 | 0.076923 | 0.071429 | 0.066667 | 0.0625 | 0.058824 | 0.055556 | 0.052632 |
Then, I copy them to the Kendo spreadsheet and I got the following:
100.00% | 50.00% | 33.33% | 25.00% | 20.00% | 16.67% | 14.29% | 12.50% | 11.11% | 10.00% | 9.09% | 8.33% | 7.69% | 7.14% | 6.67% | 6.25% | 5.88% | 5.56% | 5.26% |
But when I copy them back to Excel I got this:
1 | 0.5 | 0.3333 | 0.25 | 0.2 | 0.1667 | 0.1429 | 0.125 | 0.1111 | 0.1 | 0.0909 | 0.0833 | 0.0769 | 0.0714 | 0.0667 | 0.0625 | 0.0588 | 0.0556 | 0.0526 |
Losing many decimals affecting the results of my computation and calculation.
Can you tell me why is this happening?
Thank you some much.