Start Building Professional
Web Apps Today

eXcell custom format

I'm using this:
------------------------
    function eXcell_pr(cell){
    if (cell){
    this.cell = cell;
    this.grid = this.cell.parentNode.grid;
    }
    this.edit = function(){}
    this.isDisabled = function(){ return true; }
    this.setValue=function(val){
            this.setCValue("<span>"+val*100+"</span><span> %</span>",val*100);
    }
    }
    eXcell_pr.prototype = new eXcell;
------------------------
to set a percentage custom format, but when trying to use
mygrid.setMathRound(2);
it will not set the the rounding...
if I do not do the multiplication inside (do it in the column formula [=c1/c2*100] it will work.

B.T.W - it will be nice to have pr format included.

When you are using setMathRound and formating inside excell , the operation will be executed in next order

a) math formula calculated
b) rounding applied
c) custom logic of excell applied

so rounding just overwritten by logic of excell


>>B.T.W - it will be nice to have pr format included.
You can use ron column type, math as  [=c1/c2*100]  and grid.setNumberFormat("0.00%",index);