FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > FlatColumnFooterRenderer Class > FlatColumnFooterRenderer Constructor : FlatColumnFooterRenderer Constructor() |
'Declaration Public Function New()
'Usage Dim instance As New FlatColumnFooterRenderer()
public FlatColumnFooterRenderer()
//header/footer column fpSpread1.ActiveSheet.ColumnFooter.Visible = true; fpSpread1.ActiveSheet.ColumnFooter.RowCount = 3; fpSpread1.ActiveSheet.ColumnHeader.RowCount = 3; FarPoint.Win.Spread.CellType.FlatColumnHeaderRenderer flatcolumnheader = new FarPoint.Win.Spread.CellType.FlatColumnHeaderRenderer(); fpSpread1.ActiveSheet.ColumnHeader.DefaultStyle.Renderer = flatcolumnheader; FarPoint.Win.Spread.CellType.FlatColumnFooterRenderer flatcolumnfooter = new FarPoint.Win.Spread.CellType.FlatColumnFooterRenderer(); fpSpread1.ActiveSheet.ColumnFooter.DefaultStyle.Renderer = flatcolumnfooter; //header row fpSpread1.ActiveSheet.RowHeader.ColumnCount = 3; FarPoint.Win.Spread.CellType.FlatRowHeaderRenderer flatrowheader = new FarPoint.Win.Spread.CellType.FlatRowHeaderRenderer(); fpSpread1.ActiveSheet.RowHeader.DefaultStyle.Renderer = flatrowheader; //sheet corner header render FarPoint.Win.Spread.CellType.FlatCornerHeaderRenderer flatconrnerheader = new FarPoint.Win.Spread.CellType.FlatCornerHeaderRenderer(); fpSpread1.ActiveSheet.SheetCorner.DefaultStyle.Renderer = flatconrnerheader; //sheet corner footer render FarPoint.Win.Spread.SpreadSkin a1 = new FarPoint.Win.Spread.SpreadSkin(FarPoint.Win.Spread.DefaultSpreadSkins.Default); a1.Apply(fpSpread1); fpSpread1.ActiveSheet.ColumnFooter.Visible = true; FarPoint.Win.Spread.CellType.FlatCornerFooterRenderer flatconrnerfooter = new FarPoint.Win.Spread.CellType.FlatCornerFooterRenderer(); flatconrnerfooter.NormalTriangleColor = Color.Aquamarine; FarPoint.Win.Spread.NamedStyle conner = new FarPoint.Win.Spread.NamedStyle("conner", "HeaderDefault"); conner.BackColor = Color.Olive; conner.Renderer = flatconrnerfooter; fpSpread1.NamedStyles.Add(conner); a1.CornerFooterDefaultStyle = conner;
'header/footer column FpSpread1.ActiveSheet.ColumnFooter.Visible = True FpSpread1.ActiveSheet.ColumnFooter.RowCount = 3 FpSpread1.ActiveSheet.ColumnHeader.RowCount = 3 Dim flatcolumnheader As New FarPoint.Win.Spread.CellType.FlatColumnHeaderRenderer() FpSpread1.ActiveSheet.ColumnHeader.DefaultStyle.Renderer = flatcolumnheader Dim flatcolumnfooter As New FarPoint.Win.Spread.CellType.FlatColumnFooterRenderer() FpSpread1.ActiveSheet.ColumnFooter.DefaultStyle.Renderer = flatcolumnfooter 'header row FpSpread1.ActiveSheet.RowHeader.ColumnCount = 3 Dim flatrowheader As New FarPoint.Win.Spread.CellType.FlatRowHeaderRenderer() FpSpread1.ActiveSheet.RowHeader.DefaultStyle.Renderer = flatrowheader 'sheet corner header render Dim flatconrnerheader As New FarPoint.Win.Spread.CellType.FlatCornerHeaderRenderer() FpSpread1.ActiveSheet.SheetCorner.DefaultStyle.Renderer = flatconrnerheader 'sheet corner footer render Dim a1 As New FarPoint.Win.Spread.SpreadSkin(FarPoint.Win.Spread.DefaultSpreadSkins.Default) a1.Apply(FpSpread1) FpSpread1.ActiveSheet.ColumnFooter.Visible = True Dim flatconrnerfooter As New FarPoint.Win.Spread.CellType.FlatCornerFooterRenderer() flatconrnerfooter.NormalTriangleColor = Color.Aquamarine Dim conner = New FarPoint.Win.Spread.NamedStyle("conner", "HeaderDefault") conner.BackColor = Color.Olive conner.Renderer = flatconrnerfooter FpSpread1.NamedStyles.Add(conner) a1.CornerFooterDefaultStyle = conner
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10