Double Clicking Chart object at PP slide clears chart's DataSheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sonic - 12 Sep 2006 13:38 GMT

Hi,

I'm building a PP presentation in C#,
working with "VS2003" and "PowerPoint 11 Object Library".
When i double click a chart in a slide in the built presentation,
the chart returns to be a basic chart(like when you add a new chart), and the
chart's data sheet returns to default values.
Any idea how to solve this problem?

Reply to this Message

Andy Pope - 12 Sep 2006 14:31 GMT

Hi,

Did you use the .Update method before closing the object in your code?
Sorry I don't know the C# syntax but it can not be that different from
VB(A).

Cheers
Andy

> Hi,
>
[quoted text clipped - 4 lines]
> chart's data sheet returns to default values.
> Any idea how to solve this problem?

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Sonic - 12 Sep 2006 16:31 GMT

Thanks for the response.
There is no "Update" method for the Presentation object, Slide object or
Chart object.

> Hi,
>
[quoted text clipped - 13 lines]
> > chart's data sheet returns to default values.
> > Any idea how to solve this problem?

Reply to this Message

Steve Rindsberg - 12 Sep 2006 20:07 GMT

> Thanks for the response.
> There is no "Update" method for the Presentation object, Slide object or
> Chart object.

It's not clear what type of charts these are, but if they're MSGraph objects, the
MSGraph Application object has an Update method. Call that just before calling Quit
and you should be in good shape.

> > Hi,
> >
[quoted text clipped - 13 lines]
> > > chart's data sheet returns to default values.
> > > Any idea how to solve this problem?

-----------------------------------------
Steve Rindsberg, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Reply to this Message

Sonic - 13 Sep 2006 09:27 GMT

The Chart's namespace is "Microsoft.Office.Interop.Graph.Chart".
Here is how I get the chart from the slide:

Microsoft.Office.Interop.Graph.Chart oChart =
(Microsoft.Office.Interop.Graph.Chart)ppSlide.Shapes[slideSet.ShapeIndex].OLEFormat.Object;

The "Chart" object has no "Update" method.
The data is inserted to the Chart, but the problem it disappears when
double clicking the Chart at the slide.

> > Thanks for the response.
> > There is no "Update" method for the Presentation object, Slide object or
[quoted text clipped - 27 lines]
> PPTools: www.pptools.com
> ================================================

Reply to this Message

Andy Pope - 13 Sep 2006 09:44 GMT

Have you tried

oChart.Application.Update

Cheers
Andy

> The Chart's namespace is "Microsoft.Office.Interop.Graph.Chart".
> Here is how I get the chart from the slide:
[quoted text clipped - 37 lines]
>>PPTools: www.pptools.com
>>================================================

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Reply to this Message

Sonic - 13 Sep 2006 12:15 GMT

Problem solved.
The code line is:
"oChart.Application.Update();"

Thank you Andy and Steve.

> Have you tried
>
[quoted text clipped - 44 lines]
> >>PPTools: www.pptools.com
> >>================================================

Reply to this Message