eXcell custom format

Suite and Optimus Suite 5
#1

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(""+val100+" %",val100);

    }

    }

    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.

#2

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);