If an Excel file that contains Shapes is imported in the Spreadsheet, the imported content cannot be exported back to '.xlsx' file. Saving the imported content to Excel throws an error in the console.
Exporting the Spreadsheet content throws an error in the console:
The Spreadsheet content should be exported to Excel file that doesn't contain the shapes from the imported file
when the color of the borderBottom is commented
"borderBottom": {
//"color": "black",
js error when color is not applied a cell of the Spreadsheet
kendo.all.js:61278 Uncaught TypeError: e.transform is not a function
https://dojo.telerik.com/@zdravkov/iVoJuxAZ
export to pdf
js error
the data is exported correctly
The Kendo UI Spreadsheet's RANK function appears to be ignoring the 3rd optional parameter for ordering the numeric values.
Please take a look at this Progress Kendo UI Dojo which demonstrates the third parameter being ignored, and it remains with the default order.
If the third parameter is set to 1 or a nonzero value, the order should be set to an ascending order.
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
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.
Hi, I'm using the spreadsheet control and i'm having an issue with date columns.
When I enter a valid date, it works fine.
but when I enter an empty date (clicking delete on date column, or emptying out the contents)
the date gets stored as "new Date(0,0,-1)" ["Sat Dec 30 1899 00:00:00 GMT+1130 (New Zealand Daylight Time)" in my local time]
obviously, this is incorrect, and it should store the value as NULL.
it happens regardless of whether the schema/model has nullable=true.
If I manually modify the dataItem via JS, it stores it correctly as null.
I have a dojo demo set up which replicates the issue.
https://dojo.telerik.com/oFowivUN
Steps:
Doing some investigation into the kendo code, it seems to be caused by the serialToDate method of the spreadsheet.
Thanks
When you enter a value with leading zeros and then use the drag handle at the bottom right corner to change the value of the cells below, the leading zeros are being removed.
The value entered for the cells below is SS13, SS14 etc.
The value entered for the cells should be SS0012, SS0013 etc.
When pasting content to a Spreadsheet that has only one column(columns: 1), the data is not pasted in the targeted cell and a JS error appears in the browser's console.
The issue appears only in scenarios where the columns configuration is set to 1.
No data is pasted in the selected cell and the below error appears in the console:
The user should be able to paste content in a Spreadsheet cell in all component scenarios - with one or multiple columns.
Hi
We have noticed that spreadsheet filter box (click on filter down arrow) didnt appear when clicked on certain environment (win10, surface pro 7), but works on others.
What happens is you click the down arrow, a scroll bar appears on rhs, which i think is suggesting the popup has positioned soemwhere off visible area.
This happens in each browser - edge (94.0.992.50 ), chrome (95.0.4638.54 ) and firefox (93.0). Plug ins disabled. Windows 10.0.19043
Wondered if about high res screens or display settings?
Recreated with kendo demo
https://dojo.telerik.com/aruPOzEx
then tried each kendo version going back in time, and basically version 2020 R2 SP1 it worked (see attached working.. shot), and anything since it fails.
In the shots i am clicking on company filter arrow. the failversion-before is before i click, failversion-after is after click - where you can see extra vertical scrollbar
Regards
Chris
Cell value is not displayed after setting a formula for a range and creating a merged cell in the Spreadsheet.
The value of the B1:B2 merged cell is not displayed.
The value of the B1:B2 merged cell should be displayed.
Hello,
When spreadsheet cells are merged and have comment, it's shown only when hovering over first cell and not shown when hovering over other cells of the merged group of cells
Example to reproduce on dojo - https://dojo.telerik.com/@Andrii/uHINuvIh
On the cell A1 there is a comment, merged cells are A1:G1, comment is shown only when hover over cell A1.
When trying to select multiple cells in Spreadsheet, an error "n._ref.height is not a function" occurs.
Regression introduced with R3 2021.
An error "n._ref.height is not a function" occurs and cells are not selected.
No error should occur and cells should be selected.
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.
Related To: #5500
When there are merged cells and the SUM formula is used for the merged cells the result is wrong (it depends on the count of the merged cells)
The result in the D1 cell is 20. ( value of cell * count of cells in merged range)
The result should be 5. In the same scenario, the result in Excel will be 5.
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
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
Dojo example.
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.
Custom validation error can not be handled in spreadsheet
https://dojo.telerik.com/@zdravkov/uJuruCod
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
Use the Events demo to reproduce, since the events are logged in the console: https://demos.telerik.com/kendo-ui/spreadsheet/events
The Invoice sheet is selected but the selectSheet event does not fire.
The selectSheet event fires