FarPoint Design BorderEditor(边框设计)

参考:http://blogs.fpoint.com/FarPointSupportSite/Modules/Docs/SpreadWin5Help/SDBorderEditor.html

FarPoint 边框自定义菜单操作步骤:

1、引用 FarPoint.Win.Spread.Design.dll

2、添加边框编辑出发按钮

3、按钮事件中代码如下(FP1为我添加的FarPoint控件)

                    FarPoint.Win.Spread.Design.BorderEditor borderedit= new FarPoint.Win.Spread.Design.BorderEditor(FP1);
                    borderedit.Name = "边框设置";
                    if (this.FP1.ActiveSheet.SelectionCount == 0)
                    {
                        borderedit.StartColumn = this.FP1.ActiveSheet.ActiveColumnIndex;
                        borderedit.ColumnCount = 1;
                        borderedit.StartRow = this.FP1.ActiveSheet.ActiveRowIndex;
                        borderedit.RowCount = 1;
                    }
                    else
                    {
                        FarPoint.Win.Spread.Model.CellRange range = this.FP1.ActiveSheet.GetSelection(0);   //选中区域
                        borderedit.StartColumn = range.Column;
                        borderedit.ColumnCount = range.ColumnCount;
                        borderedit.StartRow = range.Row;
                        borderedit.RowCount = range.RowCount;
                    }
                    borderedit.ShowDialog();

注:由于忽视了StartColumn、ColumnCount、StartRow 、RowCount  导致编辑界面内边框老设置不上,折腾了很久才弄出来,希望大家不要犯我同样的错误

原文地址:https://www.cnblogs.com/Anlycp/p/1855541.html