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
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.
When importing from Excel in Spreadsheet if a date is entered, but the date format is not set explicitly, the imported date always has the following format: "mm-dd-yy". The issue is observed even if a culture is set.
The value in Excel is "15.6.2020" , but the imported date in the Spreadsheet is "05-15-20" screencast
The format of the dates should be the same as in the imported file.
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
Dojo example.
The text in B2 is not unwrapped.
The merged cell prevents the unwrap. If there is no merged cell, or if the tool is used over the cell itself, wrapping/unwrapping works as expected.
The text in B2 is unwrapped.
When multiple cells are merged in the Spreadsheet the DatePicker is not always rendered at the correct position.
The DatePicker is not always entirely visible (screencast)
DatePicker should be visible
Hello,
I have some problems with setting up correct Cell Validation for my use-case. I want to create a list validation which is going to have a numeric options instead of typical string values.
So in order to achieve that I created a following cell validation:
{
dataType: "list",
showButton: true,
comparerType: "list",
from: '{1,2,3,4,5}',
allowNulls: true,
type: "reject"
}
Everything works fine in the widget, but the problems starts when I want to Export the following spreadsheet to Excel format. I'm getting the following message when trying to open such file:
In the past I had a similar problem with the list validation (but for string values) (https://www.telerik.com/account/support-tickets/view-ticket/1381434)
There you suggested to create a validation using different format for "from" property. So I decided to change it from:
from: '{1,2,3,4,5}',
to
from: '"1,2,3,4,5"',
After that I can freely export the spreadsheet without any problems, but then my list is inserting string values instead of numeric ones, therefore this solution is not suitable for my use-case.
And my question is: Is there a possibility to create a Cell validation where I can put numeric values as a possible options without breaking the export process?
Here's a example spreadsheet, which I used to reproduce this behavior: https://dojo.telerik.com/IfuMIbic
Best regards,
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
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
Memory usage is increased if the DevTools is open. Navigation between sheets is also slower.
Memory usage increased and slower sheet change.
Memory usage should not be increased and sheet navigation should not be slow.
The AND
formula, when used as part of an array formula, does not evaluate the whole array.
{=AND(A1:D1="")}
would return TRUE if a value is entered in the range B1:D1 and FALSE only if value is entered in A1
=IF(AND(A1="",B1="",C1="",D1=""),TRUE,FALSE)
would return FALSE if value is entered in any cell in range A1:D1
Ctrl
+Shift
+Enter
to enter as an array formulaArray formula should be evaluated correctly and return FALSE when a value is entered in any cell in range A1:D1.
When using a custom cell editor in the Spreadsheet along with keyboard navigation value selection is not limited to the cell with the custom cell editor
The selected value is applied to cell other then the one using the custom cell editor
The selected value should be applied only to the cell with the custom cell editor
Reproducible in this demo: https://demos.telerik.com/kendo-ui/spreadsheet/datasource
The data cleared by the "undo" shortcut is saved and sent to the server
A different behavior is exhibited if the data is pasted over the row header instead of the row's first cell. Follow the same steps, but on step 3. instead of pasting over the first cell, paste the data over the row 79 header. After undo and then clicking "Save", the fields have null values.
No data is sent with the request
The select method of the range in the Spreadsheet component throws an error when we have a selected cell in the visible area of the component and try to select a range that is outside of this visible area.
The bug is replicable both when the range is passed as exact cells or row-column pair:
** This is a regression from the R3 2019 release
The following error appears in the browser's console
If you scroll to the top rows of the Spreadsheet there is a visual selection of the cells that are passed in the range
On "Select range" click the "C4:E6" cell range should be selected and the Spreadsheet should be automatically scrolled to this selection.
Here is a working demo: https://dojo.telerik.com/uRERUxOm
The Spreadsheet doesn't' load correctly Excel files which definition of the tag is a single cell, instead of a cell range.
Test files: test-2.zip
The The "test.xlsx" file is not loading correctly in the Spreadsheet and loses data
The "test.xlsx" file should load correctly in the Spreadsheet without losing data
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.
This is observed also in online demos:
Steps:
Dear Concerned,
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Select column B and drag mouse towards C, both columns will be selected which is correct behavior
3. Now just scroll down 2-3 rows using vertical scroll bar
4. Repeat step 2, this time it does not select B & C, instead it selects B,C,D,E.
5. Seems a bug, not an expected behavior.
Observation that might help you in fixing it:
1. if you move scroll bar in such a way so that no merged cell is visible it works well, e.g. scroll down till 20th row becomes first visible row on screen and now repeat step 2, it will work
2. if scroll position is on top then behavior is correct as well
3. Same issue exists in case of multiple row selection with merged column and scroll position.
There is an issue with the Date type fields validation in the Spreadsheet.
Here are the reproduction steps:
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import attached xlsx file.
3. There are two date cells (B1 & B2), B2 has a data validation (Date between B1 to ToDay)
4. Try to edit the date using the calendar icon from B2. An empty calendar appears
Note: If I change data validation (remove reference of B1 and put hardcoded date) as below then it works.