Excel waterfall Chart.Calculate() adds a legend

Aspose.Cells Product Family
,
1

Hi,

I noticed that executing the Calculate() command on a waterfall chart adds the legend although the chart didn’t have a legend initially.

Code:

using (var workbook = new Workbook("./Input.xlsx"))
{
workbook.Worksheets[0].Charts[0].Calculate();
workbook.Save("./Output.xlsx");
}

I’ve attached the test files and a screenshot for your reference. Could you please look into that?
Thanks,

waterfallTest.zip (27.0 KB)
waterfallScreenshot.PNG (9.6 KB)

2

@ServerSide527,

Please notice, I am able to reproduce the issue as you mentioned by using your sample code with your template file. I noticed that Chart.Calculate() method adds the legend box unnecessarily. I have logged a ticket with an id “CELLSNET-47762” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

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

4

@ServerSide527

Please try the latest fix 21.1.2
Aspose.Cells21.1.2 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.1.2 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.1.2 For .NetStandard20.Zip (5.5 MB)

Your issue should be fixed now.

Let us know your feedback.