LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 11th 09, 03:44 AM posted to microsoft.public.excel.programming
external usenet poster
First recorded activity by ExcelBanter: Jan 2010
Posts: 6
Default Excel.Chart size changes after copy-paste into Word

Hi There,

I met a problem about Excel.Chart. The scenario I'm experiencing as below:

I have an add-in for Word & PowerPoint, in which a hidden Excel process
is running as the source of content. Firstly I create an Excel Live Chart
inside Excel and manipulates its size by the following call:

Excel.Chart _chart =
(Excel.Chart)_workbook.Charts.Add(_missing, _missing, _missing, _missing);
_chart.PageSetup.ChartSize =
Microsoft.Office.Interop.Excel.XlObjectSize.xlScre enSize;
_chart.ChartArea.Width = width; // Specified width
_chart.ChartArea.Height = height; // Specified height

After the "Chart" is created, I will return to the host
application(Word/PowerPoint) and using copy-paste to the host application,
but here I met a problem. The final object's "Original Size" is not the size
that we specified in the above step, but the "Absolute Size" is what we
specified in the above step, since we are creating a "Pie" chart, so the
chart got skewed caused by the scaling. This problem only happens in Word
2007, not exists in Word 2003, PowerPoint 2003/2007.

The paste method we use in Word like below:

_app.Selection.Range.PasteSpecial(ref missing, ref link, ref placement, ref
displayAsIcon, ref dataType, ref missing, ref missing);

The data type is "OleObject".

Can anyone help on this problem? Thanks!

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy-Paste Chart into Word from Excel 2007 Sue O'Donnell Excel Discussion (Misc queries) 3 May 1st 10 07:05 PM
Copy/Paste custom Excel chart to Word/PowerPoint Andy Excel Discussion (Misc queries) 0 September 1st 09 08:51 PM
How do I copy paste from excel to word without getting a chart Arichmond Excel Discussion (Misc queries) 2 August 1st 07 11:18 AM
Distorted Excel chart fonts when copy/paste to Word or Powerpoint JJMB Charts and Charting in Excel 2 March 18th 06 06:43 PM
Copy and paste Excel chart in Word -- font compresses ScooterGirl Charts and Charting in Excel 3 February 10th 06 03:25 AM

All times are GMT +1. The time now is 09:29 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017