Friday, May 17, 2024
61
rated 0 times [  66] [ 5]  / answers: 1 / hits: 9567  / 9 Years ago, fri, march 13, 2015, 12:00:00

I have similar code:



<script>
$(document).ready(function () {
var data = @Html.Raw(ViewBag.Data);

function sumPreviousValues(instance, td, row, col, prop, value, cellProperties) {
Handsontable.renderers.TextRenderer.apply(this, arguments);
td.val = 'SUM SEVERAL PREVIOUS CELLS';
}

container = document.getElementById('example1'),
settings1 = {
data: data,
colHeaders: @Html.Raw(ViewBag.TableHeader),
cells: function (row, col, prop) {
var cellProperties = {};

if (col == 16) {
cellProperties.renderer = sumPreviousValues;
}
return cellProperties;
}
},

hot = new Handsontable(container,settings1);
hot.render();


The key is to modify the function sumPreviousValues()



But I dont know how to access the td value ? and if it is possible to access other cells' value like td[index].
Any idea? I didn't find options in documentation.



Thank you


More From » handsontable

 Answers
4

I think I understand what you want to do and here is a simple solution:



From inside the custom renderer, you can call:



instance.getDataAtCell(row, col);


This will give you the data (value) of the cell at row,col. Hope that helps :)



Also, to access the value at the current td, you just use the value variable :P Look at the function definition. You are literally passing it in and is available to you.


[#38621] Thursday, March 12, 2015, 9 Years  [reply] [flag answer]
Only authorized users can answer the question. Please sign in first, or register a free account.
isham

Total Points: 69
Total Questions: 86
Total Answers: 86

Location: Anguilla
Member since Sun, Jan 29, 2023
1 Year ago
;