Bug report
If there is a Spreadsheet on a given page and we scroll the page down using the mouse wheel, once the scrolling stops over the Spreadsheet and we try to continue it, we cannot do it. If the Spreadsheet has defined rows that are not currently visible when the mouse wheel is moved, then Spreadsheet is being scrolled, not the current page.
If the Spreadsheet has a lower number of pre-defined rows that are all displayed on the component's initialization the scrolling is again not applying to the page. Instead, moving the mouse wheel doesn't do anything until the mouse cursor is moved outside the Spreadsheet.
Reproduction of the problem
- Open this Dojo example and run it
- Move the mouse cursor in the middle of the pane displaying the compiled code.
- Use the mouse wheel to scroll down the page and stop the scrolling once the cursor is in the zone of the Spreadsheet
- Scroll down again
Current behavior
Because the cursor is inside the Spreadsheet the page cannot be scrolled. If the rows configuration is commented, when the scrolling is started again, the Spreadsheet data will be scrolled.
Expected/desired behavior
If all the data in the Spreadsheet is displayed, moving the mouse wheel over the component should result in page scrolling. If there is data in the Spreadsheet, there should be some way to prevent the scrolling inside the component.
Environment
- Kendo UI version: 2020.1.114
- jQuery version: x.y
- Browser: [all]
Bug report
When we want to add a formula in a given cell in the Spreadsheet, we double-click it and enter the "=" in it as an identifier that a formula definition will follow. If we want to include in the formula a cell that is not inside the visible range of the Spreadsheet, we scroll to that cell and select it. In Internet Explorer, if we scroll to a given cell using the arrows of the Spreadsheet's scrollbar the "double-clicked" cell becomes just a selected one and the "=" sign is converted to a string value.
Reproduction of the problem
- Open this Dojo example in Internet Explorer 11
- Select the A1 cell and enter "=" in it.
- Press the "down" direction arrow of the Spreadsheet trying to reach cell A50.
- With the first click on the arrow, the A1 cell is no more "double-clicked" and the "=" inside it is converted to a string
Current behavior
When building a formula in a given cell and trying to navigate to a cell using the scrollbar, this usage stops the formula building and converts the "=" into a string.
Expected/desired behavior
When a user creates a formula for a given cell, they should be able to navigate through the Spreadsheet using its scrollbars.
Environment
- Kendo UI version: 2019.2.619
- jQuery version: x.y
- Browser: IE 11.950.17134.0
Tested on demo-page. The export of an Excel-file containing defined names with a period such as "test.name" will result in an error.
Steps to reproduce:
- Create an Excel-file that has a defined name like "test.name"
- Open the file on the demo page
- Click on any of the "Save as..." buttons
- An error page is shown