Does anyone have any advice on how to perform spreadsheet style calculations in a grid? I have an application that has info in debit and credit fields. I want to display a calculated balance for each line item. To do this, each row in the grid will have to 'look' not only at its own debit and credit cells, but also the balance from the previous row. I am able to do calculations for each row in an array that has an item for each record, but am unsure how to get the array data into the balance cell.
Ryan Hirschey