/// <summary> /// 범위에 검색하는 문자가 있으면 범위에 row단위로 글자색/배경색을 변경 하여준다.. /// </summary> /// <param name="fp"></param> /// <param name="sv"></param> /// <param name="strInStr"></param> /// <param name="intChkCol"></param> /// <param name="intStCol"></param> /// <param name="intEdCol"></param> /// <param name="colFore">null 이면 변경 않함</param> /// <param name="colBack">null 이면 변경 않함</param> public static void Invoke_CellRange_InStr_SetRowColor(FarPoint.Win.Spread.FpSpread fp, FarPoint.Win.Spread.SheetView sv, string strInStr, int intChkCol, int intStCol, int intEdCol, object colFore, object colBack) { if (fp.InvokeRequired) { fp.Invoke(new delInvoke_CellRange_InStr_SetRowColor(Invoke_CellRange_InStr_SetRowColor), new object[] { fp, sv, strInStr, intChkCol, intStCol, intEdCol, colFore, colBack }); return; } for (int y = 0; y < sv.Rows.Count; y++) { if (sv.Cells[y, intChkCol].Text.IndexOf(strInStr) >= 0) { if (colFore != null) { sv.Cells[y, intStCol, y, intEdCol].ForeColor = (Color)colFore; } if (colBack != null) { sv.Cells[y, intStCol, y, intEdCol].BackColor = (Color)colBack; } } } fp.Refresh(); }
/// <summary> /// 범위에 ForeColor와 BackColor를 변경하여 준다.. /// </summary> /// <param name="fp"></param> /// <param name="sv"></param> /// <param name="intStRow">시작 row</param> /// <param name="intEdRow">종료 row</param> /// <param name="intStCol">시작 col</param> /// <param name="intEdCol">종료 col</param> /// <param name="colFore">object color - 변경 안할시에는 null</param> /// <param name="colBack">object color - 변경 안할시에는 null</param> public static void Invoke_CellRange_SetRowColor(FarPoint.Win.Spread.FpSpread fp, FarPoint.Win.Spread.SheetView sv, int intStRow, int intEdRow, int intStCol, int intEdCol, object colFore, object colBack) { if (fp.InvokeRequired) { fp.Invoke(new delInvoke_CellRange_SetRowColor(Invoke_CellRange_SetRowColor), new object[] { fp, sv, intStRow, intEdRow, intStCol, intEdCol, colFore, colBack }); return; } if (colFore != null) { sv.Cells[intStRow, intStCol, intEdRow, intEdCol].ForeColor = (Color)colFore; } if (colBack != null) { sv.Cells[intStRow, intStCol, intEdRow, intEdCol].BackColor = (Color)colBack; } fp.Refresh(); }
/// <summary> /// 해당 Row의 forecolor과 backcolor을 변경한다. /// </summary> /// <param name="fp"></param> /// <param name="sv"></param> /// <param name="intRow"></param> /// <param name="colFore">null 이면 변경 않</param> /// <param name="colBack">null 이면 변경 않</param> public static void Invoke_Row_SetColor(FarPoint.Win.Spread.FpSpread fp, FarPoint.Win.Spread.SheetView sv, int intRow, object colFore, object colBack) { if (fp.InvokeRequired) { fp.Invoke(new delInvoke_Row_SetColor(Invoke_Row_SetColor), new object[] { fp, sv, intRow, colFore, colBack }); return; } if (intRow >= sv.RowCount) { return; } if (colBack != null) { sv.Rows[intRow].BackColor = (Color)colBack; } if (colFore != null) { sv.Rows[intRow].ForeColor = (Color)colFore; } fp.Refresh(); }