In sigmagrid , how to set the cell's background color??

[luoluo99999]

In sigmagrid , how to set the cell's background color??

[steven]

That's easy. Do a customized render
return "<div style='background-color:red;'>" + data + "</div>";

[kapteng]

i have global render function for all columns, like this:
                // Initial Renderer
      if( value.length>5 && value.indexOf("Calc-")==0 ){         
         return "<span style=\"background-color:yellow\"><strong>"+value.substr(5)+"</strong></span>";
      }
      if( value.length>4 && value.indexOf("Imp-")==0 ){         
         return "<span style=\"background-color:SkyBlue\"><strong>"+value.substr(4)+"</strong></span>";
      }
      if(value=="&&"){
         record[columnObj.fieldIndex] = "N/A";
         return "<span style=\"background-color:gray\"><strong>N/A</strong></span>";
      }      
      return value ;

how can i keep the background color in every numeric entry in the grid ?
here is the screenshot

[steven]

You have to specify renderer for each columns. 

[kapteng]

i can't do that, because my data source from XML with the number of columns that are not fixed.
every data column with prefix "Calc-" will be change the background color with yellow, "Imp-" with bluesky, and "&&" with "gray".
i have try many way, and failed.
maybe you can help me with how to intercept value updated when we update the cell in editor text,
so i can reformat per cell value to make the renderer function works for every data cell updated.

[steven]

where did you define the column model? can you do the following lines?
var colsOption = [      {id: 'no' , header: "Text Box" , renderer: gRenderer },      {id: 'employee', header: "Text Box" ,, renderer: gRenderer  },    {id: 'country', header: "Drop Down" , renderer: gRenderer}    ...         ]; function gRenderer(){                 // Initial Renderer       if( value.length>5 && value.indexOf("Calc-")==0 ){                   return "<span style=\"background-color:yellow\"><strong>"+value.substr(5)+"</strong></span>";       }       if( value.length>4 && value.indexOf("Imp-")==0 ){                   return "<span style=\"background-color:SkyBlue\"><strong>"+value.substr(4)+"</strong></span>";       }       if(value=="&&"){          record[columnObj.fieldIndex] = "N/A";          return "<span style=\"background-color:gray\"><strong>N/A</strong></span>";       }            return value ; }

[kapteng]

i define column model with the script below,
the script read XML data from dsXML (XML data type in HTML)
function extractXMLDataSet(){
         var   nodes = dsXML.XMLDocument.childNodes.item(0).childNodes;
         strArrayData = "_DATA_ = [";
         strDsOption = "dsOption= { fields :[ ";
         strColsOption = "colsOption = [   ";
         strImacsVarProperty = " imacsVarProperty = [  ";

         for(row=0; row<nodes.length; row++){
            strArrayData +="[";
            for(column=0; column < nodes[row].childNodes.length; column++){
               strArrayData += "\""+nodes[row].childNodes[column].text+"\"";
               if(column != nodes[row].childNodes.length-1) strArrayData+=",";

               //process column name for dsOption and colsOption, get all column name, for first row only
               if(row==0){
                  //dsOption
                  strDsOption +="{name : '"+ nodes[row].childNodes[column].baseName + "'  }";

                  //strColsOption += "{id: '"+nodes[row].childNodes[column].baseName+"' , header: \""+nodes[row].childNodes[column].baseName+"\",width:80 }";
                  strColsOption += "{";
                  strColsOption += " id: '" + nodes[row].childNodes[column].baseName +"' ,";
                  strColsOption += " header:\"" + nodes[row].childNodes[column].baseName + "\",width:80";
                  strColsOption += (column<4? ",frozen:true":",renderer:my_renderer, editor:{type:\"text\", validator:my_validator}" );
                  strColsOption += "}";

                  //for imacs var property
                  strImacsVarProperty += " { "
                  //check if end of column no
                  if(column != nodes[row].childNodes.length-1){
                     strDsOption += ",";
                     strColsOption += ",";
                  }
               }
            }
            strArrayData +="]";

            if(row!= nodes.length-1) strArrayData +=",";

         }
         strArrayData +="]";
         strDsOption +="   ],recordType : 'array',   data : _DATA_}";
         strColsOption +="]";
         strImacsVarProperty = " ]; ";
}

[steven]

can you append "renderer: gRenderer" in each line

[kapteng]

i had it, see:

renderer:my_renderer, editor:{type:\"text\", validator:my_validator}" );
                  strColsOption += "}";