Free Support Forum - aspose.com

Formatting Issues for Excel Charts converted to PDF

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

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

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

  6. 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

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");

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");


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="http://www.aspose.com/community/forums/553522/26858/postattachment.aspx">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>

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

Thanks.

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”);

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”);

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.

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.

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.

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.

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.

@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)