troubleshooting Question

VFP Automation on MS-Graph

Avatar of Cyril Joudieh
Cyril JoudiehFlag for Lebanon asked on
Microsoft OfficeFoxProVisual Basic.NET
8 Comments1 Solution1597 ViewsLast Modified:

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:

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.

Cyril Joudieh
Founder, Software Engineer, Data Scientist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros