''' StatusBar.Message1 = "" Dim s As String Dim sum As Double If CurrentTable IsNot Nothing Then If e.Table.RowSel < 0 OrElse e.Table.ColSel < 0 Then Return End If For Each c As Col In CurrentTable.Cols sum = 0 If c.IsNumeric Then For i As Integer = e.NewRange.TopRow To e.NewRange.BottomRow sum + = CurrentTable.Rows(i)(c.Name) Next s + = c.Name & " " & sum & " " End If Next StatusBar.Message1 = "当前区域合计:" & " 总行数 " & e.NewRange.BottomRow - e.NewRange.TopRow + 1 & " " & s Else StatusBar. Reset() End If
|