Issue with Transparency property of Charts

Aspose.Cells Product Family
1

Hi,

I am near to the solution but stopped by an issue with applying "Transparency" property. I am setting the transperency value between 0 to 1 but it was not applying.

Please see the blow code and attached generated excel workbook. Could you please send me the solution ASAP because i needs to deliver this report to high level management.

CODE :


//
//Voluntary Turnover Count
//
Series seriesVoluntaryTurnoverCount = chart.NSeries[1];
seriesVoluntaryTurnoverCount.Name = "Voluntary Turnover Count";

seriesVoluntaryTurnoverCount.Area.FillFormat.Pattern = FillPattern.Solid;
seriesVoluntaryTurnoverCount.Area.ForegroundColor = Color.FromArgb(23, 55, 94);
seriesVoluntaryTurnoverCount.Area.BackgroundColor = Color.FromArgb(23, 55, 94);
seriesVoluntaryTurnoverCount.Area.Transparency = 0.37;

seriesVoluntaryTurnoverCount.DataLabels.ShowValue = true;
seriesVoluntaryTurnoverCount.DataLabels.Position = LabelPositionType.InsideBase;
seriesVoluntaryTurnoverCount.DataLabels.Font.IsBold = true;

seriesVoluntaryTurnoverCount.GapWidth = 25;
//

//
//Involuntary Count
//
Series seriesInvoluntaryTurnoverCount = chart.NSeries[2];
seriesInvoluntaryTurnoverCount.Name = "Involuntary Turnover Count";
seriesInvoluntaryTurnoverCount.Area.FillFormat.Pattern = FillPattern.Solid;
seriesInvoluntaryTurnoverCount.Area.ForegroundColor = Color.FromArgb(142, 180, 227);
seriesInvoluntaryTurnoverCount.Area.BackgroundColor = Color.FromArgb(142, 180, 227);
seriesInvoluntaryTurnoverCount.Area.Transparency = 0.61;

seriesInvoluntaryTurnoverCount.DataLabels.ShowValue = true;
seriesInvoluntaryTurnoverCount.DataLabels.Position = LabelPositionType.InsideEnd;
seriesInvoluntaryTurnoverCount.DataLabels.Font.IsBold = true;
//

//
//Turnover Rate%
//
Series seriesTurnoverRate = chart.NSeries[3];
seriesTurnoverRate.Name = "Turnover Rate";
seriesTurnoverRate.Type = ChartType.Line;
seriesTurnoverRate.Border.Style = LineType.Solid;
seriesTurnoverRate.Border.WeightPt = 2.25;
seriesTurnoverRate.Border.Color = Color.Red;
seriesTurnoverRate.DataLabels.ShowValue = true;
seriesTurnoverRate.DataLabels.Position = LabelPositionType.Below;
seriesTurnoverRate.DataLabels.Number = 9;
seriesTurnoverRate.PlotOnSecondAxis = true;
//

//
//Format Chart
//
chart.CategoryAxis.TickLabels.NumberFormat = "MMM-yy";
chart.SecondValueAxis.IsVisible = true;
//

2

Hi,


Thanks for providing us details and sample file.

I can notice the issue as you have mentioned. I cannot set the Transparency for the data series in charts. I used your template file and used the following sample code:

Sample code:

Workbook workbook = new Workbook(“e:\test2\Issue+with+applying+Transparency.xlsx”);
Worksheet sheet = workbook.Worksheets[1];
Chart chart = sheet.Charts[0];

Series seriesVoluntaryTurnoverCount = chart.NSeries[0];
Debug.WriteLine(seriesVoluntaryTurnoverCount.Name);


seriesVoluntaryTurnoverCount.Area.Transparency = 0.6;



workbook.Save(“e:\test2\out.xlsx”);

The Transparency does not specify for the first series in the chart.

I have logged a ticket with an id “CELLSNET-41625” for your issue. We will look into your issue to figure it out soon.

Thank you.
3

Hi,

This is the followup on my email regarding “Transparency” issue. Can i have any ETA on this ?
We are waiting for the resolution…

Thanks
Venkata
4

Hi,


I am afraid, there is no update on it at the moment.
I have asked the concerned developer to update on it or provide an eta for your issue. Once we have any update on it, we will let you know here.

Sorry for any inconvenience caused!
5

Hi,

Please try our latest fix/version: Aspose.Cells for .NET v7.4.3.1

Please try the new fix and run the code in the attachment. For setting the
transparency of the area, first you need to change the fill type(refer to the
CELLSNET-41625.jpg in the attachment),

The fill type can be solid fill, gradient fill, pattern fill and texture fill, then find the correlative fill objects, SolidFilll, GradientFill,PatternFill, TextrueFill of area.FillFormat,

At last, set the colors and transparency of the fill object.

Thank you