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
Needs:
Load big excel files stored on the server
Possible implementation:
Load on demand data:
First load the file structure (sheets name, column names and number of rows)
Then load data when sheet is selected or scrolled
With Excel when you use a custom number format of #,##0.00 and you enter (10) into the cell it will be displayed as -10. With the Spreadsheet control the same example yields (10). How can we get the same behavior as Excel with the Spreadsheet control?
dojo example: https://dojo.telerik.com/@843335b6-427b-4127-af09-fbe9957bfec6/uGaVAVat
Thanks,
Ron
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:
For the time being the Spreadsheet parser is unable to read files which tags are not in the default namespace. Try to open the attached file in this demo project: https://demos.telerik.com/kendo-ui/spreadsheet/index.
You won't be able to load the file. If you open the file in Excel, save the file ("Ctrl+S") and try to load it in the Spreadsheet again, there will be no issues with it. The difference in file's structure before and after being saved in Excel could be seen in the attached screenshot.
The code in red is the structure of the file before saving it and the one in green is after the "save" operation. The difference between the files is that the structure of the one saved in Excel inserts the tags in the default namespace while the original document uses the "x:" namespace.
It will be very useful if we can load files with defined namespaces in their structure.
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.
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
Dojo example.
The first row is duplicated.
The first row is not duplicated
Hello,
Is is possible to trigger validation in cells in spreadsheet control? I want to make all validation controls with a button click outside the spreadsheet control.
Office 365 Comment are shown with a warning:
"[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924
go to demo - https://demos.telerik.com/kendo-ui/spreadsheet/index
import a file from ticket - 1447268
A warning is displayed
No warning is displayed
There is no TypeScript definition for defineFunction and no custom functions can be created in TypeScript context using the approach demonstrated in this Custom functions article.
Try defining a new function using:
kendo.spreadsheet.defineFunction("Mask",mask).args(maskArgs)
The following error appears:
Propery "defineFunction" does not exist on type 'typeof spreadsheet'
There shouldn't be any errors
1. Open https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Put some text in B2 so that it does not fit in the cell width.
3. Press Wrap Text button
4. Press Wrap Text again
5. The row height is not adjusted back to the original height (Excel does it)
https://demos.telerik.com/kendo-ui/spreadsheet/index
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.
Hi,
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.