Average answer to the 2nd decimal place: Howto invoke this?

[summitmann]

Love the app... When I do an average calculation =b2/c2 My answer is an integer.
Is there a way to get the answer to the first or second decimal place? thanks in advance..

[cyadriane08]

please do try setting a format in your column in column properties.
for example: {type:'numeric', format:'0,0.00'}. you can search for the format in http://numeraljs.com/. or have it formatted by custom renderer.

[summitmann]

Sorry,
But, I am not sure where to put {type:'numeric', format:'0,0.00'}. Where do I set my column properties?
Is that somewhere inside jquery.handsontable-excel.js ? I tried looking at the spreadsheet generated by index.html and just don't know where to go to set the format for my column... Thanks again.

[summitmann]

i got it to work by modifying jquery.handsontable.full.js at:

Handsontable.NumericRenderer = function (instance, td, row, col, prop, value, cellProperties) {
if (typeof value === 'number') {
if (typeof cellProperties.language !== 'undefined') {
numeral.language(cellProperties.language)
}
td.innerHTML = numeral(value).format(cellProperties.format || '0.00'); //docs: http://numeraljs.com/
td.className = 'htNumeric';
// i changed td.innerHTML from 0 to 0.00
// thanks for your help.