Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.
Memory usage increased and slower sheet change.
Memory usage should not be increased and sheet navigation should not be slow.
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.
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 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>
The spreadsheet currently relies on the <v> tag and doesn't accept cell type "inlineStr". Here is an article with more info regarding the inlineStr type:
https://c-rex.net/projects/samples/ooxml/e1/Part4/OOXML_P4_DOCX_c_topic_ID0E1XM4.html
A cell of type "inlineStr" which is currently not accepted in SpredSheet
<c r="F2" s="4" t="inlineStr">
<is>
<t>1005131528</t>
</is>
</c>
while the format saved from excel is accepted:
<c r="F2" s="2" t="s">
<v>12</v>
</c>
Ticket ID: 1517963
Scrolling to a column that is not visible initially and using the Freeze Panes tool, makes the scrollbar of the Spreadsheet unusable. This valid for both horizontal and vertical scrolling. It is observable in the demos: https://demos.telerik.com/kendo-ui/spreadsheet/index
Scroll right to the "R" column. Select it and click on the the "Freeze panes" tool in the toolbar.
Alternatively, scroll down to row 30. Select a cell and click on the the "Freeze panes" tool.
As a result, scrolling the columns (respectively the rows) becomes impossible.
Consider a way to enhance the Freeze panes functionality, so that is is usable in these scenarios.
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.
Hi Team,
When I add comments to enabled columns(product)it is allowing me to add and after reopening the comments it is retained. But when I add comments to disabled columns(ID) it is not adding to it and no messages are added like it is disabled and comments are not allowed.
demo: https://dojo.telerik.com/ISIvATiN
thanks.
Currently, Kendo UI for jQuery Spreadsheet does not support many events such as style change, merge, unmerge, image insert, font change, alignment change, decimal change, filters and more.
But these events need to be captured in many cases.
Please support events for all the actions.
Currently, when an invalid validation formula is used, the Spreadsheet throws a js exception.
For example: https://dojo.telerik.com/AWEyIHoW
Open the Data/Data Validation dialogue on cell A3 and modify the Value of the Formula into an Invalid formula (e.g. : “>3”)
A parse error is thrown.
It would be a nice improvement, if instead of throwing a js exception, the user is notified about the invalid formula through a dialog showing a relevant message.
Can you add feature or set option to allow text to run into adjacent cells to right?
(example in ticket 1500102)
Hi Team,
I'd like to request a built in method for finding the intersection of ranges for the Kendo UI Spreadsheet.
Thank you
Hi Team,
I would like to request the ability to set an autoFit for the rows/columns(specific or all). This would not just related to wrapping.
For example, in the following Progress Kendo UI Dojo, the user can create 3 lines by button press. But if the user replaces the contents with 1 line of text, it will keep the height of when the 3 lines were in cell.
I know I could use the rowHeight method, but it would be great if there was a way for it to resize automatically.
Thank you for your consideration.
Related to this ticket View Ticket | Your Account (telerik.com) (id: 1605513)
Basically, when all the rows fit in the viewport, the horizontal scrollbar should be entirely hidden instead of always visible.
In the Spreadsheet, if you freeze too many columns and then try to export to Excel, the file is corrupted.
If you reduce the number of columns in the example below, the issue does not occur.
The exported file is corrupted and cannot be opened
The file should not be corrupted
Hi
Is it possible to only move between "open cells for input. " With fx. using tab or enter.
When you are input finance data. It would be nice, that with a tab, it only moves between open cell. Is this possible.
On all browser, but mainly edge, chrome ,
reg. jakob
Currently, when a custom button is configured in the Spreadsheet toolbar a separator is added before the button. I would like to have an option to configure whether such a separator is to be rendered or not.
I would like to avoid adding custom styles for hiding unneeded separators, which is needed with the current implementation (Dojo).
Hello,
Is is possible to trigger validation in cells in spreadsheet control? I want to make all validation controls with a button click outside the spreadsheet control.