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
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Try to select columns B to D using mouse
3. Click on column B, keeping mouse clicked, move your mouse towards C then D
4. It does not allow to select B,C,D where as it is possible in Excel.
It is serious issue for me as I could not proceed with Hide/Unhide columns and some other features depend on multiple columns selection
Note: if we add a blank row at first position then it works well, seems like first with merged columns is creating problem.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Open Workbook(1).xlsx (attached)
3. Edit B2, D2, F2 with some new values
4. See the results in B4, D4, F4
Calculations are different in Excel.
When the INDEX formula is used in combination with LINEST the Spreadsheet displays an empty cell. In case such formula is imported from Excel file '#VALUE' is displayed.
behavior when importing:
The content of the formula cell that includes LINEST and INDEX is empty. When clicking on the cell the formula is displayed in the formula bar. When importing the content in some cases the content is '#VALUE'.
The LINEST should work as expected in combination with the INDEX formula.
To reproduce
Steps to reproduce the behavior:
step1: Make a cell become wrap text and text something
step2: Export to pdf file:
Expected behavior
Text display same as on safari
Please fix this problem asap!!!.
1. Open "Sample Kendo UI SpreadSheet Example.html" attached html file in the chrome browser.
2. Click on open button in the Toolbar of the spreadsheet.
3. Select "Sample Excel with Font Colors.xlsx" attached excel file. This excel file contains headers with background color and Rows with ForeColors.
4. Now when the file is loaded, you will observe that B2, B3 and B5 should come up in Red fore color but the fore color of these cell in the kendo spread sheet is Black.
5. Similarly C2 to C5 should come in Green color but the fore color in the spreadsheet is black.
Query: Kindly let me know how can we achieve the fore color present in the excel sheet show show up in the Kendo UI Spreadsheet?
When a string, used as old_text for SUBSTITUTE(text, old_text, new_text, [instance_num]) function, is repeated more than once and the new_text is an empty string, one occurrence of the old_text remains not substituted.
ab113abababab11ab
in A1=SUBSTITUTE(A1, "ab", "")
NOTE: substituting ab
with another string, e.g. cd
, replaces all instances of ab
as expected.
113ab11
- when ab is repeated more than once in a row, one of its instances remains unchanged to an empty string
11311
In Excel I can create a merged cell. For this example, I will merge A1:B1 and name the range MyCell. Next I name the single cell D5, and call it MyAnswer. I can enter the following formula into MyAnswer, =MyCell and Excel will return the result.
Using Telerik if I create the same layout I get a #Value or #Spill error because Telerik requires MyAnswer to be the same merge configuration as MyCell which creates a significant disadvantage in usability.
Can you please advise when this issue will be fixed in Telerik.
I have attached a screen recording of this not working in your Dojo named "Telerik merge cell reference not working when not same col.mov".
Thank you so much.
Excel file is corrupted when it is created with the kendo.ooxml.Workbook toDataURL method, using stringified sheet data:
let dataURL = new kendo.ooxml.Workbook(JSON.stringify(data)).toDataURL();
If the data is passed to the Workbook without stringifying it, this causes a circular reference error (check the console).
let dataURL = new kendo.ooxml.Workbook(data).toDataURL();
Dojo example.
The generated Excel file is corrupted
The generated Excel file is not corrupted
Values that are copied from Spreadsheet are duplicated when pasted in Excel if before that the copied cells have been cut and pasted inside the Spreadsheet.
In Excel, the first row is duplicated and the pasted content contains 3 rows, while 2 rows are copied
The pasted in Excel content should contain 2 rows instead of 3
When the reference to a cell in a specific Sheet is added in the defineName function, using the name leads to invalid result.
The returned result is '#NAME?'
The returned result should depend on the referenced cell value. In the example above B2 have a value 5, thus the value in the selected cell should be also 5.
The issue also appears when importing an Excel file with defined names in the Spreadsheet. The names in the attached Excel file are created as in the image below:
Cannot delete defined names in the name box of the Spreadsheet when clicking the delete button.
Regression introduced with 2022.1.119
The items cannot be deleted.
The following error appears in the browser console:
Uncaught TypeError: Cannot read properties of undefined (reading 'name')
The items in the name box should be deleted and an error should not appear.
After the 2022 R2 SP1 version. there is a bug in the spreadsheet data source. when dill down the cell, the data source will not be changed. only input text can trigger the change event.
Reproduction steps:
Expected:
Button is enabled
Actual:
Button not enabled
Client-side exported Excel workbooks are exported "uncompressed" (as readable text) and their size is much greater than the original document.
Regression since R2 2019 - 2019.2.514
The exported file is 1015 KB in size. The content of the file may be read as plain text
The exported file is 26 KB or similar size. The content of the file is unreadable binary data
When a cell/row is selected, its first cell is focused and the sheet is scrolled to show it. If a long sheet is scrolled down/right to edit cells, this scroll top/left is very annoying and user unfriendly.
In these scenarios Excel focuses the topmost/leftmost currently visible cell, avoiding sheet scrolling.
NOTE: for rows reproduction select cell AX2, then click on the header of row 2 - sheet is scrolled to the left and cell A2 is focused.
Column C is selected, cell C1 is focused and the sheet is scrolled to top.
The used has to scroll down to the bottom row again to edit data at the bottom of the sheet.
Column C is selected. The currently visible topmost cell of column C is focused, without scrolling the sheet. Excel works that way
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.
Dear Concerned,
1. Launch https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Click Background or Text Color icon , select custom color
3. See the popup UI , there is boarder and margin issues, boarder is visible on top,left & bottom side but not on right side