Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Keeping Excel object active
Message
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01200597
Message ID:
01200686
Views:
32
>Hi,
>
>I'm trying to use the "Excel.Sheet" as an OLE object in my form.
>I use it to serve as a advanced grid control where the user can edit, cut and paste selections of data.
>It's no problem to get a Excel OLE object into my form, but it needs me to activate it before to be able to edit the data.
>When i click out of the excel sheet it gets deactivated again.
>
>That isn't the biggest problem, but when changing from activated to non-activated or the other way around the screen flickers and several toolbars appear or disappear. Also the object size changes when activating/deactivating. The look of the data also changes. In edit mode it looks like fontsize 8 and in non-edit mode it looks like fontsize 24 with smaller column sizes.
>
>Is there a way to get this OLE control in control or do i really need to switch the user to excel to do his editing and data moving.
>I just want the simple behaviour of an excel sheet for working with ranges of data but it doesn't work out.

Does the screen effect still happen if you lock the screen or parent control?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform