Line marker fill

Aspose.Cells Product Family
1

Hi,

I wonder why some of the markers in charts are not filled by default. Run for instance this:

Workbook wb = new Workbook();

Worksheet ws = wb.Worksheets["Sheet1"];

Cells cell = ws.Cells;

cell[0, 0].PutValue(3);

cell[0, 1].PutValue(4);

cell[0, 2].PutValue(5);

cell[1, 0].PutValue(2);

cell[1, 1].PutValue(3);

cell[1, 2].PutValue(4);

int chartIndex = ws.Charts.Add(ChartType.LineWithDataMarkers, 3, 0, 25, 13);

Chart chart = ws.Charts[chartIndex];

chart.NSeries.Add("A1:C2", false);

wb.Save("test.xls", FileFormatType.Excel2003);

I use .net2 v4.3.0.0. I think to remember that they used to be filled by default when first testing aspose.cells (probably v4.2).

Best,

-Hendri.

2

Hi,

I tried your codes and the created chart's default marker is same as the chart created as the Excel.

Could you create the chart with Excel and post it here? We will check it.

3

Hi Warren,

I didn't check that, but indeed, excel2003 itself also doesn't fill the markers of the top line. Strange. Excel2000 does do that, just tested that. But Aspose saving as excel2000 doesn't fill all markers, also tested that. I will write a routine to fill all markers after making a chart.

Best,

-Hendri.

4

Hi,

Please set the marker by yourself. The default marker is automatic if the chart is created by Aspose.Cells. It works as Excel.