getRangeIndexes not defined

[Stephen Welborn]

Trying to use thise function.  It bombs on  spreadsheetObj

 function getCellValue() {

        var spreadsheetObj = ej.base.getComponent(document.getElementById('spreadsheet3'), 'spreadsheet');

        let sheetNames = spreadsheetObj.sheets;

        var actCell = sheetNames[0].activeCell;

        let cellIdx = spreadsheetObj.getRangeIndexes(actCell);

        let cell = spreadsheetObj.getCell(cellIdx[0], cellIdx[1], sheetNames[0]);

        alert( spreadsheetObj .getDisplayText(cell));

    }

[Sangeetha Priya Murugan]

Hi Stephen,

To avoid this issue, we suggest you call the getRangeIndexes method from spreadsheet object as shown below.

CODE BLOCK:

 

function getCellValue() {

  var spreadsheetObj = ej.base.getComponent(

    document.getElementById('spreadsheet'),

    'spreadsheet'

  );

 

  let sheetNames = spreadsheetObj.sheets;

 

  var actCell = sheetNames[0].activeCell;

 

  let cellIdx = ejs.spreadsheet.getRangeIndexes(actCell);

 

  let cell = ejs.spreadsheet.getCell(cellIdx[0], cellIdx[1], sheetNames[0]);

 

  alert(spreadsheetObj.getDisplayText(cell));

}

 

Stackblitz Sample : https://stackblitz.com/edit/vqxmcg?file=index.js,index.html