- Grid1_Sheet1.ColumnFooter.Cells(0, 0).ColumnSpan = 7
- Grid1_Sheet1.ColumnFooter.Cells(0, 0).Text = "金额合计:"
- '水平对齐方式
- Grid1_Sheet1.ColumnFooter.Cells(0, 0).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right
- Dim num1 As New FarPoint.Win.Spread.CellType.NumberCellType
- Grid1_Sheet1.ColumnFooter.Cells(0, 7).CellType = num1
- Grid1_Sheet1.ColumnFooter.Cells(0, 7).Formula = "SUM(H1:H100)"
复制代码 我是这样设置公式的,这个单元格不刷新
另外请教下columnfooter怎么样在设计器中设置?没找到关于columnfooter的设置界面。 |