Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have some charts that I create through C# code on a "template" worksheet
and then copy it over to a new worksheet using the following code. When looking at the chart.Shapes, I can see the three Textbox objects that I want and these are the only shapes available. I can see them on the screen in both Excel 2003 and 2007 correctly. When I print in 2003 though, the textboxes don't appear like they do for 2007. Can anyone shed some light on why this might be happening? // Copy the images and charts (note index starts at 1) for (int z = 1; z <= wsTemplate.Shapes.Count; z++) { ((Excel.Shape)wsTemplate.Shapes.Item(z)).Copy(); wsClientPatient.get_Range("A1", "A1").Activate(); ((Excel.Worksheet)app.ActiveSheet).Paste(Missing.V alue, Missing.Value); } for (int chartNum = 1; chartNum <= 2; chartNum++) { chart = ((Excel.ChartObject)wsClientPatient.ChartObjects(c hartNum)).Chart; chart.ChartArea.Top = (chartNum == 1) ? 868 : 1047; chart.ChartArea.Left = 25; // Temporary test for (int z = 1; z <= chart.Shapes.Count; z++) { object y = chart.Shapes.Item(z); Microsoft.Office.Core.MsoShapeType yy = chart.Shapes.Item(z).Type; } } |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel chart does not print in Office 2007 | Charts and Charting in Excel | |||
Office 2007 compatibility pack on Office 2003 (slow network file | Setting up and Configuration of Excel | |||
Office 2007 compatibility at office 2003 is not working for graphs | Excel Discussion (Misc queries) | |||
Opening an Office 2007 Excel file in Office 2003 | Excel Discussion (Misc queries) | |||
Performance not upto Office 2003 standards in Office 2007 | Excel Discussion (Misc queries) |