The filtering on the spreadsheet component is great!!
There is however one behaviour that causes confusion for end users, and that is filtering when merged cells are present in the selection.
An example is available in the following dojo:
https://dojo.telerik.com/UzUMUDos
Open the dojo and filter column A on a1 and you will only see only b1 in column B, but the b1a will not be shown.
To be clear - This is also how Excel behaves... (which is of course your prime aim so its not a bug as such)...
Interestingly google sheets stops you putting filter on merged cells / stops you merging on filtered column.
The Excel behavior is discussed in the following threads:
https://stackoverflow.com/questions/49816515/excel-filtering-for-merged-cells
https://www.officetooltips.com/excel_2013/tips/workaround_for_sorting_and_filtering_of_merged_cells.html
Is it possible to implement something, so the end user experience would be improved? Maybe when merged cells are present :
a) if they click filter, this is detect and user is warned of this behaviour
b) if they click filter, the sheet is changed into an unmerged version (which repeats data in merged cells) as in the excel examples above.
Reported in ticket № 1429260
The date is pasted as string with value of hash tags.
The date is pasted as a date
The e.ClipboardContent.data contains the hash tag string as value, so the issue should be somewhere in the clipboard pasting logic
I am using kendo spreadsheet binding to a datasource... very similar to the demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource
Is there a way to add a two row header while binding to a data source? For example, my first row would be a merged cell spanning all columns and would contain some text. I can see how to do two row headers and to merge cells.. but it doesn't work when the spreadsheet is bound to a datasource as it starts the data in row 2.... where I want row 2 to be my actual field name headers. I don't see any options to fix that.
If there is no way to do that... is there a way to alter my header style? For example, I want a column header to be
MY FIELD NAME HERE
additional text (smaller font and color)
I know in kendo grid there is headerTemplate... but this doesn't seem to be available in kendo spreadsheet.
Thank you.
The spreadsheet widget has no Polish localization.
Feel free to use those: https://github.com/telerik/kendo-ui-core/pull/5310
Dates and times entered (or pasted) in the spreadsheet are incorrectly parsed and do not respect the specified format. For example, dd.MM.yyyy HH:mm becomes MM.dd.yyyy HH:mm. The issue is replicated even if a culture is set.
The Spreadsheet does not parse the dates correctly.
10.01.2022 09:00 (january 10th) becomes 01.10.2022 09:00 (october 1st)
13.01.2022 09:00 is not affected by this issue.
10.01.2022 (january 10th, without time) is not affected by this issue.
Spreadsheet should parse the dates as they are. Copy dates such as 10.01.2022 09:00 should remain 10.01.2022 09:00 without switching the month and date values
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).
When a border is applied and there are frozen rows/columns the border appears splitted with a white lin in the middle.
The bottom border and the right border are split with a white line in the middle.
The border should appear entirely filled with the selected color.
Hyperlinks in a Spreadsheet cell do not work mobile devices.
The link in the cell does not work.
The link should work
Spreadsheet doеs not allow selecting of multiple cells when opened on Microsoft Surface. It is also not possible to resize columns.
Issue 1
Issue 2
In the Spreadsheet Index demo select a column. Try to place the mouse in between columns for the icon to be changed and to will be able to resize the column.
Currently, the selection in the Spreadsheet could not be expanded to multiple cells and the columns could not be resized when the Spreadsheet is used on a Microsoft Surface device.
The Spreadsheet should allow selecting multiple cells and resizing columns when opened on a Microsoft Surface device.
Excel supports deselecting cells from selected ranges, e.g. selecting a range from cell A1 to A10 results in a range A1:A10. Then deselecting cell A5 from that range produces two new ranges - A1:A4 and A6:A10.
Now a more complex example - selecting multiple ranges with intersecting cells - A1:B10, A5:D10, A9:C14 and A9:G9.
Deselecting
cell B9 in Excel produces a new range with cell A9 only and then a range
C9:G9. And B9 should be excluded from the other 3 ranges.
Currently the Spreadsheet widget does not know how to do this. There is no logic to decide what new ranges should be created on such operation. What it currently knows is creating new ranges and these ranges may overlap. Thus clicking on cell B9 creates a new range with cell B9, instead of deselecting B9 from the already selected ranges.
When defaultCellStyle is used the configured font is applied to the cells in the Spreadsheet. However, the font is not applied when adding new rows.
The configured font in the defaultCellStyle is not taken into account. The font in the newly inserted row is Arial 12, while in the example it should be 'Courier New' 18.
The font configured by using the defaultCellStyle option should be applied to all cells in the Spreadsheet, even if inserted after initialization.
When the Spreadsheet is bound to a DataSource upon making multiple selections in the Spreadsheet and deleting the selected ranges a JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.
A JavaScript error is thrown: "Unsupported for multiple ranges." The selected cells are deleted on the UI, but the DataSource change event is not triggered.
Upon an attempt to delete multiple selections a popup should be displayed with a warning that this operation is not supported, similar to trying Copy/Paste multiple selections.
When an Excel file with 'Set precision as displayed' option enabled is imported in the Spreadsheet the calculations are not the same as in the Excel file.
Reproduction:
1. Open the Spreadsheet demo
2. Import the excel file from the zip. in the Excel file the following option is enabled - File->Options->Advanced->When Calculating this workbook-> Set precision as displayed
The value in Excel in C1 column is 399.96, while the value displayed in the Spreadsheet is 400.00
I would like to have support in Spreadsheet for Excel files with 'Set precision as displayed' option enabled.
Hello
When we have filtered rows in a spreadsheet (some rows are hidden) and we copy a single cell and paste into a range containing the hidden rows....
The spreadsheet copies the value into all cells in the range including those that are hidden. This is not the same functionality as Excel.
That said, is the any way to skip hidden cells in the paste range?
Is there a way to override the Kendo past function to do this? Can you provide an example?
Thank you
Jeffrey Suffet
In my application I am using the following.
kendo.ns="kendo-";
Dojo example: https://dojo.telerik.com/@iankodj/aKIyEwUv
The spreadsheet component works well with the namespace, however any dialogs that the component opens do not function correctly.
For example, I am using Edge browser. If I copy a cell and they try and past the value via the context menu, a dialog appears telling me to use the keyboard.
The "ok" button of the dialog does not work. Looking at the html source that is added to the DOM, it appears that the button is trying to bind to the click event via a "data-bind" attribute rather than a "data-kendo-bind" attribute as specified via the namespace.
The attached file show the behavior with the Basic demo example having the kendo namespace set.
Thanks,
Darin
Describe the bug
When the Spreadsheet has locked columns and columnWidth is set, but the width of the locked exceed the width of the Spreadsheet, the widget is not rendered correctly.
To reproduce
Steps to reproduce the behavior:
The columns of the Spreadsheet are visible even outside of the component.
Expected behavior
The columns should be limited to the Spreadsheet width
Affected package (please remove the unneeded items)
Affected suites (please remove the unneeded items)
Affected browsers (please remove the unneeded items)
Currently, the Spreadsheet does not appear and does not function properly when the 'k-rtl' class is applied.
Please provide Right-To-Left support for the Spreadsheet widget.
There is no TypeScript definition for defineFunction and no custom functions can be created in TypeScript context using the approach demonstrated in this Custom functions article.
Try defining a new function using:
kendo.spreadsheet.defineFunction("Mask",mask).args(maskArgs)
The following error appears:
Propery "defineFunction" does not exist on type 'typeof spreadsheet'
There shouldn't be any errors
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.