We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Custom Formatting Not Rendering Correctly For Cells PDF Save - Differs from Excel PDF

We found an issue where Aspose.Cells doesn’t seem to be rendering custom formats correctly, resulting in a very different appearance when the PDF is exported from Excel vs. Aspose. See attached PDFs. Is there a setting we missed, or would a fix be needed?

Thanks.

Aspose Version: 8.7.0 from NuGet
Excel Version: 2010, 14.0.7162.5000 (32 bit)

Steps to Reproduce:
  1. Obtain AsposeHideByFormattingTest.xlsx
  2. Execute sample code below, taking care to point inputFile to location of AsposeHideByFormattingTest.xlsx
  3. AsposeHideByFormattingTest.pdf has extraneous data to the right of the table. This is not present when Excel 2010 exports to PDF.

Code to Reproduce:

public static void testSaveToPDF(){
string inputFile = @“C:\temp\Aspose\AsposeHideByFormattingTest.xlsx”;

Aspose.Cells.Workbook Wb;
Wb = new Aspose.Cells.Workbook(inputFile);

Wb.Save(@“C:\temp\Aspose\AsposeHideByFormattingTest.pdf”);
}

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe this issue by converting your excel file into pdf using the latest version:Aspose.Cells for .NET (Latest Version) with the following sample code and found that save to pdf showing extraneous data to the right of the table.

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-44215 - Save to pdf showing extraneous data to the right of the table

I have also attached the output pdf generated with this code and screenshot highlighting this issue for a reference.

C#

string filePath = @“F:\Shak-Data-RW\Downloads\AsposeHideByFormattingTest.xlsx”;

Workbook workbook = new Workbook(filePath);

workbook.CalculateFormula();

PdfSaveOptions opts = new PdfSaveOptions();
opts.OnePagePerSheet = true;

workbook.Save(filePath + “.out1.pdf”, opts);

Thanks Shakeel. We hope to see a fix soon. :slight_smile:

Hi again,


This is to update you that we have resolved the problem logged earlier as CELLSNET-44215. We will shortly provide the fix here after ensuring the quality and incorporating other enhancements.

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


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