private void SetActiveCell(FarPoint.Win.Spread.FpSpread spread, FarPoint.Win.Spread.SheetView sheet, int row, int column) { if (sheet.RowCount == 0 || sheet.Cells[row, column] == null) { return; } if (sheet.ActiveCell != null) { sheet.ActiveCell.BackColor = Color.White; } sheet.Cells[row, column].BackColor = QuickReportCore.Controls.ucConditionObject.ObjectActivateColor; sheet.SetActiveCell(row, column); spread.ShowActiveCell(FarPoint.Win.Spread.VerticalPosition.Nearest, FarPoint.Win.Spread.HorizontalPosition.Nearest); }
private void UiBtn_Add_Click(object sender, EventArgs e) { FarPoint.Win.Spread.FpSpread spread = uiSpread_User; FarPoint.Win.Spread.SheetView sheet = spread.Sheets[0]; sheet.Rows.Add(sheet.Rows.Count, 1); int lastRowNom = sheet.Rows.Count - 1; sheet.Rows[lastRowNom].Tag = true; DesignSheet(sheet); sheet.SetActiveCell(lastRowNom, 0); spread.ShowRow(0, sheet.Rows.Count - 1, FarPoint.Win.Spread.VerticalPosition.Nearest); spread.ShowColumn(0, 1, FarPoint.Win.Spread.HorizontalPosition.Nearest); }