Font- Style- Transparency problems

Aspose.Cells Product Family
1
Dear Sir/madam,

We are converting Excel files to PDF/A-1b files.
.Net version 4.5
Aspose.Cells version 8.4.2.0

Sample Code:

var workbook = new Workbook("source.xls");
workbook.Settings.CultureInfo = CultureInfo.DefaultThreadCurrentCulture;

var pdfSaveOptions = new PdfSaveOptions
{
Compliance = PdfCompliance.PdfA1b,
AllColumnsInOnePagePerSheet = true
};

pdfSaveOptions.WarningCallback = new AsposeCellsWarningCallback();

workbook.Save("result.pdf", pdfSaveOptions);

I have attached the images that shows what relevant differences we found:
- Font of texts
- Style of tboxes
- Line style
- Black dots in charts' red points
etc.

I have attached 2 source and result file, and the images that contains the differences for both conversions.


Thanks for your help.

2

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe the issues as shown in your screenshots with the latest version: Aspose.Cells
for .NET v8.4.2.5 after converting your excel file into pdf with the following sample code.

Please download the attached pdf generated with the following code and add comments inside it highlighting/describing your issues so that we log each of your issue separately based on your comments. It will help us investigate and fix these issues more quickly and easily. Thanks for your cooperation.

C#


string filePath = @“D:\Downloads\x\Level2_Vacation_planner.xlsx”;


var workbook = new Workbook(filePath);


var pdfSaveOptions = new PdfSaveOptions

{

Compliance = PdfCompliance.PdfA1b,

AllColumnsInOnePagePerSheet = true

};


workbook.Save(“result.pdf”, pdfSaveOptions);


3

Hi,

We have tried to sign all the issues. Check the images attached:

  • Pictures

  • Transaprency

  • Moved objects

  • Style diff

  • Another border style

  • Date and times - format

  • Date and times diff as in Spreadsheet

Best regards,

Zsolt Amschl

4

Hi,

Thanks for your posting and using Aspose.Cells.

We were able to observe these issues and logged them 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-43684 - Fonts of textboxes are not correct in the output PDF
  • CELLSNET-43685 - Style of Textboxes is not correct in the output PDF
  • CELLSNET-43686 - Transparency is not correct in the output PDF
  • CELLSNET-43687 - Moved objects in the output PDF

5

@zsole
For CELLSNET-43684, CELLSNET-43685 and CELLSNET-43687,please try our latest version Aspose.Cells 21.6.0.
If you find any issue, please provide the source Excel file to help us analyze it.