Steps to reproduce the behavior:
step1: Make a cell become wrap text and text something
step2: Export to pdf file:
Text display same as on safari
Please fix this problem asap!!!.
Presently in Spreadsheet tooltip is not working for filter applied range so tooltip should display for each cell in which the range of filter is applied
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:
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
Use case: My app doesn't know how many rows of data the excel spreadsheet will be prior to upload. I've defaulted to my maximum amount of 10,000 which will be normal for some, but overkill for others. The ability to change the number of rows/columns to accommodate the size of the sheet after loading, would be a nice addition. As a workaround, I'm destroying and reloading the widget instance after the initial load.
Currently, when working on a mobile device, the Spreadsheet doesn't have all the functionalities available when working on a desktop machine.
Providing support for the merge cell, multi-cell selection & context menu opening when working on a mobile device will be very useful for the Spreadsheet.
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
Steps to reproduce the 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)
Add any other context about the bug.
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.
Spreadsheet throws error when opening a xlsx file containing diagonal borders.
Spreadsheet crashes and throws an error
Uncaught TypeError: Cannot set property 'color' of undefined
The file should open.
we have a requirement to disable comment option on click of few cells (which are disabled) or to show a toastr message on click of comment that user can't add comment on specific cell. Do you have any such feature or event to track this requirement .
It should be possible to define cell types (or types that are valid for the entire column) like: - Booleans (which will result in showing check boxes inside the cells)
I would like to request the Kendo UI Spreadsheet to be able to validate by Text Length instead of using custom validation. This would help with importing xlsx files which have text length validation.
Column lines disappear and row lines appear (columns G, M, N, O). In Chrome values disappear as well, observe the value in column F. The configuration options required for reproducing the behavior are mergedCells and frozenRows.
No changes to the column/row lines and no disappearing values on scrolling.
When using the bottom right corner of a cell to batch copy values across a range by dragging the corner, an error popup appears if a disabled cell is found inside the range that was dragged into. It is possible to reproduce this with this demo: https://demos.telerik.com/kendo-ui/spreadsheet/disabled-cells 1. Set the quantity column to disabled. 2. Select B3. 3. Drag the bottom right corner of B3 to D3. 4. See error: "Destination range contains disabled cells." There should be an option to allow that to copy into any enabled cells in that range and ignore the disabled ones.
Enable Cut/Copy cell values and can Paste it in mutiple selected values
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.
Custom validation error can not be handled in spreadsheet
go to Data->Data Validation->Custom Formula (Ignore blank, Reject input),
open the console,
than if you enter an invalid formula (<4, >A3 or something like this) and press Apply, in the console you can see an exception
The exception can't be handled
One should be able to handle the exception
workaround - https://dojo.telerik.com/@zdravkov/adEWOlOk
Support scenarios where users can use the spreadsheet component to design templates with disabled cells. I appreciate that this can be customized (as almost anything) but note this is the only cell property that is not configurable via the toolbar.