How do I determine whether a Chart border is visible or not?

workshare · February 26, 2019, 4:01pm

For your Shape objects, you have a HasLine property, which specifies whether the border of a Shape is visible or not. This seems to duplicate the value from the LineFormat.IsVisible property, but works well with all shapes… except for charts. For some reason, these properties always return false for charts, regardless of whether they have borders or not.

Please advise me on how I can determine whether a chart’s border is visible or not.

Many thanks and kind regards,
Sheridan

ahsaniqbalsidiqui · February 26, 2019, 4:45pm

@workshare,

Thanks for your query. Please try following sample code using the attached same file and provide your feedback.

Workbook wb = new Workbook(@"Book1.xlsx");
Chart withoutBorder = wb.Worksheets[0].Charts[0];
Chart withBorder = wb.Worksheets[0].Charts[1];
Console.WriteLine(withoutBorder.ChartArea.Border.IsVisible);
Console.WriteLine(withBorder.ChartArea.Border.IsVisible);

Book1.zip (13.7 KB)

workshare · February 27, 2019, 9:24am

Thank you ahsaniqbalsidiqui.

Amjad_Sahi · February 27, 2019, 9:56am

@workshare,

You are welcome. Feel free to write us back if you have further queries or issue, we will be happy to assist you soon.