Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Spreadsheet Style Calculations in a Grid
Message
From
12/09/1997 13:18:30
 
 
To
12/09/1997 12:54:51
Ryan Hirschey
Federal Reserve Bank of New York
New York City, New York, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00049865
Message ID:
00049876
Views:
49
>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.

You could use Cursor as Grid.RecordSource and use last record of the cursor to store recalculated numbers. Surely, you will enforce recalculation from Coulmn.Control.LostFocus events.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform