Pentaho

Below my solution (table 3x3) - Pre-Execution code:

function f(){ 

    this.setAddInOptions("colType","formattedText",function(state){

        if(state.colIdx === 0)

        {

            var type = state.tableData[state.rowIdx][2];

            if(type == 76){

                    return {  textFormat: function(v, st) { return "<div style='background:red;'>"+v+"</div>"; } };

                 }   

        }

        if(state.colIdx === 1)

        {

            var type2 = state.tableData[state.rowIdx][2];

            if(type2 == 76){

                    return {  textFormat: function(v, st) { return "<div style='background:red;'>"+v+"</div>"; } };

             }      

        }

         if(state.colIdx === 2)

        {

            var type3 = state.tableData[state.rowIdx][2];

            if(type3 == 76){

                    return {  textFormat: function(v, st) { return "<div style='background:red;'>"+v+"</div>"; } };

             }      

        }

      });

}

Regards

Ema

Hi Ema,

I tried it but it seems not to be working.

Is there anything else needs to be done apart from adding above in Pre Execution.

e.g. - Not sure what is state in the above function. Is this name of your table.

HI Harshit,

Make sure you didn't forget to set the column types of the table as formattedText.

Best regards