We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Error in modifying data label color

I upgraded the Dll from V21.6 to V21.8 and found that I could not modify the data label color properly.
Sample code:
Workbook workbook = new Workbook();
Worksheet worksheet = workbook.Worksheets[0];
worksheet.Cells[“A1”].PutValue(“学历”);
worksheet.Cells[“A2”].PutValue(“本科”);
worksheet.Cells[“A3”].PutValue(“专科”);
worksheet.Cells[“B1”].PutValue(“男生”);
worksheet.Cells[“B2”].PutValue(90);
worksheet.Cells[“B3”].PutValue(80);
worksheet.Cells[“C1”].PutValue(“女生”);
worksheet.Cells[“C2”].PutValue(55);
worksheet.Cells[“C3”].PutValue(63);
worksheet.Cells[“D2”].Formula = $“B2&“人””;
worksheet.Cells[“D3”].Formula = $“B3&“人””;
worksheet.Cells[“E2”].Formula = $“C2&“人””;
worksheet.Cells[“E3”].Formula = $“C3&“人””;

        int chartIndex = worksheet.Charts.Add(ChartType.BarStacked, 0, 5, 20, 15);
        Chart chart = worksheet.Charts[chartIndex];
        chart.Title.IsDeleted = true;
        chart.PlotArea.Area.FillFormat.FillType = FillType.None;
        chart.ChartArea.Area.FillFormat.FillType = FillType.None;
        chart.ValueAxis.MajorGridLines.IsVisible = false;
        chart.ShowLegend = false;
        var chartRange = $"{CellsHelper.CellIndexToName(1, 1)}:{CellsHelper.CellIndexToName(2, 2)}";
        chart.NSeries.Add(chartRange, true);
        for (int i = 1; i <= chart.NSeries.Count; i++)
        {
            var series = chart.NSeries[i - 1];
            series.Name = $"={CellsHelper.CellIndexToName(0, i)}";
            series.Name = $"={CellsHelper.CellIndexToName(0, i)}";
            series.XValues = $"{CellsHelper.CellIndexToName(1, 0)}:{CellsHelper.CellIndexToName(2, 0)}";
            series.DataLabels.LinkedSource = $"{CellsHelper.CellIndexToName(1, i+2)}:{CellsHelper.CellIndexToName(2, i+2)}";
            series.DataLabels.NumberFormatLinked = true;
            series.DataLabels.ShowCellRange = true;
            series.DataLabels.Font.Color = Color.White;
        }
        chart.CategoryAxis.IsPlotOrderReversed = true;
        chart.Calculate();
        workbook.Save("e:\\output.xlsx");

excelAndImage.zip (109.5 KB)

@Beyond5566,
We have logged the issue as “CELLSNET-48696” in our database for investigations. Once we will have some news for you, we will update you in this topic.

@Beyond5566,
This is to inform you that we have fixed your issue now. We will provide you the fixed version within the next few days after performing QA and incorporating other enhancements and fixes.

The issues you have found earlier (filed as CELLSNET-48696) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao