with custom button select cell value

[kypdk]

Hello,

What should I write to get the value inside the cell? I run in angular, I want to assign the cell value I selected to the variable.

  @ViewChild('spreadsheet') spreadsheetEl!: ElementRef;

  constructor(private hostEl: ElementRef) {}

  ngAfterViewInit() {
    kendo.jQuery(this.spreadsheetEl.nativeElement).kendoSpreadsheet({
           columns: 3,
           //rows: 10,
           sheetsbar: false,
           toolbar: {
            home: [
              "open", "exportAs",

              {
                  type: "button",
                  text: "Material select",
                  showText: "both",
                  icon: "k-icon k-i-cog",
                  click: function(e: any) {



                    var sheet = this.spreadsheetEl.nativeElement.activeSheet();
                    var range = sheet.selection();
                  }
              }
          ],
            insert: false,
            data: false,
            },
...

thank you

regards

[Neli]

Hello,

You can use the Range value method in order to retrieve the current value of the selected cell:

var sheet = $("#spreadsheet").data('kendoSpreadsheet').activeSheet();
var range = sheet.selection();
var current = range.value()
console.log(current)

Here is a small example based on the provided snippet. 

I hope this helps.

Regards,
Neli
Progress Telerik

[kypdk]

ERROR TypeError: Cannot read properties of undefined (reading 'activeSheet') at init.click (submaterial.component.ts:49:75)

i am getting error. I couldn't run it in angular.

<div id="spreadsheet" class="spreadsheet" #spreadsheet></div>

 

works

thank you so much

[Neli]

Hi Okay,

Below you will find a link to a StackBlitz example of a Kendo jQuery Spreadsheet initialized in Angular 2+ enviornment.

- https://stackblitz.com/edit/angular-4j46pk?file=src%2Fapp%2Fapp.component.ts

If this does not help you could also open a thread in the Kendo UI for Angular forum https://www.telerik.com/forums/kendo-angular-ui

Regards,

Neli