Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Embedded Excel worksheet's size changed after double-clicking in P
Hi there,
Currently we are programmatically copy/pasting something(grid, live chart) from Excel into PowerPoint as an embedded workbook and we modify the original size so that the pasted result will be appropriate to be placed into PowerPoint. We have achieved the functionality as above, but we meet some problems when user double clicking on that embedded excel worksheet. After double clicking , the user return to the slide, we find that the "embedded worksheet" size changed. Some conditions required for this problem to happen: 1. This only happens in Office 2007.(Excel 2007, PowerPoint 2007). 2. This only happens when want to embed a "live chart" into PowerPoint slide, but there is no such problem for embedding a "grid". We create the "Live Chart€¯ and manipulates its size by the code below: 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 The "paste" code is 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Opening an Excel worksheet by double-clicking the filename | Excel Discussion (Misc queries) | |||
Can only open files from in Excel, not from double clicking on the | Excel Discussion (Misc queries) | |||
Opening Excel by double-clicking a file doesn't work! | Excel Discussion (Misc queries) | |||
Excel do not open the files when double clicking | Excel Discussion (Misc queries) | |||
Openning Excel by double clicking on the file name in Explorer | Excel Discussion (Misc queries) |