Telerik Forums
Kendo UI for jQuery Forum
0 answers
42 views

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.

Mohit
Top achievements
Rank 1
 asked on 03 Oct 2023
0 answers
43 views

Kendo spreadsheet keyboard navigation using arrow keys not  working properly for the last column. please refer below .

Amila
Top achievements
Rank 1
 updated question on 18 Sep 2023
0 answers
71 views

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

Kevin
Top achievements
Rank 1
 asked on 24 Feb 2023
0 answers
79 views
Is it possible to embed the kendo spread sheet within webpage in display mode? 
Rajendran
Top achievements
Rank 1
 asked on 17 Feb 2023
0 answers
141 views

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.

Jed
Top achievements
Rank 1
Iron
 asked on 13 Jan 2023
0 answers
55 views

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

Ryabinin
Top achievements
Rank 1
 asked on 01 Nov 2022
0 answers
294 views
Is there an equivalent in Kendo Spreadsheet for ScrollTo. I'm building a Time Sheet App and I want to set the current day, which is represented by a column, as the home column. Setting focus to the first row of the column is easy enough, but I would also like to scroll to that column if possible.
Daniel
Top achievements
Rank 1
Iron
 asked on 26 Oct 2022
0 answers
46 views

Would like to check if the below functions are available in Telerik.

  1. Double click on the header column or row can auto fix the column and row size.
  2. Use arrow keys in keyboard to select formula. Currently only support using mouse to click on the formula.

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.


    Cheng Mun
    Top achievements
    Rank 1
     asked on 08 Sep 2022
    0 answers
    66 views

    Hello,

    const processesList: string[] = ["Process 1","Process 2","Process 3"];

     

    I want to add the word I wrote in the cell to the "list of validation" if it is not in the current list.

     

      SpreadValidation() {
        var spreadsheet = kendo.jQuery(this.spreadsheetEl.nativeElement).data("kendoSpreadsheet");
        var sheet = spreadsheet.activeSheet();
        const processesMerge = '"'+processesList.toString()+'"';
       
        sheet.range("B:AX").validation({
          dataType: "list",
          showButton: true,
          comparerType: "list",
          from: processesMerge,
          allowNulls: true,
          type: "warning"
        });
      }

     

    change listener code

       var spreadsheet = kendo.jQuery(this.spreadsheetEl.nativeElement).data("kendoSpreadsheet");
        spreadsheet.bind("changing", this.changeListener);

     

      changeListener(e) {
        console.log("The netered value is: "+e.data);
        processesList.push(e.data);
        var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
        var sheet = spreadsheet.activeSheet();
        const progressMerge = '"'+processesList.toString()+'"';
       
        sheet.range("B:AX").validation({
          dataType: "list",
          showButton: true,
          comparerType: "list",
          from: progressMerge,
          allowNulls: true,
          type: "warning"
        });    
    }

     

     

    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.

     

    kypdk
    Top achievements
    Rank 1
    Iron
     updated question on 01 Jul 2022
    0 answers
    75 views

    hello,

    I want to access the spreadshet object in Angular, export and import data.

    Example

    (A completely imaginary example. I don't know how.)

     dataExport() {
        kendo.jQuery(this.spreadsheetEl.nativeElement).kendoSpreadsheet({
            function() {
                var sheet = $("#spreadsheet").data('kendoSpreadsheet').activeSheet();
                var range = sheet.selection();
                console.log(sheet.toJSON());
            }
        });
      }


    how can I do it ?

    thanks in advance

    kypdk
    Top achievements
    Rank 1
    Iron
     updated question on 29 Jun 2022
    Narrow your results
    Selected tags
    Tags
    +? more
    Top users last month
    Mark
    Top achievements
    Rank 1
    Yurii
    Top achievements
    Rank 1
    Leland
    Top achievements
    Rank 2
    Iron
    Iron
    Iron
    Hon
    Top achievements
    Rank 1
    Iron
    Deltaohm
    Top achievements
    Rank 3
    Bronze
    Iron
    Iron
    Want to show your ninja superpower to fellow developers?
    Top users last month
    Mark
    Top achievements
    Rank 1
    Yurii
    Top achievements
    Rank 1
    Leland
    Top achievements
    Rank 2
    Iron
    Iron
    Iron
    Hon
    Top achievements
    Rank 1
    Iron
    Deltaohm
    Top achievements
    Rank 3
    Bronze
    Iron
    Iron
    Want to show your ninja superpower to fellow developers?
    Want to show your ninja superpower to fellow developers?