Bord设置为右开口后，导出的Excel没问题，打印的时候还是封闭的

收藏

请见附件：

iceman · iceman

你好，请设置 PrintInfo 下 ShowBorder 属性为 false，普通单元格边框可以使用 GridLine 代替。

this.fpSpread1.ActiveSheet.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat,Color.Red);
this.fpSpread1.ActiveSheet.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat,Color.Red);
this.fpSpread1.ActiveSheet.PrintInfo.ShowBorder = false;

复制代码

laonawuli · laonawuli

原帖由 iceman 于 2011-11-17 10:24:00 发表
你好，请设置 PrintInfo 下 ShowBorder 属性为 false，普通单元格边框可以使用 GridLine 代替。[code]
this.fpSpread1.ActiveSheet.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.Gr

设置 ShowBorder 属性为 false 果然好用了。

我现在ColumnHeader与普通Column的属性的H、V的GridLine都设置为None了，因为样式需要（或者是因为我不会灵活使用），不知道你说的“普通单元格边框可以使用 GridLine 代替”是什么意思呢？

iceman · iceman

意思是：当你设置设置 ShowBorder 属性为 false 时，普通单元格的 Border 也不会打印，所以可以设置 Sheet 的 GridLine 去代替普通单元格 Border 的显示效果。可以通过以下代码进行尝试：

this.fpSpread1.ActiveSheet.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat,Color.Red);
this.fpSpread1.ActiveSheet.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat,Color.Red);
this.fpSpread1.ActiveSheet.PrintInfo.ShowBorder = false;

复制代码

laonawuli · laonawuli

原帖由 iceman 于 2011-11-17 10:39:00 发表
意思是：当你设置设置 ShowBorder 属性为 false 时，普通单元格的 Border 也不会打印，所以可以设置 Sheet 的 GridLine 去代替普通单元格 Border 的显示效果。可以通过以下代码进行尝试：[code]
this.fpSpread1.ActiveSheet.HorizontalGridLine = new FarPoint.Win.

奇怪。。。。我没有使用ColumnHeader和普通Column的GridLine，设置ShowBorder=false后，打印很正常，请见附件。

iceman · iceman

你好，我没有重现出这个问题，所以这可能与你自定义皮肤样式有关。

laonawuli · laonawuli

原帖由 iceman 于 2011-11-17 15:08:00 发表
你好，我没有重现出这个问题，所以这可能与你自定义皮肤样式有关。

我这次没有使用自定义皮肤哦。。完全是DefaultStyle。。。。

iceman · iceman

你好，麻烦你把你关于打印和皮肤设置的代码制作 Demo 发到论坛上来，这样我们就可以定位问题。

laonawuli · laonawuli

打印就是pringsheet（0）

