Free Support Forum - aspose.com

Excel waterfall Chart.Calculate() adds a legend

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)

@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.

@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.