In Export as Excel limited data is only Shown, If we add more data in the Kendo Table Grid, Additionally, When we click on Export as Excel, only the same set of data is shown, without any new data being added to the Excel Sheet.
See here Data is upto 45 in Kendo Table but when we export as Excel then only upto 32 data is loading, no new data is being loaded on Excel Sheet.
Kendo spreadsheet keyboard navigation using arrow keys not working properly for the last column. please refer below .
I'm trying to filter a spreadsheet, and while it works, it is EXTREMELY slow
And this kind of makes sense - we have ~35k unique values in this SKU column - but clicking to add a filter and then clicking the down arrow takes 20+ seconds before the filter popup appears, during which time the whole screen is frozen
Is there a way to allow a filter by value without including this multi-select, as with the data we have, in its current form, its completely unusable.
Thanks
I have the following code that uses the upload control to take a spreadsheet from our end user and uploads it and then parses it out into our objects.
var workbook = new kendo.spreadsheet.Workbook({});
workbook.fromFile(file).then(function() {
Do lots of things;
});
I have had zero issues with this block for the most part. However one of our end users has tried to upload a file and they are running into issues. When I debug the code it hits the fromFile, and then goes right past the then. I had multiple breakpoints inside the then, and none of them were being hit. In my last attempt I let it run for almost an hour before I killed it. I tried wrapping it in a try catch to see if it was erroring out and nothing. I tried to upload the file on the demo for the api (https://docs.telerik.com/kendo-ui/api/javascript/ui/spreadsheet/methods/fromfile) and it loads fine there.
I am at a loss and would love some insight. I have attached the spreadsheet that is causing issues hoping that someone can shed some light on it for me.
Hi!
There is a problem, when spreadsheet contains "ROW" or "COLUMN" function with self reference.
To reproduce this, open dojo:
https://dojo.telerik.com/IciGiroC
A3=OFFSET(A3, 1, COLUMN(A3)-1)
A4=1
A1=A3
What is expected: A1 value is 1
Actual result: A1 contains "#CIRCULAR"
Kendo UI Spreadsheet 2022.3.913
Would like to check if the below functions are available in Telerik.
3. Is there any guide/prompt on how to use formula?
4. "Financial" number format should be similar to Excel i.e. commas every 3 numbers, show bracket for negative value, right alignment
e.g. (1,800,123)
5. Is there any double underline on the cell border? Only have single underline available for now.
6. For the Splitter control, can the size of the button below be adjusted? It is too small from the screen.
Hello,
I want to add the word I wrote in the cell to the "list of validation" if it is not in the current list.
change listener code
I can capture the data I entered in the cell, but I could not add this word to the current validation list. how can I do it ?
My goal is that if the added word is not in the validation list, it will be added, and if there is, it will not repeat the data. in this way, it is always to increase the list and to be able to make a selection from the existing ones.
hello,
I want to access the spreadshet object in Angular, export and import data.
Example
(A completely imaginary example. I don't know how.)
how can I do it ?
thanks in advance