FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : ColumnFooterVisible Property |
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.Raised, 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; //new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood);
FpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off FpSpread1.Sheets(0).RowCount = 10 FpSpread1.Sheets(0).ColumnCount = 15 FpSpread1.Sheets(0).ColumnFooterVisible = True FpSpread1.Sheets(0).ColumnFooterRowCount = 2 FpSpread1.Sheets(0).ColumnFooter.DefaultStyle.Renderer = New FarPoint.Win.Spread.CellType.ColumnHeaderRenderer() Dim gl As New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, 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 'New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.BurlyWood)
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