Cell Font and Colour

[SBarnes]

Is there a way to set the font and the colour of the font for a particular cell in the Jiwa Grid?

[Scott.Pearce]

Code: Select all

grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.GetColumnFromTag(null, "QuantityDemand").Index].BackColor = Color.Red;
grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.GetColumnFromTag(null, "QuantityDemand").Index].ForeColor = JiwaFinancials.Jiwa.JiwaApplication.Manager.ContrastColour(System.Drawing.Color.Red);
grdLines.ActiveSheet.Cells[Row, grdLines.ActiveSheet.GetColumnFromTag(null, "QuantityDemand").Index].Font = new System.Drawing.Font(grdLines.Font.FontFamily.Name, SalesOrderForm.grdLines.Font.Size, FontStyle.Bold);


[SBarnes]

Thank Scott, is that new record for turn around time on a post

[Scott.Pearce]

*thumbs up*

[Mike.Sheen]

Note you may need to set the LockBackColor property of the cell to null before setting the BackColor will work - if that's something you want to do.

[Mike.Sheen]

Thank Scott, is that new record for turn around time on a post

Equal record? viewtopic.php?f=26&t=955&p=3541#p3541

[SBarnes]

Aw shucks now I feel important

[SBarnes]

Actually the code to make this happens looks like

Code: Select all

            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyLabel").Index].Locked = false;

            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyLabel").Index].BackColor = Color.Red;
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyLabel").Index].ForeColor = Color.Red;
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyLabel").Index].Font = new System.Drawing.Font(jgPriceAndQty.Font.FontFamily.Name, jgPriceAndQty.Font.Size, FontStyle.Bold);
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyLabel").Index].Locked = true;
            
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyVal").Index].Locked = false;
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyVal").Index].BackColor = Color.Red;
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyVal").Index].ForeColor = Color.Red;
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyVal").Index].Font = new System.Drawing.Font(jgPriceAndQty.Font.FontFamily.Name, jgPriceAndQty.Font.Size, FontStyle.Bold);
            jgPriceAndQty.ActiveSheet.Cells[3, jgPriceAndQty.ActiveSheet.GetColumnFromTag(null, "QtyVal").Index].Locked = true;