Chart title in 5.1.2.0 always bold

Aspose.Cells Product Family
1

Hi Guys,

I just started using Aspose.Cells 5.1.2.0 and notice that charts title is always set to bold.

Regards

Rale

ps. Here is the sample:

Workbook wb = new Workbook();

wb.Worksheets.Clear();

Worksheet ws = wb.Worksheets.Add("New");

Style style = wb.Styles[wb.Styles.Add()];

style.Name = "DateTimeStyle";

style.Custom = "dd-mm hh:mm:ss";

DateTime dt = DateTime.Now.Date;

ws.Cells[23, 2].PutValue(dt);

ws.Cells[23, 2].SetStyle(style);

ws.Cells[24, 2].PutValue(dt.AddHours(1));

ws.Cells[24, 2].SetStyle(style);

ws.Cells[25, 2].PutValue(dt.AddHours(2));

ws.Cells[25, 2].SetStyle(style);

ws.Cells[26, 2].PutValue(dt.AddHours(3));

ws.Cells[26, 2].SetStyle(style);

ws.Cells[27, 2].PutValue(dt.AddHours(4));

ws.Cells[27, 2].SetStyle(style);

ws.Cells[28, 2].PutValue(dt.AddHours(5));

ws.Cells[28, 2].SetStyle(style);

ws.Cells[29, 2].PutValue(dt.AddHours(6));

ws.Cells[29, 2].SetStyle(style);

ws.Cells[23, 3].PutValue(3);

ws.Cells[24, 3].PutValue(4);

ws.Cells[25, 3].PutValue(9);

ws.Cells[26, 3].PutValue(13);

ws.Cells[27, 3].PutValue(16);

ws.Cells[28, 3].PutValue(3);

ws.Cells[29, 3].PutValue(7);

Chart chart = ws.Charts[ws.Charts.Add(ChartType.ScatterConnectedByLinesWithoutDataMarker, 1, 1, 22, 12)];

chart.CategoryAxis.TickLabels.NumberFormat = "dd-mm hh:mm;@";

chart.CategoryAxis.TickLabels.Rotation = 45;

chart.CategoryAxis.TickLabels.Font.Size = 8;

chart.CategoryAxis.MinValue = dt;

chart.CategoryAxis.MaxValue = dt.AddHours(6);

double d = 1f / 24f;

chart.CategoryAxis.MajorUnit = 0.04166666;

chart.Legend.Position = LegendPositionType.Bottom;

chart.ValueAxis.TickLabels.NumberFormat = "0";

chart.ValueAxis.MinValue = 0;

chart.ValueAxis.MaxValue = 20;

chart.Placement = PlacementType.Move;

String chartSubTitle = DateTime.Now.ToString();

chart.Title.Text = "Data" + "\n" + chartSubTitle;

FontSetting chars = chart.Title.Characters(chart.Title.Text.Length - chartSubTitle.Length, chartSubTitle.Length);

chars.Font.Size = 10;

chars.Font.IsBold = false;

chart.ValueAxis.Title.Text = "unit";

Series aSerie = chart.NSeries[chart.NSeries.Add(String.Format("{0}!{1}{2}:{1}{3}", ws.Name, "D", 24, 30), true)];

aSerie.XValues = String.Format("{0}!{1}{2}:{1}{3}", ws.Name, "C", 24, 30);

aSerie.Name = "Date";

wb.Save(@"Result.xlsx", FileFormatType.Excel2007Xlsx);

2

Hi Ranko,

You may use any one of the following code snippet.

1. Title otitle = ochart.Title;
otitle.TextFont.IsBold = false;

2. chart.Title.Text = "Data" + "\n" + chartSubTitle;
chart.Title.TextFont.IsBold = false;

Thanks,

3

Hi Salman


I am sorry but this does not give me the result I expect. Please run my sample and use your suggestion no 2. You will notice that titles first row is not bold, while rest of the title (sub-title) is still in bold.

regards
Rale
4

you may use code below to test


