Formatting Issues for Excel Charts converted to PDF

aschledwitz · June 17, 2014, 12:17pm

when converting excel charts to PDF, I am running into a number of formatting issues in the final product.

We have version 7.7.2 in production, but these have also been verified as persistent issues in the latest version of 8.1.

Arrows are showing up mirrored along a vertical axis so are pointing in wrong direction
Legend lines and arrows are not displaying with proper weights.
Text overruns cell and is cut off
Bullet points do not render if they are within a text box
PDF is not displaying values from an HLOOKUP properly.
Multi line x axis labels are cut off. In version 7.7.2, the labels would overrun the cells with data below the chart. In the newest version the labels only display the first line and the rest is cut off.

Thank You

shakeel.faiz · June 17, 2014, 11:32pm

aschledwitz:
when converting excel charts to PDF, I am running into a number of formatting issues in the final product.

We have version 7.7.2 in production, but these have also been verified as persistent issues in the latest version of 8.1.

1. Arrows are showing up mirrored along a vertical axis so are pointing in wrong direction

2. Legend lines and arrows are not displaying with proper weights.

3. Text overruns cell and is cut off

Hi Alexander,

Thanks for your posting and using Aspose.Cells.

We were able to observe these issues after converting your Arrows and legend lines.xlsx into pdf using the latest version: Aspose.Cells for .NET v8.1.0.2.

We have logged these issues in our database for investigation. We will look into them and fix these issues. Once, these are resolved or we have some other update for you, we will let you know asap.

These issues have been logged as

CELLSNET-42748 - Legend lines are thiner than in Excel
CELLSNET-42749 - Arrow lines are too thick than in Excel
CELLSNET-42750 - Arrows are showing mirrored on a vertical axis
CELLSNET-42751 - Text overruns cell and is cut off

We used the following code for testing this issue. I have also attached the output pdfs and the screenshots highlighting the issues for a reference.

C#

string filePath = @"F:\Shak-Data-RW\Downloads\Arrows+and+legend+lines.xlsx";

Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + ".out.pdf");

shakeel.faiz · June 18, 2014, 10:37am

aschledwitz:
4. Bullet points do not render if they are within a text box

5. PDF is not displaying values from an HLOOKUP properly.

Hi Alexander,

Thanks for your posting and using Aspose.Cells.

We were able to observe these issues after converting your files (Bullet points within text area do not show.xlsx and Quilt text doesn't show properly.xlsx) into pdf using the latest version: Aspose.Cells for .NET v8.1.0.2.

We have logged these issues in our database for investigation. We will look into them and fix these issues. Once, these are resolved or we have some other update for you, we will let you know asap.

These issues have been logged as

CELLSNET-42756 - Bullet points do not render correctly if they are within a text box
CELLSNET-42757 - PDF is not displaying values from an HLOOKUP properly

We used the following code for testing this issue.

C#

Workbook workbook = new Workbook(filePath);
workbook.Save(filePath + ".out.pdf");

shakeel.faiz · June 18, 2014, 10:51am

aschledwitz:

5. Multi line x axis labels are cut off. In version 7.7.2, the labels would overrun the cells with data below the chart. In the newest version the labels only display the first line and the rest is cut off.

Thank You

                                </div></BLOCKQUOTE><br><br>Hi Alexander,<br><br>Thanks for your posting and using Aspose.Cells.<br><br>You have attached the <br><br><b>Attachment: </b><a href="https://forum.aspose.com/t/76876">X labels cut off.pdf </a><br><br>But you have not attached the xlsx file. Kindly attach its xlsx file so that we could check this issue with our latest version and log it in our database.<br><br>Also, for multiple issues, please always create multiple threads. It will help us look into your issues and fix them easily and in a better way.<br>

aschledwitz · June 18, 2014, 12:13pm

Apologies, I was unable to upload the file earlier. It is there now.

Thanks.

shakeel.faiz · June 18, 2014, 12:38pm

Hi Alexander,

Thanks for providing us the needed file and using Aspose.Cells.

We were able to observe this issue after converting your X labels cut off.xlsx into pdf using the latest version: Aspose.Cells
for .NET v8.1.0.2. X-axis labels are cut off and they only display the first line while rest does not show up.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

CELLSNET-42759 - X-axis labels of chart are cut off

I have attached the output pdf generated with the following code for a reference.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\X+labels+cut+off.xlsx”;

Workbook workbook = new Workbook(filePath);

workbook.Save(filePath + “.out.pdf”);

shakeel.faiz · June 18, 2014, 10:12pm

Hi Alexander,

Thanks for using Aspose.Cells.

For your issue logged as (CELLSNET-42757 - PDF is not displaying values from an HLOOKUP properly), please use the following code and it will fix your issue.

I have also attached the generated pdf by this code for your reference

C#

string filePath = @“F:\Shak-Data-RW\Downloads\Quilt+text+doesn’t+show+properly.xlsx”;

Workbook workbook = new Workbook(filePath);

workbook.CalculateFormula();

workbook.Save(filePath + “.out.pdf”);

aspose.notifier · June 27, 2014, 3:41am

The issues you have found earlier (filed as CELLSNET-42759;CELLSNET-42756;CELLSNET-42750;CELLSNET-42748) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

shakeel.faiz · July 8, 2014, 4:05am

Hi,

Thanks for your using Aspose.Cells.

We have fixed the issue

CELLSNET-42749 - Arrow lines are too thick than in Excel

Please download and try the latest fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

aspose.notifier · July 23, 2014, 2:07am

The issues you have found earlier (filed as CELLSNET-42749) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

shakeel.faiz · May 27, 2015, 5:14am

Hi,

Thanks for using Aspose.Cells.

We have fixed this issue.

CELLSNET-42751 - Text overruns cell and is cut off

Please download and try the latest fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

aspose.notifier · June 19, 2015, 5:54am

The issues you have found earlier (filed as CELLSNET-42751) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

ahsaniqbalsidiqui · November 26, 2018, 9:21am

@aschledwitz,

Please try our latest version/fix: Aspose.Cells for .NET v18.11.2 (attached)

Your issue (CELLSNET-42759) should be fixed in it.

Let us know your feedback.
Aspose.Cells18.11.2 For .Net2_AuthenticodeSigned.Zip (4.7 MB)
Aspose.Cells18.11.2 For .Net4.0.Zip (4.7 MB)