1. Enter some text in a cell.
2. Increase the cell font size to 48.
3. Reduce the cell font size to 8.
4. Double click the row resize handler: the row height is not adjusted to correspond to font size 8.
The same behavior can be observed when opening an existing .xlsx file that has some text and font size set and following steps 3-4.
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.
I encountered a bug when using the spreadsheet control with a remote datasource which I was able to replicate using the datasource binding demo (https://demos.telerik.com/kendo-ui/spreadsheet/datasource).
When entering data on an empty cell in an empty row not adjacent to a non-empty row (e.g. a row that is two rows below the end of the data); then editing a cell in the same row, but adjacent column, this creates two items in the corresponding datasource.
Editing an empty row above this new row will modify one of the records created in this process.
Somtimes you just want to give the User a little Side Calc without a full blown Sheet, just the grid with some cells able to change.
I have observed that Conditional Formatting in Spreadhseet is not supported. Please add support for the same as it is very important feature of XLSX. during financial calculation this feature plays an important role. Here is the issue that needs a fix.
2. Check attached file CellColorFormula.xlsx, conditional formatting set for B2, C2, D2
3. Import attached file CellColorFormula.xlsx
4. Check Cells B2, C2, D2 and try to change values for A2, C2, D2
5. None of the conditional formatting is working
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.
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.
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.
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!
The formula in cell B3 returns #NA!
The formula in cell B3 should return the correct value
Kendo UI version: 2019.3.1023
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.
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.
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.
The current client-side export functionality does not preserve the number of columns.
Load the following file in the Spreadsheet which contains columns up to "BA".
Export the file
Load the file again in the Spreadsheet and notice that the columns are displayed up to "AX" instead of "BA".
Client-side export does not preserve the number of columns greater than "AX".
Client-side export does not preserve the exact number of columns.
Errors are encountered. Even if resolving the errors bold styles are not applied as they are part of the font definition and not of the inlineStyles.
The excel is imported as expected.
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)
Uncaught TypeError: Cannot read property 'row' of undefined