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.

Mon Apr 20, 2020 8:25 am

Hello,
if I do an export with an errorbar then it is correct in the excel file but if I then convert this excel into a PDF then the following error occurs including a "9" in the first column of the bar chart which of course confuses the data a bit . is there a workaround?
Attachments
ErrorBar Pdf.PNG
Moved errorbar
ErrorBar Pdf.PNG (5.44 KiB) Viewed 3243 times
ErrorBar Excel.PNG
Correct errorbar
ErrorBar Excel.PNG (3.55 KiB) Viewed 3243 times

Semjasa
 
Posts: 36
Joined: Wed Dec 19, 2018 11:50 am

Mon Apr 20, 2020 8:57 am

Hello,

Thanks for your inquiry.
To help us investigate your issue more accurately and quickly, please share your input file with us. You could upload here or send it to us(support@e-iceblue.com) via email.
Thanks in advance for your assistance.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Mon Apr 20, 2020 9:42 am

I used the code from this post
https://www.e-iceblue.com/forum/barchart-with-target-line-t8032.html

But here is a sample:
Code: Select all
            var workbook = new Workbook();
            var worksheet = workbook.Worksheets[0];
            worksheet.Range["A1"].Text = "Errorbar Excel / PDF";
            worksheet.Range["A3"].Text = "USA";
            worksheet.Range["B3"].Text = "Europa";
            worksheet.Range["C3"].Text = "Asia";

            worksheet.Range["A4"].NumberValue = 100;
            worksheet.Range["B4"].NumberValue = 100;
            worksheet.Range["C4"].NumberValue = 100;
            worksheet.Range["A5"].NumberValue = 200;
            worksheet.Range["B5"].NumberValue = 200;
            worksheet.Range["C5"].NumberValue = 200;
            worksheet.Range["A6"].NumberValue = 300;
            worksheet.Range["B6"].NumberValue = 300;
            worksheet.Range["C6"].NumberValue = 300;
            worksheet.Range["A7"].NumberValue = 400;
            worksheet.Range["B7"].NumberValue = 400;
            worksheet.Range["C7"].NumberValue = 400;

            var chart = worksheet.Charts.Add(ExcelChartType.ColumnClustered);
            chart.DataRange = worksheet.Range["A3:C7"];
            chart.SeriesDataFromRange = false;

            var errorbar = chart.Series[1];
            errorbar.SerieType = ExcelChartType.ScatterMarkers;
            errorbar.Format.MarkerStyle = ChartMarkerType.None;

            var eb = errorbar.ErrorBar(false, ErrorBarIncludeType.Both);
            eb.HasCap = false;
            eb.Border.Weight = ChartLineWeightType.Medium;
            eb.NumberValue = 0.3;

            workbook.SaveToFile("sample.xlsx", ExcelVersion.Version2016);
            workbook.SaveToFile("sample.pdf", FileFormat.PDF);

Semjasa
 
Posts: 36
Joined: Wed Dec 19, 2018 11:50 am

Mon Apr 20, 2020 10:28 am

Hello,

Thanks for your more information.
With the sample code you provided, I indeed notice that the error bar of the generated PDF file was inconsistent with the generated Excel file, as shown in the attached screenshot. This issue has been logged into our bug tracking system with the ticket SPIREXLS-2268. We will let you know if there is any update. Sorry for the inconvenience caused.
Besides, if convenient, please share your input file with us, so that after the issue SPIREXLS-2268 is fixed, we can conduct a comprehensive test and ensure your issue is completely resolved.

Sincerely,
Rachel
E-iceblue support team
Attachments
screenshot.png
screenshot.png (43.52 KiB) Viewed 3231 times
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Mon Apr 20, 2020 10:46 am

Thank you for your reply and I look forward to hearing from you.

Sincerely yours

Semjasa
 
Posts: 36
Joined: Wed Dec 19, 2018 11:50 am

Tue Apr 21, 2020 1:06 am

Hello,

You are welcome.
Once there is any good news on this issue, we will notify you ASAP.

Sincerely,
Rachel
E-iceblue support team
User avatar

rachel.lei
 
Posts: 1571
Joined: Tue Jul 09, 2019 2:22 am

Fri Dec 17, 2021 9:31 am

Hello,

Sorry for the long silence. Glad to inform that we just released Spire.XLS Pack(Hotfix) Version:11.12.2 which fixed SPIREXLS-2268. You can download it from the following links to test.
Website:https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget: https://www.nuget.org/packages/Spire.XLS/11.12.2

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Mon Dec 27, 2021 9:04 am

Hello,

Greetings from E-iceblue. Did the hotfix version work for you? Thanks in advance for your feedback and time.

Sincerely,
Lisa
E-iceblue support team
User avatar

Lisa.Li
 
Posts: 1261
Joined: Wed Apr 25, 2018 3:20 am

Return to Spire.XLS