Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Sep 14, 2021 12:30 pm

Hello,

Following is the code snippet to create error bars in the excel. But in the exported excel file error bars does not have Caps.

ChartSerie oSeries = xlCharts.Series.Add();
oSeries.Name = seriesname;
oSeries.CategoryLabels = xlWorkSheet.Range[listchartseries[i].XFrom.x, listchartseries[i].XFrom.y, listchartseries[i].XTo.x, listchartseries[i].XTo.y];
oSeries.Values = xlWorkSheet.Range[listchartseries[i].YFrom.x, listchartseries[i].YFrom.y, listchartseries[i].YTo.x, listchartseries[i].YTo.y];
oSeries.Format.MarkerBorderWidth = chart1.Series[i].BorderWidth;
oSeries.Format.Fill.FillType = ShapeFillType.SolidColor;
oSeries.Format.Fill.ForeColor = listchartseries[i].SeriesColor;
var eb = oSeries.ErrorBar(true, ErrorBarIncludeType.Both, ErrorBarType.StandardError);
oSeries.Format.MarkerStyle = ChartMarkerType.Square;
oSeries.Format.MarkerSize = 4;

oSeries.ErrorBarsY.HasCap = true;
eb.HasCap = true;

eb.Border.Color = listchartseries[i].SeriesColor;
eb.Border.Pattern = ChartLinePatternType.Dash;

veenakanade
 
Posts: 5
Joined: Tue Sep 14, 2021 12:27 pm

Wed Sep 15, 2021 3:43 am

Hello,

Thanks for your inquiry.
I simulated an excel file and tested your case, and I did reproduce your issue, I have logged it in our bug tracking system with the ticket SPIREXLS-3449. If there is any update, we will let you know.

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Wed Sep 15, 2021 4:32 am

Thank you for the reply.
Is there any workaround I can implement here. I have my application delivery due soon and need to resolve this issue asap.

Thanks.

veenakanade
 
Posts: 5
Joined: Tue Sep 14, 2021 12:27 pm

Wed Sep 15, 2021 7:27 am

Hello,

Thanks for your response.
I am sorry that there is no good solution for the time being. Our Dev team will investigate it further. Anyway, if there is any progress, we will inform you immediately.

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Wed Sep 15, 2021 9:17 am

Hello,

Thank you for the reply.

Any approximate time estimate you can give for the fix, that would be great.

Thanks.

veenakanade
 
Posts: 5
Joined: Tue Sep 14, 2021 12:27 pm

Wed Sep 15, 2021 10:06 am

Hello,

Thanks for your response.
Sorry that we are unable to tell you an estimated time about fixing at this moment. Our Dev team will investigate further and fix it. Anyway, we have given your issue a high priority. I will keep you informed if there is any update. Apologize for the inconvenience caused.


Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Mon Oct 25, 2021 9:25 am

Hello,

Greetings from E-iceblue!
Glad to inform you that we just released Spire.XLS Pack(Hotfix) Version:11.10.4 which fixes your issue, please download it from the following links to test on your side. Looking forward to your test result.
Website link: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/11.10.4

Sincerely,
Brian
E-iceblue support team
User avatar

Brian.Li
 
Posts: 1271
Joined: Mon Oct 19, 2020 3:04 am

Return to Spire.XLS