/// <summary> /// Cell에 Fomula셑팅을 한다. /// </summary> /// <param name="fp"></param> /// <param name="sv"></param> /// <param name="cell"></param> /// <param name="formulaString"></param> /// <param name="celltype">변경할 셀 타입 FarPoint.Win.Spread.CellType 네임스페이스에서 새로운 클래스생성 하여 넘긴다. 무변경 null</param> public static void Invoke_CellFormula_Set(FarPoint.Win.Spread.FpSpread fp, FarPoint.Win.Spread.SheetView sv, FarPoint.Win.Spread.Cell cell, string formulaString, FarPoint.Win.Spread.CellType.BaseCellType celltype) { if (fp.InvokeRequired) { fp.BeginInvoke(new delInvoke_CellFormula_Set(Invoke_CellFormula_Set), new object[] { fp, sv, cell, formulaString, celltype }); return; } string textvalue = string.Empty; cell.Formula = formulaString; if (celltype != null) { cell.CellType = celltype; } /* * textvalue = cell.Text; * FarPoint.Win.Spread.CellType.TextCellType t = new FarPoint.Win.Spread.CellType.TextCellType(); * cell.CellType = t; * cell.Formula = ""; * cell.Value = textvalue; */ }
/// <summary> /// 원하는 셀을 보여 준다. /// </summary> /// <param name="fp"></param> /// <param name="sv"></param> /// <param name="row"></param> /// <param name="col"></param> public static void Invoke_ShowCell(FarPoint.Win.Spread.FpSpread fp, FarPoint.Win.Spread.SheetView sv, int row, int col) { if (fp.InvokeRequired) { fp.BeginInvoke(new delShowCell(Invoke_ShowCell), new object[] { fp, sv, row, col }); return; } sv.SetActiveCell(row, col, true); fp.ShowActiveCell(VerticalPosition.Center, HorizontalPosition.Center); }