I have a grid that needs to perform calculations. I am using the ugrdAScheduleMaint_UpdateCell event, though the page refreshes every time a cell is changed. It does what is suppose to but I was seeing if there was a way to prevent the refresh of the entire page. I am using VB 2003 .NET 2.0
Private
ugrdAScheduleMaint.UpdateCell
'Sets Accrual Rate value to zero when Cost Method is choosen in Accrual Method
Then
e.Cell.Row.Cells(ColumnIndex("Accrual Rate")).Value = 0
If
'sets the format for percentage columns in the UltraWebGrid
e.Cell.Column.Header.Caption
(e.Cell.Text.Replace("%", "")).ToString("N4") & "%"
(e.Cell.Text.Replace("%", "")).ToString("n4") & "%"
Select
'solves the interest formula.
= _
(
(e.Cell.Row.Cells(ColumnIndex("Accrual Rate")).Text.Replace("%", "")) _
*
(e.Cell.Row.Cells(ColumnIndex("Beginning CV")).Text.Replace("$", "").Replace(",", ""))) _
/ 12
e.Cell.Row.Cells(ColumnIndex("Interest")).Value = decInterest
'Solves the ending balance Formula (begbal + interest + Advances .....
(e.Cell.Row.Cells(ColumnIndex("Beginning CV")).Text.Replace("$", "").Replace(",", ""))) + _
(e.Cell.Row.Cells(ColumnIndex("Advances")).Text.Replace("$", "").Replace(",", ""))) + _
(e.Cell.Row.Cells(ColumnIndex("Interest")).Text.Replace("$", "").Replace(",", ""))) + _
(e.Cell.Row.Cells(ColumnIndex("Gains Loss On Payoff")).Text.Replace("$", "").Replace(",", ""))) + _
(e.Cell.Row.Cells(ColumnIndex("Adjustments")).Text.Replace("$", "").Replace(",", ""))) - _
(e.Cell.Row.Cells(ColumnIndex("Provisions")).Text.Replace("$", "").Replace(",", ""))) + _
(e.Cell.Row.Cells(ColumnIndex("Recoveries")).Text.Replace("$", "").Replace(",", ""))) - _
(e.Cell.Row.Cells(ColumnIndex("Collections")).Text.Replace("$", "").Replace(",", "")))
e.Cell.Row.Cells(ColumnIndex("Ending CV")).Value = eBalance
.Session.Item("MethodValueList")
Sub