1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Move horizontal scroller to column P
3. Now select Row 1 header, then row 2 header and keep doing it
4. Please observe horizontal scroller is also moving towards left
I assume it is a bug and need a fix. Meanwhile if you can provide a workaround for the same if possible.
Note: Similar behavior can be noted for vertical scroller on column header selection
Dear Concerned,
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Select column B and drag mouse towards C, both columns will be selected which is correct behavior
3. Now just scroll down 2-3 rows using vertical scroll bar
4. Repeat step 2, this time it does not select B & C, instead it selects B,C,D,E.
5. Seems a bug, not an expected behavior.
Observation that might help you in fixing it:
1. if you move scroll bar in such a way so that no merged cell is visible it works well, e.g. scroll down till 20th row becomes first visible row on screen and now repeat step 2, it will work
2. if scroll position is on top then behavior is correct as well
3. Same issue exists in case of multiple row selection with merged column and scroll position.
Bug report
Reproduction of the problem
Dojo example.
Current behavior
The first row is duplicated.
Expected/desired behavior
The first row is not duplicated
Environment
- Kendo UI version: 2019.3.1023
- jQuery version: x.y
- Browser: [all]
Bug report
Office 365 Comment are shown with a warning:
"[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
Reproduction of the problem
go to demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
Current behavior
import a file from ticket - 1447268
A warning is displayed
Expected/desired behavior
No warning is displayed
Environment
- **Kendo UI version: 2019.3.1023
Bug report
The wrap text tool hides some of the cell's text if it is too long.
Reproduction of the problem
Go to this Dojo. Select cell A1 and toggle the wrap text tool. The beginning of the text is not displayed.
Current behavior
Part of the cell's content is hidden.
Expected/desired behavior
All the text should be visible.
Environment
- Kendo UI version: 2019.3.1023
- Browser: [all]
Bug report
Reproduction of the problem
Reproducible in the demos.
- Use the HYPERLINK function in a cell:
=HYPERLINK("https://google.com")
Current behavior
The link does not work. It does if you specify a "friendly name":
=HYPERLINK("https://google.com", "google")
Expected/desired behavior
The link works with and without a "friendly name" specified, as in Excel.
Environment
- Kendo UI version: 2019.2.619
- jQuery version: x.y
- Browser: [all]
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.