void fpSheetEditor1_ExcelOpened(object sender, ExcelsEventArgs e) { if (e.Sheets.Count > 0) { SheetView SheetView = e.Sheets[0]; FpSpread.Sheets.Clear(); FpSpread.Sheets.Add(SheetView); } if (FpSpread.Sheets.Count > 0) { FpSpread.ActiveSheet = FpSpread.Sheets[FpSpread.Sheets.Count - 1]; } SheetPropertyDialog PropertyDialog = new SheetPropertyDialog(FpSpread.ActiveSheet); PropertyDialog.RowCount.Value = FpSpread.ActiveSheet.RowCount; PropertyDialog.ColumnCount.Value = FpSpread.ActiveSheet.ColumnCount; string row = (FpSpread.ActiveSheet.GetLastNonEmptyRow(NonEmptyItemFlag.Style) + 1).ToString(); string col = (Arabic_Numerals_Convert.Excel_Word_Numerals(FpSpread.ActiveSheet.GetLastNonEmptyColumn(NonEmptyItemFlag.Style) + 1)).ToString(); PropertyDialog.DisplayInformation(row, col); PropertyDialog.Show(this); }
private void ButtonOk_Click(object sender, EventArgs e) { TreeNode Node = DictionaryView.SelectedNode; Selection Selection = Node.Tag as Selection; if (Selection.TypeFlag != "@Dictionary") { this.DialogResult = DialogResult.None; return; } CellType.ReferenceStyle = BizCommon.ReferenceStyle.Dictionary; DictionaryReference Reference = CellType.ReferenceInfo as DictionaryReference; String Cell = Arabic_Numerals_Convert.Excel_Word_Numerals(ColumnIndex) + (RowIndex + 1).ToString(); //bool HaveItem = SheetConfiguration.DataTableSchema.HaveDataItem(Cell); //if (HaveItem) //{ // FieldDefineInfo FieldInfo = SheetConfiguration.DataTableSchema.GetDataItem(Cell); // if (FieldInfo != null) // { // Reference.TableName = FieldInfo.TableInfo.Name; // Reference.ColumnName = FieldInfo.FieldName; // } //} Reference.DictionaryIndex = Node.Name; Reference.ReferenceXml = Node.Name; this.DialogResult = DialogResult.OK; this.Close(); }
public String getLiteralCell() { String LiteralColumn = Arabic_Numerals_Convert.Excel_Word_Numerals(Column); String LiteralRow = (Row + 1).ToString(); return(LiteralColumn + LiteralRow); }
private void SheetReferenceDialog_Load(object sender, EventArgs e) { //显示参照关系图 String Cell = Arabic_Numerals_Convert.Excel_Word_Numerals(ColumnIndex) + (RowIndex + 1).ToString(); InitReferenceDiagram(Cell); }
private void fpSpread_SheetTabClick(object sender, SheetTabClickEventArgs e) { SheetView sheet = fpSpread.Sheets[e.SheetTabIndex]; int ActiveRowIndex = (sheet.ActiveRowIndex >= 0 ? sheet.ActiveRowIndex : 0); int ActiveColumnIndex = (sheet.ActiveColumnIndex >= 0 ? sheet.ActiveColumnIndex : 0); tTextBox_XY.Text = Arabic_Numerals_Convert.Excel_Word_Numerals(ActiveColumnIndex) + (ActiveRowIndex + 1).ToString(); }
private void fpSpread_SelectionChanged(object sender, SelectionChangedEventArgs e) { int ActiveRowIndex = (e.Range.Row >= 0 ? e.Range.Row : 0); int ActiveColumnIndex = (e.Range.Column >= 0 ? e.Range.Column : 0); tTextBox_XY.Text = Arabic_Numerals_Convert.Excel_Word_Numerals(ActiveColumnIndex) + (ActiveRowIndex + 1).ToString(); OnCellClick(e); }
private void NumberControl_Load(object sender, EventArgs e) { if (Style == DisplayStyle.Digital) { this.textBox1.Text = (vScrollBar1.Minimum + 1).ToString(); } else if (Style == DisplayStyle.Letter) { this.textBox1.Text = Arabic_Numerals_Convert.Excel_Word_Numerals(vScrollBar1.Minimum); } }
/// <summary> /// 显示值 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void vScrollBar1_ValueChanged(object sender, EventArgs e) { if (Style == DisplayStyle.Digital) { this.textBox1.Text = (vScrollBar1.Value + 1).ToString(); } else if (Style == DisplayStyle.Letter) { this.textBox1.Text = Arabic_Numerals_Convert.Excel_Word_Numerals(vScrollBar1.Value); } OnValueChanged(e); }
public static int[] ConvertColumn_Row(string Range) { int DigitIndex = Range.Length - 1; char[] chars = Range.ToCharArray(); for (int i = 0; i < chars.Length; i++) { if (Char.IsDigit(chars[i])) { DigitIndex = i; break; } } List <int> Parts = new List <int>(); Parts.Add(System.Convert.ToInt32(Arabic_Numerals_Convert.ToNumerals(Range.Substring(0, DigitIndex)))); Parts.Add(System.Convert.ToInt32(Range.Substring(DigitIndex)) - 1); return(Parts.ToArray()); }
/// <summary> /// 选中单元格时调用这个更新工具栏 /// </summary> protected void RefreshFspreadStatus() { if (CellTools.Items.Count > 0) { CellTools.Items[0].Text = Arabic_Numerals_Convert.Excel_Word_Numerals(ActiveSheet.ActiveColumnIndex) + (ActiveSheet.ActiveRowIndex + 1).ToString(); } Font font = ActiveSheet.ActiveCell.Font; if (font != null) { FontFamilyComboBox.SelectedIndex = FontFamilyComboBox.Items.IndexOf(font.Name); int x = -1; string[] Names = FontSizeFactory.FontSize.Sizes(); for (int i = 0; i < Names.Length; i++) { if (font.Size == FontSizeFactory.FontSize.GetSize(Names[i])) { x = i; break; } } FontSizeComboBox.SelectedIndex = x; BoldButton.Checked = font.Bold; ItalicButton.Checked = font.Italic; UnderlineButton.Checked = font.Underline; } else { FontFamilyComboBox.SelectedIndex = FontFamilyComboBox.Items.IndexOf(DefaultFontFamily); FontSizeComboBox.SelectedIndex = FontSizeComboBox.Items.IndexOf(DefaultFontSize); BoldButton.Checked = false; ItalicButton.Checked = false; UnderlineButton.Checked = false; } MiddleCenterButton.Checked = (ActiveSheet.ActiveCell.RowSpan != 1 || ActiveSheet.ActiveCell.ColumnSpan != 1); }
/// <summary> /// 设置数据项 /// </summary> private void SettingSheetDataItem() { List <Cell> cells = new List <Cell>(); foreach (CellRange Range in Editor.Selections) { for (int Row = 0; Row < Range.RowCount; Row++) { for (int Column = 0; Column < Range.ColumnCount; Column++) { int absRow = Range.Row + Row; int absColumn = Range.Column + Column; string Tag = Arabic_Numerals_Convert.Excel_Word_Numerals(absColumn) + (absRow + 1); cells.Add(FpSpread.ActiveSheet.Cells[Tag]); } } } if (cells.Count > 0) { SheetDataItemDialog Dialog = new SheetDataItemDialog(this, cells); Dialog.ShowDialog(); } }
void myCell_EditModeOff(object sender, EventArgs e) { if (myCell == null) { return; } CellRange SelectRange = new CellRange(myCell.ActiveSheet.ActiveRowIndex, myCell.ActiveSheet.ActiveColumnIndex, 1, 1); if (!SelectRange.IsValidRange(myCell.ActiveSheet)) { return; } Boolean Have = false; foreach (List <string> ls in chartInputData.Values) { List <string> x = new List <string>(ls[0].ToLower().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)); List <string> y = new List <string>(ls[1].ToLower().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)); String r = Arabic_Numerals_Convert.Excel_Word_Numerals(myCell.ActiveSheet.ActiveColumnIndex) + (myCell.ActiveSheet.ActiveRowIndex + 1).ToString(); if (x.Contains(r.ToLower()) || y.Contains(r.ToLower())) { Have = true; break; } } if (!Have) { return; } UpdateChartData(); UpdateChartImage(); }
public static string GetColumn_Row(int Row, int Column) { return(Arabic_Numerals_Convert.Excel_Word_Numerals(Column) + (Row + 1).ToString()); }
protected void InitToolStripItems() { CellTools.Items.Clear(); ToolStripTextBox TextBox = new ToolStripTextBox(); TextBox.Enabled = false; TextBox.ForeColor = Color.Black; TextBox.BackColor = Color.White; TextBox.BorderStyle = BorderStyle.FixedSingle; TextBox.Text = Arabic_Numerals_Convert.Excel_Word_Numerals(ActiveSheet.ActiveColumnIndex) + (ActiveSheet.ActiveRowIndex + 1).ToString(); TextBox.TextBoxTextAlign = System.Windows.Forms.HorizontalAlignment.Center; CellTools.Items.Add(TextBox); CellTools.Items.Add(new ToolStripSeparator()); ToolStripMenuItem MenuItem = new ToolStripMenuItem(); MenuItem.Text = " 类型 "; MenuItem.ToolTipText = "报表元素类型"; CellTools.Items.Add(MenuItem); ToolStripMenuItem SubMenuItem = new ToolStripMenuItem(); SubMenuItem.Text = "数据列"; SubMenuItem.Click += new EventHandler(SubMenuItem_Click); MenuItem.DropDownItems.Add(SubMenuItem); SubMenuItem = new ToolStripMenuItem(); SubMenuItem.Text = "普通文本"; SubMenuItem.Click += new EventHandler(SubMenuItem_Click); MenuItem.DropDownItems.Add(SubMenuItem); SubMenuItem = new ToolStripMenuItem(); SubMenuItem.Text = "公式"; SubMenuItem.Click += new EventHandler(SubMenuItem_Click); MenuItem.DropDownItems.Add(SubMenuItem); SubMenuItem = new ToolStripMenuItem(); SubMenuItem.Text = "图片"; SubMenuItem.Click += new EventHandler(SubMenuItem_Click); MenuItem.DropDownItems.Add(SubMenuItem); SubMenuItem = new ToolStripMenuItem(); SubMenuItem.Text = "斜线"; SubMenuItem.Click += new EventHandler(SubMenuItem_Click); MenuItem.DropDownItems.Add(SubMenuItem); SubMenuItem = new ToolStripMenuItem(); SubMenuItem.Text = "变量"; SubMenuItem.Click += new EventHandler(SubMenuItem_Click); MenuItem.DropDownItems.Add(SubMenuItem); CellTools.Items.Add(new ToolStripSeparator()); MenuItem = new ToolStripMenuItem(); MenuItem.Text = " 浮动元素类型 "; MenuItem.ToolTipText = "浮动元素类型"; CellTools.Items.Add(MenuItem); SubMenuItem = new ToolStripMenuItem(); SubMenuItem.Text = "图表"; SubMenuItem.Click += new EventHandler(SubMenuItem_1_Click); MenuItem.DropDownItems.Add(SubMenuItem); CellTools.Items.Add(new ToolStripSeparator()); }
void FpSpread_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e) { if (ActiveElement != null) { panel1.Visible = (ActiveElement.Value is DataColumn); //扩展属性 if (ActiveElement.ExpandOrientation.Orientation == ExpandOrientation.LeftToRight) { rButton_LeftToRight.Checked = true; } else if (ActiveElement.ExpandOrientation.Orientation == ExpandOrientation.TopToBottom) { rButton_TopToBottom.Checked = true; } else if (ActiveElement.ExpandOrientation.Orientation == ExpandOrientation.None) { rButton_None.Checked = true; } //数据列属性 if (ActiveElement.Value is DataColumn) { DataColumn data = ActiveElement.Value as DataColumn; rButton_LeftToRight.Enabled = (data.DataSetting != DataSetting.Aggregation); rButton_TopToBottom.Enabled = (data.DataSetting != DataSetting.Aggregation); rButton_None.Enabled = (data.DataSetting != DataSetting.Aggregation); if (data.DataSetting == DataSetting.List) { rButton_List.Checked = true; } else if (data.DataSetting == DataSetting.Group) { rButton_Group.Checked = true; } else if (data.DataSetting == DataSetting.Aggregation) { rButton_Aggregation.Checked = true; cBoxAggregation.SelectedItem = data.FunctionInfo; } } //左父格属性 if (ActiveElement.ExpandOrientation.isDefaultLeftParent) { LeftCoordControl.setValue(ValueSource.Default, ""); } else { ValueSource source = (ActiveElement.ExpandOrientation.LeftParent == "" ? ValueSource.None : ValueSource.UseDefined); Cell Cell = Report.ReportSheet.GetCellFromTag(null, ActiveElement.ExpandOrientation.LeftParent); String cell = ""; if (Cell != null) { cell = Arabic_Numerals_Convert.Excel_Word_Numerals(Cell.Column.Index) + (Cell.Row.Index + 1).ToString(); } LeftCoordControl.setValue(source, cell); } //上父格 if (ActiveElement.ExpandOrientation.isDefaultTopParent) { TopCoordControl.setValue(ValueSource.Default, ""); } else { ValueSource source = (ActiveElement.ExpandOrientation.TopParent == "" ? ValueSource.None : ValueSource.UseDefined); Cell Cell = Report.ReportSheet.GetCellFromTag(null, ActiveElement.ExpandOrientation.TopParent); String cell = ""; if (Cell != null) { cell = Arabic_Numerals_Convert.Excel_Word_Numerals(Cell.Column.Index) + (Cell.Row.Index + 1).ToString(); } TopCoordControl.setValue(source, cell); } } }
private void DataColumnEditor_Load(object sender, EventArgs e) { //加载数据集 cBoxDatasets.Items.Clear(); foreach (TableData dataSource in Report.Configuration.DataSources) { cBoxDatasets.Items.Add(dataSource); } if (cBoxDatasets.Items.Count > 0) { cBoxDatasets.SelectedIndex = 0; } //指定分组配置 rButtonGroup.Checked = true; cBoxGroup.SelectedIndex = 0; //指定默认的扩展方式 rButton_TopToBottom.Checked = true; //初始化条件编辑器 filterControl1.InitControl(Report.Configuration); //加载汇总的方式 cBoxAggregation.Items.Clear(); cBoxAggregation.Items.Add(FunctionInfo.Sum); cBoxAggregation.Items.Add(FunctionInfo.Avg); cBoxAggregation.Items.Add(FunctionInfo.Max); cBoxAggregation.Items.Add(FunctionInfo.Min); cBoxAggregation.Items.Add(FunctionInfo.Count); cBoxAggregation.Items.Add(FunctionInfo.None); cBoxAggregation.SelectedIndex = 0; if (Element != null && Element.Value is DataColumn) { DataColumn DataColumn = Element.Value as DataColumn; int Index = 0; foreach (TableData dataSource in cBoxDatasets.Items) { if (dataSource.GetTableName().ToLower() == DataColumn.TableName.ToLower()) { Index = cBoxDatasets.Items.IndexOf(dataSource); break; } } if (cBoxDatasets.Items.Count > 0) { cBoxDatasets.SelectedIndex = Index; } else { cBoxDatasets.SelectedIndex = -1; } Index = 0; foreach (FieldInfo Info in cBoxFields.Items) { if (Info.FieldName.ToLower() == DataColumn.FieldName.ToLower()) { Index = cBoxFields.Items.IndexOf(Info); break; } } if (cBoxFields.Items.Count > 0) { cBoxFields.SelectedIndex = Index; } else { cBoxFields.SelectedIndex = -1; } if (Element.ExpandOrientation.isDefaultLeftParent) { LeftCoordControl.setValue(ValueSource.Default, ""); } else { ValueSource source = (Element.ExpandOrientation.LeftParent == "" ? ValueSource.None : ValueSource.UseDefined); Cell Cell = Report.ReportSheet.GetCellFromTag(null, Element.ExpandOrientation.LeftParent); String cell = ""; if (Cell != null) { cell = Arabic_Numerals_Convert.Excel_Word_Numerals(Cell.Column.Index) + (Cell.Row.Index + 1).ToString(); } LeftCoordControl.setValue(source, cell); } if (Element.ExpandOrientation.isDefaultTopParent) { TopCoordControl.setValue(ValueSource.Default, ""); } else { ValueSource source = (Element.ExpandOrientation.TopParent == "" ? ValueSource.None : ValueSource.UseDefined); Cell Cell = Report.ReportSheet.GetCellFromTag(null, Element.ExpandOrientation.TopParent); String cell = ""; if (Cell != null) { cell = Arabic_Numerals_Convert.Excel_Word_Numerals(Cell.Column.Index) + (Cell.Row.Index + 1).ToString(); } TopCoordControl.setValue(source, cell); } if (DataColumn.DataSetting == DataSetting.Group) { rButtonGroup.Checked = true; cBoxGroup.SelectedIndex = (DataColumn.IsUserDefinedGroup ? 1 : 0); } else if (DataColumn.DataSetting == DataSetting.List) { rButtonList.Checked = true; } else if (DataColumn.DataSetting == DataSetting.Aggregation) { rButtonAggregation.Checked = true; Index = -1; foreach (FunctionInfo Info in cBoxAggregation.Items) { if (Info.Name.ToLower() == DataColumn.FunctionInfo.Name.ToLower()) { Index = cBoxAggregation.Items.IndexOf(Info); break; } } cBoxAggregation.SelectedIndex = Index; } if (Element.ExpandOrientation.Orientation == ExpandOrientation.TopToBottom) { rButton_TopToBottom.Checked = true; } else if (Element.ExpandOrientation.Orientation == ExpandOrientation.LeftToRight) { rButton_LeftToRight.Checked = true; } else if (Element.ExpandOrientation.Orientation == ExpandOrientation.None) { rButton_None.Checked = true; } checkBox1.Checked = DataColumn.UseParentCellFilter; filterControl1.SetCondition(DataColumn.DataFilter); checkBox2.Checked = (DataColumn.BlankCount != 0); numericUpDown1.Enabled = checkBox2.Checked; numericUpDown1.Value = (numericUpDown1.Enabled ? DataColumn.BlankCount : 1); } }