Free Support Forum - aspose.com

Format Chart Title... dialog window not displaying!

Any ideas as to why the “Format Chart Title…” dialog window is not displaying? When you right-click over the Chart Title the menu option appears to display the “Format Chart Title…” or “Clear” text but the dialog window does not launch.

Could you please post your file to show this problem? Thank you.

See attached file.

I will check this issue. Is this chart totally created by Aspose.Excel at run time, or imported from a template?

This is really a strange problem. Please try the attached fix.

If you still find this problem, could you please post your code here? Thank you.


And you can also try my test code:

Excel E = new Excel();
E.Worksheets.Add();

Cells C = E.Worksheets[0].Cells;

C.SetColumnWidth(0, 10);
C.SetColumnWidth(1, 10);
C[0, 0].PutValue("Age");
C[0, 1].PutValue("Income");
double Income = 50000.00;

for(int i = 1; i < 52; i++)
{
C[i, 0].PutValue(i-1);
C[i, 1].PutValue(Income);
C[i, 1].Style.Number = 42;
Income = Income + (Income * 0.05);
}

int ChartIndex = E.Worksheets[1].Charts.Add(ChartType.Bar3DClustered, 0, 0, 50, 20);
Aspose.Excel.Chart Ch = E.Worksheets[1].Charts[0];

Ch.NSeries.Add("Sheet1!B2:B52", true);
Ch.NSeries.CategoryData = "Sheet1!A2:A52";

Aspose.Excel.ASeries S;
S = Ch.NSeries[0];
S.Name = "=Sheet1!B1";

Ch.CategoryAxis.TickLabelSpacing = 1;
Ch.CategoryAxis.TickMarkSpacing = 1;

Ch.IsLegendShown = true;
Ch.Title.Text = "Age vs. Income";

E.Save("chart.xls", SaveType.OpenInExcel, FileFormatType.Default, this.Response);

Thanks. I won’t have time to try this until tomorrow morning. If the new dll doesn’t solve it I’ll post my code and another copy of the Excel file produced.

The dll you provided did not change the behavior. My code is attached. The dialog window is still not displaying. This is not a major issue as I’m able to control the format and content of the chart title through the api. I’m more interested in the DataTable which at this time can not be formatted through the api…I think the plan is to implement that functionality by July.

In the mean time I’ll probably use multiple designer templates that already contain the formatting I need. Thanks for your help.