Handling client side events & changing cell values through client side code

Aspose.Cells Product Family
1

Hi

Below is the sample grid that I want to create,

A B C D
1
2
3

I want to write JavaScript to implement following scenario

whenever any cell say B2 will loose its focus , I want to read values from cells B1 and B2 using JavaScript. After that some JavaScript function will process these two values and resulted value will be displayed in cell D2

So my questions are

  1. How to read particular cell value using javascript?

  2. How to track focus lost of any cell at client side (javaScript )?

  3. How to edit value of any cell using javascript?

Thanks in advance.

2

Hi,

Thanks for considering Aspose.

1). You may use getCellValue() / getCellValueByCell() javascript function.

2). You may use javascript OnCellUnSelected event for lost focus and OnCellSelected event for got focus.

3). You may use setCellValue()/ getCellValueByCell for inputing values to cells.

For complete reference, please check the source code of Client Side Scripting demos in our featured Demos: http://www.aspose.com/Products/Aspose.Grid/Demos/

Thank you.