Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Spreadsheet style grid wanted
Message
 
 
To
02/08/1999 13:27:41
Elyse Pomerantz
Dynamic Data Concepts, Inc.
Brooklyn, New York, United States
General information
Forum:
Visual FoxPro
Category:
Classes - VCX
Miscellaneous
Thread ID:
00248822
Message ID:
00248929
Views:
17
>>>Does anyone have or know of a spreadsheet-style grid? I need a grid that can sub-total/total records within the grid, perhaps using different colors for the Total records. It can be read-only as I don't have to enter data in the grid. I just need it for display, but I want the user to be able to filter the data based on certain criteria and have the sub-totals/totals refresh.
>>>
>>>Thanks!
>>>Elyse
>>
>>I use an Excel Worksheet control on a VFP form. Then I put @sum() formulas in the appropriate cells.
>
>How do you do this? Where did you get an Excel Worksheet control from?

It came from MS with VFP 6. It is an activeX Control, and as long as it is in your VFP Controls List (see VFP Options sheet), you can drop this control on the form. Of course your users have to have Excel installed. If this is not an option, you may have to revert to the grid. In my invoicing form, I used textboxes that kept running totals of grid columns.
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform