troubleshooting Question
VFP Automation on MS-Graph
asked on
Hello,
I am automating the preview of MS-Graph in VFP forms and their exports into Excel and PowerPoint.
There are way too many options on the software now to customize the charts (color, font, style, shadow, gradient, ...) and each time I change a property in the graph it has to refresh. So previewing a handful of columns is taking like 5-10 seconds to refresh. If I use other plotters it is done instantaneously.
I read on MSDN and other places that there is a Repaint Property:
http://msdn.microsoft.com/en-us/library/67a838cc(v=vs.71).aspx
However, it seems only to be available in .Net.
I also tried to hide the chart (oChart.Visible = False) and to lock the VFP form from refreshing (LockScreen = .T.) and it improved the performance a bit.
Does anyone know how to handle this? I need to stop MS-Graph from refreshing when I assign all the properties I need.
Thanks!
Cyril
I am automating the preview of MS-Graph in VFP forms and their exports into Excel and PowerPoint.
There are way too many options on the software now to customize the charts (color, font, style, shadow, gradient, ...) and each time I change a property in the graph it has to refresh. So previewing a handful of columns is taking like 5-10 seconds to refresh. If I use other plotters it is done instantaneously.
I read on MSDN and other places that there is a Repaint Property:
http://msdn.microsoft.com/en-us/library/67a838cc(v=vs.71).aspx
However, it seems only to be available in .Net.
I also tried to hide the chart (oChart.Visible = False) and to lock the VFP form from refreshing (LockScreen = .T.) and it improved the performance a bit.
Does anyone know how to handle this? I need to stop MS-Graph from refreshing when I assign all the properties I need.
Thanks!
Cyril
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.