Dear Concerned,
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import attached Book21.xlsx file
3. I have first row as frozen pane and columns C, D are hidden
4. Select columns B to E using mouse drag & then right click on selected column , it does not show Unhide option, because on right click it keeps the selection only on column E
It does not work if we keep Freeze Panes.
Hi team,
In kendo spreadsheet if you disable any row by adding enable property to false and apply sort from data tab, then the disable row is changing based on the sort. instead of applying to particular row it is applying to perticular range and while sorting the row items are changing. The cell properties are not applying there while sorting.
link for example: https://dojo.telerik.com/IkoJeMIz
please let me know if I am doing anything wrong here.
thanks.
The wrap text tool hides some of the cell's text if it is too long.
Go to this Dojo. Select cell A1 and toggle the wrap text tool. The beginning of the text is not displayed.
Part of the cell's content is hidden.
All the text should be visible.
The FromJson method of Telerik.Web.Spreadsheet.Workbook doesn't add images when a JSON containing an image blob is passed to it.
It would be nice if the FromJson method supports images.
Hi Team,
I have getting warning message when open down loaded excel file . This warning is coming if we apply conditional formatting in kendo spreadsheet .Please
check the URL
I would like to be able to generate PDF from spreadsheet using HTML template (like http://dojo.telerik.com/Ovegu), so i could specify headers and footers for all PDFs that are created by the user.
Bug report
Spreadsheet SUMIF function returns #NA when Excel returns the correct result. The issue is observed when the criteria range and sum range have different sizes.
Reproduction of the problem
Run the Spreadsheet demo page
Open the attached file
Formula in cell B3 returns #NA!
Current behavior
The formula in cell B3 returns #NA!
Expected/desired behavior
The formula in cell B3 should return the correct value
Environment
Kendo UI version: 2019.3.1023
Browser: [all]
Hi Kendo Team,
The exported excel file from spreadsheet can not be opened in Microsoft excel when the spreadsheet has both a comment and a image.
You can reproduce the issue at your demo site https://demos.telerik.com/kendo-ui/spreadsheet/index
First add a comment for cell D3, then add a image, then export as xlsx.
Try open the export excel file, and you will see the error popup says "we found a problem with some content in workbook.xlsx ......"
It works when exporting comment and image separately.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Select Column B11, click wrap text from Home toolbar.
3. Start typing in B11 & see cell editor keeps growing and goes beyond screen.
4. This is not user friendly, it should be same as Excel
5. Any alternative or quick fix would be appreciable
Add option for manual calculation of formulas, as available in Excel.
It would be a great feature to have to save time for inputting values without updating other dependent cells and once data entry is done user could press "Calculate Now" and all of the cells updated in one go, same as we do have this feature in MS Excel 365.
Error occurred in browser console after select cell with value, pressing cut scissors button on top and press undo shortcut key combination (Ctrl+Z at windows or Cmd+Z at macos)
It would be great if you would add accessabbility to the spreadsheet as it seems to be the last control without this feature.
Currently the focus gets trapped inside its grid and the user cannot leave the spreadsheet with the TAB key. At least this should be avoided. It would be also better if only the first cell would be focusable and you then could navigate with the arrow keys, as with thousands of cells it is not very comfortable to use the TAB key.
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.
Dear Concerned,
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Copy from F3:F15
3. Paste as value (ctrl+shift+v) in H3
4. See it pasted only non-empty cells
Empty cells values should be pasted as well as Excel does.