Calculative Column and Reference Of Calculative Column in Next Row

[vijay@spinetechnologies]

Hi Team,
In PQ Grid can we achieve Calculative Column and Reference Of Calculative Column in Next Row?
Please find the attachment for your reference.

[paramvir]

you can either use Excel formulas or cell value getters with rowTemplate option.

[vijay@spinetechnologies]

How to access previous or next rows in RowTemplate ?

[paramvir]

"this" points to current rowData inside getter/setter of rowTemplate

so previous row is

Code: [Select]

var nextRow = grid.pageData()[this.pq_ri - 1];

where grid points to grid instance ( a global variable ) and is obtained in render event.

Code: [Select]

render: function(){
grid = this;
},