Describe the bug
To reproduce
Steps to reproduce the behavior:
Expected behavior
The panes are frozen without breaking the layout of the Spreadsheet and without cells/column duplication.
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Build system information (please remove the unneeded items)
Additional context
Add any other context about the bug.
When values are pasted in the Spreadsheet if the cell is not empty the previous format is taken into account
The number column is formatted as date - screencast(https://somup.com/cZeoodChyH)
The current format should be applied to the pasted data.
When the Sheetsbar is hidden the horizontal scrollbar is not adjusted to the bottom of the widget
The horizontal scrollbar should be adjusted to the bottom of the widget.
As a possible workaround, when hiding the Sheetsbar add the following styling:
<style>
.k-spreadsheet-sheets-bar {
padding: 0;
border-style: none;
}
</style>
When you copy a formatted cell with value "0", pasting the content in the Spreadsheet results in an incorrect value in the formula input.
The value of the cells containing "-" are incorrectly changed to "-" in the formula bar.
The value of the cells containing "-" should remain "0" in the formula bar.
When there is formatting and decimals are rounded negative numbers that round to zero show a negative sign. In Excel those are shown without the negative sign.
Dojo example: https://dojo.telerik.com/@iankodj/azEMIRUv/21
When values in the sheet are updated using the batch method the DataSource does not update according to changes.
Dojo: https://dojo.telerik.com/@iankodj/IRUdufOx
1. Run the example
2. Check the console showing "no data" and an empty array.
In Spreadsheet, the cell format is lost when you change its value.
The new value is not rounded as per the preset format.
The new value should respect the format set for the cell.
When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.
The value entered for the cells below is SS13, SS14 etc.
The value entered for the cells should be SS0012, SS0013 etc.
Bug report
Round Function from empty cell shows #VALUE! but in Excel, this shows 0
Reproduction of the problem
Open Dojo: https://dojo.telerik.com/aBOMoCOF
Paste in cell B1 the following formula: =ROUND(A1, 2)
The shown result is #VALUE!
In Excel the same formula returns 0
Expected/desired behavior
The shown value must be 0
Environment
Kendo UI version: [all]
Browser: [all ]
### Bug report
When the property "useCultureDecimals" is enabled in a culture where the decimal separator is the comma, the function Text() does not format numbers correctly.
### Reproduction of the problem
1. Set a culture where the decimal separator is the comma (i.e. "da-DK");
2. Create a Spreadsheet and enable the property "useCultureDecimals";
3. Enter a number with a decimal separator comma (i.e. "0,1141");
4. Format the cell by using the Text() function ( =TEXT(A1; "##0,00%") );
5. The number is not formatted properly - "011%"
A Dojo sample for reproduction: https://dojo.telerik.com/AsiLiKil/12
### Expected/desired behavior
"0,1141" should be formatted as "11,41%" as in Excel.
### Environment
* **Kendo UI version: 2021.3.914
* **jQuery version: 1.12.4
* **Browser: [all]
After pasting values from the Kendo UI Spreadsheet to Excel, making a change in Excel, and pasting the value back to a Kendo UI Spreadsheet, it pastes old information.
The new values are not pasted back to the Kendo UI Spreadsheet.
When trying to select multiple cells in Spreadsheet, an error "n._ref.height is not a function" occurs.
Regression introduced with R3 2021.
An error "n._ref.height is not a function" occurs and cells are not selected.
No error should occur and cells should be selected.
Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.
The value of the B1:B2 merged cell is not displayed.
The value of the B1:B2 merged cell should be displayed.
When pasting content to a Spreadsheet that has only one column(columns: 1), the data is not pasted in the targeted cell and a JS error appears in the browser's console.
The issue appears only in scenarios where the columns configuration is set to 1.
No data is pasted in the selected cell and the below error appears in the console:
The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.
Open this web site:
https://demos.telerik.com/kendo-ui/spreadsheet/datasource
And follow the steps provided here:
https://www.screencast.com/t/UdEKYqIve
The first added cell value (or row) is removed when the user deletes an empty row.
If the ID is entered, the result is even stranger:
https://www.screencast.com/t/osmVOiY7al
It should behave and function like Excel. I think with local/static binding there are no issues.
When an Excel File that contains VLOOKUP and calculated columns is imported in Excel, this results to CIRCULAR value for the cells, although ther are no circular formulas in the file.
The values in the Spreadsheet are imported as '#CIRCULAR' although there are no circular formulas.
When the VLOOKUP in cell L2 is deleted the values are imported as '#VALUE'
The values in the Excel file should be imported correctly.
The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.
Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.
If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.
When the select() method is used in the Spreadsheet changing event wrong cell is selected.
Changing event is fired, but the 'B3' cell is selected instead of the 'B2'
The correct cell should be selected when using the select method inside the Spreadsheet event handlers.
Spreadsheet: Improper copy paste to Excel when merged cells are present and one column in the merged cells range is hidden. If the column containing the first merged cell is hidden all the rows on that row will be shifted to the left.
After pasting, the merged cell consists of 4 cells, as expected, but the cell data is shifted to the left and the hidden column contains the cell data of the next column
The cells after the merged cell should not be shifted.
In Firefox with Windows 11, the Spreadsheet cannot be scrolled using the scrollbars.
The Spreadsheet cannot be scrolled through the scrollbars
The Spreadsheet should be scrolled through the scrollbars