Questions on Kendo UI for jQuery Forum

0 answers

46 views

Telerik Function

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

Double click on the header column or row can auto fix the column and row size.
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.

Splitter

Spreadsheet

asked on 08 Sep 2022

1 answer

63 views

Need server-side Upload script used by Spreadsheet Server Import example

Using this example: https://demos.telerik.com/kendo-ui/spreadsheet/server-side-import-export

I can't find the server-side script being run by this config: saveUrl: "/kendo-ui/spreadsheet/upload"

Where can I find this server-side script?

Spreadsheet

Upload

answered on 06 Sep 2022

1 answer

79 views

Endless or virtual scrolling for kendo spreadsheet

Is it possible to create endless or virtual scrolling for kendo spreadsheet?

Spreadsheet

answered on 05 Sep 2022

1 answer

227 views

Import excel document (base64 string) in spreadsheet.

I am trying to integrate spreadsheet into Oracle apex application. Oracle application process (apex.server.process) returns base64 of excel document on page load.

I want to bind base64 string as datasource to spreadsheet. I am new to Kendo UI, Can you please assist me how I can do binding.

I found some articles, and have knowledge about Telerik document processing, but I dont want to use external webservices along with oracle apex. Is there any way, where client can convert base64 string to localfile or json

Spreadsheet

answered on 27 Jul 2022

0 answers

66 views

Adding the data written to the cell to the validation with the changelistiner

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.

Spreadsheet

updated question on 01 Jul 2022

0 answers

75 views

Spreadsheet data import/export in Angular

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

SPA

Spreadsheet

updated question on 29 Jun 2022

0 answers

184 views

Kendo Spreadsheet

Hello ,

I want to multiple sheet with different type data when i click on tab name than that sheet data should show how to do this in kendo spreadsheet can you explain  ? 
and different sheet have different type of columns how to do that please help me to solve this problem. Thanks 
<div id="spreadsheet"></div>
<script>
    $("#spreadsheet").kendoSpreadsheet({
        sheets: [{ name: "Sheet1" }, { name: "Sheet2" }]
    });
    var sheets = $("#spreadsheet").data("kendoSpreadsheet").sheets();
    $("#spreadsheet").data("kendoSpreadsheet").activeSheet(sheets[1]);
</script>

Spreadsheet

asked on 20 Jun 2022

0 answers

74 views

Kendo Spreadsheet

Hello,

Can i iterate this code through the loop in kendo spreadsheet

sheet.range("AV2").formula("sum(AJ2:AU2)").background("#FFFF00").color("#ffffff");
sheet.range("AV3").formula("sum(AJ3:AU3)").background("#FFFF00").color("#ffffff");
sheet.range("AV4").formula("sum(AJ4:AU4)").background("#FFFF00").color("#ffffff");
sheet.range("AV5").formula("sum(AJ5:AU5)").background("#FFFF00").color("#ffffff");
sheet.range("AV6").formula("sum(AJ6:AU6)").background("#FFFF00").color("#ffffff");
sheet.range("AV7").formula("sum(AJ7:AU7)").background("#FFFF00").color("#ffffff");
sheet.range("AV8").formula("sum(AJ8:AU8)").background("#FFFF00").color("#ffffff");
sheet.range("AV9").formula("sum(AJ9:AU9)").background("#FFFF00").color("#ffffff");
sheet.range("AV10").formula("sum(AJ10:AU10)").background("#FFFF00").color("#ffffff");
sheet.range("AV11").formula("sum(AJ11:AU11)").background("#FFFF00").color("#ffffff");
sheet.range("AV12").formula("sum(AJ12:AU12)").background("#FFFF00").color("#ffffff");
sheet.range("AV13").formula("sum(AJ13:AU13)").background("#FFFF00").color("#ffffff");
sheet.range("AV14").formula("sum(AJ14:AU14)").background("#FFFF00").color("#ffffff");
sheet.range("AV15").formula("sum(AJ15:AU15)").background("#FFFF00").color("#ffffff");
sheet.range("AV16").formula("sum(AJ16:AU16)").background("#FFFF00").color("#ffffff");
sheet.range("AV17").formula("sum(AJ17:AU17)").background("#FFFF00").color("#ffffff");
sheet.range("AV18").formula("sum(AJ18:AU18)").background("#FFFF00").color("#ffffff");
sheet.range("AV19").formula("sum(AJ19:AU19)").background("#FFFF00").color("#ffffff");
sheet.range("AV20").formula("sum(AJ20:AU20)").background("#FFFF00").color("#ffffff");
sheet.range("AV21").formula("sum(AJ21:AU21)").background("#FFFF00").color("#ffffff");
sheet.range("AV22").formula("sum(AJ22:AU22)").background("#FFFF00").color("#ffffff");
sheet.range("AV23").formula("sum(AJ23:AU23)").background("#FFFF00").color("#ffffff");

and what is the validate solution for this loop iterate based on row data available in spreadsheet

Spreadsheet

asked on 16 Jun 2022

1 answer

322 views

KendoUi Font icons are not loading

Actually we have kendoUi in angularjs project. which ic giving error in developer console like server not responding 404 error for webcomponentsicon.ttf and webcomponentsicon.woff. because of this icons are not loading. can anyone please help me to clear this issue

Hierarchical Data Source

answered on 15 Jun 2022

1 answer

158 views

Kendo Spreadsheet

1.I want to set multiple sheet tab name every sheet tab name have a different columns and I want this when click on another tab than that data show

2. how to set validation for model from json file. Json file also contain sequence of column based on that file column should show is it possible?

3.I'm doing validation like this please check zip file

It's too lengthy code how to handle if dynamically any changes on column please help me to solve out this problem

I have Json file like this please check another zip file.I have a multiple json file i want when i click on sheet tab name than that json file columns and data show

ActionSheet

Data Source

Spreadsheet