Jiwa

Posted: **Wed Mar 20, 2019 10:24 am**

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

Posted: **Wed Mar 20, 2019 10:28 am**

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

Posted: **Wed Mar 20, 2019 10:30 am**

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

Posted: **Wed Mar 20, 2019 10:33 am**

*thumbs up*

Posted: **Wed Mar 20, 2019 10:33 am**

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.

Posted: **Wed Mar 20, 2019 10:35 am**

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

Posted: **Mon Mar 25, 2019 1:58 pm**

Aw shucks now I feel important

Posted: **Tue Mar 26, 2019 12:04 pm**

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;

Cell Font and Colour