Hello
I have a some automation code written in mfc c++ that creates a chart in an
excel sheet that I create that works fine in excel 2003, but not in excel
2007. It generates an exception.
Error Codes :
tCode = 80070057
Code meaning = The parameter is incorrect
tSource = S
tDescription = This object has no title.
Piece of C++ code :
RangePtr pBrHRange = pBRSheet->Range["Q10:S34"][vtMissing];
_ChartPtr pBrHChart = pBook->Charts->Add();
pBrHChart->ChartWizard((Range*) pBrHRange, (long) xl3DColumn, vtMissing,
(long) xlColumns, 1, 1, 0, "Bright Field Size Chart", "Cell Size (microns)",
"Number of Cells" );
pBrHChart->Name = "Bright Field Size Chart";
The exception is blows on pBrHChart->ChartWizard() with excel 2007, but runs
fine and correctly creates the chart with Excel 2003. If I change
pBRSheet->Range["Q10:S34"][vtMissing]; to
pBRSheet->Range["Q10:R34"][vtMissing]; it works fine, but does not display
the correct chart.
Sample Data in the Q,R,S columns
2.05 2 0
2.37 0 0
2.70 6 0
3.03 0 0
3.36 0 0
3.68 91 0
4.01 0 0
4.34 0 0
4.66 0 1
4.99 0 0
5.32 3 3
5.65 3 0
5.97 0 0
6.30 1 0
6.63 0 0
6.96 0 0
7.28 0 0
7.61 0 0
7.94 1 0
8.26 0 0
8.59 0 0
8.92 0 0
9.25 0 0
9.57 0 0
9.90 0 1
Any clues to what has changed and how to work arround it would be
appreciated. Thanks.
Kevin
|
Similar Threads
