取消所有ColumnFooter中单元格边框

收藏

如题

iceman · iceman

回复 1楼burns的帖子

测试代码如下：

private void Form1_Load(object sender, EventArgs e)
{
fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the footer.
fpSpread1.Sheets[0].ColumnFooterVisible = true;
fpSpread1.Sheets[0].ColumnFooterRowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.ColumnHeaderRenderer();
FarPoint.Win.Spread.GridLine gl = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None, Color.Crimson, Color.Goldenrod, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooterHorizontalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterVerticalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood);
fpSpread1.Sheets[0].ColumnFooterSheetCornerHorizontalGridLine = gl;
//new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
fpSpread1.Sheets[0].ColumnFooterSheetCornerVerticalGridLine = gl;
}

复制代码

burns · burns

private void Form1_Load(object sender, EventArgs e)
      {
         fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
         fpSpread1.Sheets[0].RowCount = 10;
         fpSpread1.Sheets[0].ColumnCount = 15;
         // Show the footer.
         fpSpread1.Sheets[0].ColumnFooterVisible = true;
         fpSpread1.Sheets[0].ColumnFooterRowCount = 2;
         fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.ColumnHeaderRenderer();

         FarPoint.Win.Spread.GridLine gl = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None, Color.Crimson, Color.Goldenrod, Color.BurlyWood);
         fpSpread1.Sheets[0].ColumnFooterHorizontalGridLine = gl;
         //new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
         fpSpread1.Sheets[0].ColumnFooterVerticalGridLine = gl;
         //new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood);
         fpSpread1.Sheets[0].ColumnFooterSheetCornerHorizontalGridLine = gl;
         //new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Crimson);
         fpSpread1.Sheets[0].ColumnFooterSheetCornerVerticalGridLine = gl;

      }

这样设置又有个底纹。FarPoint.Win.Spread.GridLine gl = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None, Color.White, Color.White, Color.White);也还是这样。

我原来是：
FarPoint.Win.Spread.StyleInfo test = new FarPoint.Win.Spread.StyleInfo();
         test.BackColor = System.Drawing.Color.White;
         test.Border = new ComplexBorder(null, null, null, null);
         this.fpSpread1.ActiveSheet.ColumnFooter.DefaultStyle = test;

这个底纹是白色了，但是Border不起作用。

如果把您上边的再加上
FarPoint.Win.Spread.StyleInfo test = new FarPoint.Win.Spread.StyleInfo();
         test.BackColor = System.Drawing.Color.White;
         test.Border = new ComplexBorder(null, null, null, null);
         this.fpSpread1.ActiveSheet.ColumnFooter.DefaultStyle = test;

边框又出现了。

iceman · iceman

回复 3楼burns的帖子

burns 你好，

能否发个 Demo 到论坛调试？
或者你需要的效果图。

这样交流很抽象，我无法确定你需要的样式。
谢谢配合

burns · burns

很简单，我只需要 ColumnFooter预览时无边框无底纹（全白的）

在全白的基础上，动态生成 ColumnFooter，包括设置ColumnFooter行高、列宽、合并某几个单元格及某个单元格的边框与数据类型等即可。

iceman · iceman

回复 5楼burns的帖子

burns 你好，
请通过以下代码测试：

private void Form1_Load(object sender, EventArgs e)
{
fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the footer.
fpSpread1.Sheets[0].ColumnFooterVisible = true;
fpSpread1.Sheets[0].ColumnFooterRowCount = 2;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle.Renderer = new FarPoint.Win.Spread.CellType.ColumnHeaderRenderer();
FarPoint.Win.Spread.GridLine gl = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.None, Color.White, Color.White, Color.White);
fpSpread1.Sheets[0].ColumnFooterHorizontalGridLine = gl;
fpSpread1.Sheets[0].ColumnFooterVerticalGridLine = gl;
fpSpread1.Sheets[0].ColumnFooterSheetCornerHorizontalGridLine = gl;
fpSpread1.Sheets[0].ColumnFooterSheetCornerVerticalGridLine = gl;
fpSpread1.Sheets[0].ColumnFooter.Rows[0, 1].BackColor = Color.White;
fpSpread1.Sheets[0].ColumnFooterSheetCornerStyle.BackColor = Color.White;
fpSpread1.Sheets[0].ColumnFooterSheetCornerStyle.Border = new FarPoint.Win.LineBorder(Color.White, 0);
}

复制代码

burns · burns

非常感谢。

iceman · iceman

回复 7楼burns的帖子

好的，不客气，有问题欢迎继续提问。

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

[已处理] 取消所有ColumnFooter中单元格边框

7 个回复

活字格认证

微信认证勋章

元老葡萄