FP的初始化代码：
//
         // fpMain
         //
         this.fpMain.About = "2.5.2007.2005";
         this.fpMain.AccessibleDescription = "fpMain, Sheet1";
         this.fpMain.BackColor = System.Drawing.Color.White;
         this.fpMain.Dock = System.Windows.Forms.DockStyle.Fill;
         this.fpMain.Font = new System.Drawing.Font("微软雅黑", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
         this.fpMain.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
         this.fpMain.Location = new System.Drawing.Point(3, 17);
         this.fpMain.Name = "fpMain";
         this.fpMain.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this.fpMain_Sheet1});
         this.fpMain.Size = new System.Drawing.Size(715, 235);
         this.fpMain.TabIndex = 0;
         tipAppearance1.BackColor = System.Drawing.SystemColors.Info;
         tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
         tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText;
         this.fpMain.TextTipAppearance = tipAppearance1;
         this.fpMain.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
         this.fpMain.VisualStyles = FarPoint.Win.VisualStyles.Off;
         this.fpMain.AutoSortingColumn += new FarPoint.Win.Spread.AutoSortingColumnEventHandler(this.fpMain_AutoSortingColumn);
         this.fpMain.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpMain_CellDoubleClick);
         this.fpMain.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpMain_CellClick);
         this.fpMain.ColumnWidthChanged += new FarPoint.Win.Spread.ColumnWidthChangedEventHandler(this.fpMain_ColumnWidthChanged);
         //
         // fpMain_Sheet1
         //
         this.fpMain_Sheet1.Reset();
         this.fpMain_Sheet1.SheetName = "Sheet1";
         // Formulas and custom names must be loaded with R1C1 reference style
         this.fpMain_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
         this.fpMain_Sheet1.ColumnCount = 0;
         this.fpMain_Sheet1.ColumnHeader.RowCount = 0;
         this.fpMain_Sheet1.RowCount = 0;
         this.fpMain_Sheet1.RowHeader.ColumnCount = 0;
         this.fpMain_Sheet1.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Blank;
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White;
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.Font = new System.Drawing.Font("微软雅黑", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.Locked = false;
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault";
         this.fpMain_Sheet1.ColumnHeader.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.ColumnHeader.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.DataAutoCellTypes = false;
         this.fpMain_Sheet1.GrayAreaBackColor = System.Drawing.Color.White;
         this.fpMain_Sheet1.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly;
         this.fpMain_Sheet1.PrintInfo.ShowBorder = false;
         this.fpMain_Sheet1.Protect = false;
         this.fpMain_Sheet1.RowHeader.Columns.Default.Resizable = false;
         this.fpMain_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White;
         this.fpMain_Sheet1.RowHeader.DefaultStyle.Locked = false;
         this.fpMain_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault";
         this.fpMain_Sheet1.RowHeader.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.RowHeader.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
         this.fpMain_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;
         this.fpMain_Sheet1.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
         this.fpMain.SetActiveViewport(1, 1);

进入程序以后，没有对FP再设置过其他属性，除了设置Column和Columnheader的Border

laonawuli · laonawuli

原帖由 iceman 于 2011-11-17 18:33:00 发表
你好，麻烦你把你关于打印和皮肤设置的代码制作 Demo 发到论坛上来，这样我们就可以定位问题。

打印就是pringsheet（0）

FP的初始化代码：
  //
         // fpMain
         //
         this.fpMain.About = "2.5.2007.2005";
         this.fpMain.AccessibleDescription = "fpMain, Sheet1";
         this.fpMain.BackColor = System.Drawing.Color.White;
         this.fpMain.Dock = System.Windows.Forms.DockStyle.Fill;
         this.fpMain.Font = new System.Drawing.Font("微软雅黑", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
         this.fpMain.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
         this.fpMain.Location = new System.Drawing.Point(3, 17);
         this.fpMain.Name = "fpMain";
         this.fpMain.Sheets.AddRange(new FarPoint.Win.Spread.SheetView[] {
         this.fpMain_Sheet1});
         this.fpMain.Size = new System.Drawing.Size(715, 235);
         this.fpMain.TabIndex = 0;
         tipAppearance1.BackColor = System.Drawing.SystemColors.Info;
         tipAppearance1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
         tipAppearance1.ForeColor = System.Drawing.SystemColors.InfoText;
         this.fpMain.TextTipAppearance = tipAppearance1;
         this.fpMain.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded;
         this.fpMain.VisualStyles = FarPoint.Win.VisualStyles.Off;
         this.fpMain.AutoSortingColumn += new FarPoint.Win.Spread.AutoSortingColumnEventHandler(this.fpMain_AutoSortingColumn);
         this.fpMain.CellDoubleClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpMain_CellDoubleClick);
         this.fpMain.CellClick += new FarPoint.Win.Spread.CellClickEventHandler(this.fpMain_CellClick);
         this.fpMain.ColumnWidthChanged += new FarPoint.Win.Spread.ColumnWidthChangedEventHandler(this.fpMain_ColumnWidthChanged);
         //
         // fpMain_Sheet1
         //
         this.fpMain_Sheet1.Reset();
         this.fpMain_Sheet1.SheetName = "Sheet1";
         // Formulas and custom names must be loaded with R1C1 reference style
         this.fpMain_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.R1C1;
         this.fpMain_Sheet1.ColumnCount = 0;
         this.fpMain_Sheet1.ColumnHeader.RowCount = 0;
         this.fpMain_Sheet1.RowCount = 0;
         this.fpMain_Sheet1.RowHeader.ColumnCount = 0;
         this.fpMain_Sheet1.ColumnHeader.AutoText = FarPoint.Win.Spread.HeaderAutoText.Blank;
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.BackColor = System.Drawing.Color.White;
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.Font = new System.Drawing.Font("微软雅黑", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(134)));
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.Locked = false;
         this.fpMain_Sheet1.ColumnHeader.DefaultStyle.Parent = "HeaderDefault";
         this.fpMain_Sheet1.ColumnHeader.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.ColumnHeader.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.DataAutoCellTypes = false;
         this.fpMain_Sheet1.GrayAreaBackColor = System.Drawing.Color.White;
         this.fpMain_Sheet1.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.OperationMode = FarPoint.Win.Spread.OperationMode.ReadOnly;
         this.fpMain_Sheet1.PrintInfo.ShowBorder = false;
         this.fpMain_Sheet1.Protect = false;
         this.fpMain_Sheet1.RowHeader.Columns.Default.Resizable = false;
         this.fpMain_Sheet1.RowHeader.DefaultStyle.BackColor = System.Drawing.Color.White;
         this.fpMain_Sheet1.RowHeader.DefaultStyle.Locked = false;
         this.fpMain_Sheet1.RowHeader.DefaultStyle.Parent = "HeaderDefault";
         this.fpMain_Sheet1.RowHeader.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.RowHeader.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.SelectionPolicy = FarPoint.Win.Spread.Model.SelectionPolicy.Single;
         this.fpMain_Sheet1.SelectionUnit = FarPoint.Win.Spread.Model.SelectionUnit.Row;
         this.fpMain_Sheet1.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None);
         this.fpMain_Sheet1.ReferenceStyle = FarPoint.Win.Spread.Model.ReferenceStyle.A1;
         this.fpMain.SetActiveViewport(1, 1);

进入程序以后，没有对FP再设置过其他属性，除了设置Column和Columnheader的Border

		自动登录	找回密码
密码			立即注册

Bord设置为右开口后，导出的Excel没问题，打印的时候还是封闭的

11 个回复

回复 1# laonawuli 的帖子

回复 3# laonawuli 的帖子

回复 5# laonawuli 的帖子

回复 7# laonawuli 的帖子

活字格认证

微信认证勋章

元老葡萄