Workbook wb = new Workbook();
wb.Worksheets.Clear();
Worksheet ws = wb.Worksheets.Add(“New”);
Style style = wb.Styles[wb.Styles.Add()];
style.Name = “DateTimeStyle”;
style.Custom = “dd-mm hh:mm:ss”;

DateTime dt = DateTime.Now.Date;
ws.Cells[23, 2].PutValue(dt);
ws.Cells[23, 2].SetStyle(style);
ws.Cells[24, 2].PutValue(dt.AddHours(1));
ws.Cells[24, 2].SetStyle(style);
ws.Cells[25, 2].PutValue(dt.AddHours(2));
ws.Cells[25, 2].SetStyle(style);
ws.Cells[26, 2].PutValue(dt.AddHours(3));
ws.Cells[26, 2].SetStyle(style);
ws.Cells[27, 2].PutValue(dt.AddHours(4));
ws.Cells[27, 2].SetStyle(style);
ws.Cells[28, 2].PutValue(dt.AddHours(5));
ws.Cells[28, 2].SetStyle(style);
ws.Cells[29, 2].PutValue(dt.AddHours(6));
ws.Cells[29, 2].SetStyle(style);
ws.Cells[23, 3].PutValue(3);
ws.Cells[24, 3].PutValue(4);
ws.Cells[25, 3].PutValue(9);
ws.Cells[26, 3].PutValue(13);
ws.Cells[27, 3].PutValue(16);
ws.Cells[28, 3].PutValue(3);
ws.Cells[29, 3].PutValue(7);

Chart chart = ws.Charts[ws.Charts.Add(ChartType.ScatterConnectedByLinesWithoutDataMarker, 1, 1, 22, 12)];
chart.CategoryAxis.TickLabels.NumberFormat = “dd-mm hh:mm;@”;
chart.CategoryAxis.TickLabels.Rotation = 45;
chart.CategoryAxis.TickLabels.Font.Size = 8;
chart.CategoryAxis.MinValue = dt;
chart.CategoryAxis.MaxValue = dt.AddHours(6);
double d = 1f / 24f;
chart.CategoryAxis.MajorUnit = 0.04166666;
chart.Legend.Position = LegendPositionType.Bottom;
chart.ValueAxis.TickLabels.NumberFormat = “0”;
chart.ValueAxis.MinValue = 0;
chart.ValueAxis.MaxValue = 20;
chart.Placement = PlacementType.Move;
String chartSubTitle = DateTime.Now.ToString();
chart.Title.Text = “Data” + “\n” + chartSubTitle;
FontSetting chars = chart.Title.Characters(chart.Title.Text.Length - chartSubTitle.Length, chartSubTitle.Length);
chars.Font.Size = 10;
chart.ValueAxis.Title.Text = “unit”;
chart.Title.TextFont.IsBold = false;

Series aSerie = chart.NSeries[chart.NSeries.Add(String.Format("{0}!{1}{2}:{1}{3}", ws.Name, “D”, 24, 30), true)];
aSerie.XValues = String.Format("{0}!{1}{2}:{1}{3}", ws.Name, “C”, 24, 30);
aSerie.Name = “Date”;
aSerie.Line.Color = Color.BlanchedAlmond;
aSerie.Line.Weight = WeightType.HairLine;
aSerie.MarkerStyle = ChartMarkerType.Diamond;
aSerie.MarkerBackgroundColorSetType = FormattingType.Automatic;
aSerie.MarkerBackgroundColor = Color.YellowGreen;
aSerie.MarkerForegroundColorSetType = FormattingType.Automatic;
aSerie.MarkerSize = 3;
wb.Save(@“Result.xlsx”, SaveFormat.Xlsx);
5

Hi,

Please add a line to your code segment, i.e…,
FontSetting chars = chart.Title.Characters(chart.Title.Text.Length - chartSubTitle.Length, chartSubTitle.Length);
chars.Font.Size = 10;
chars.Font.IsBold = false;


Thank you.

6

Hi Amjad


that helped. Works when both segments are added

thanks & regards
Rale