Error converting currency and euro sign

Aspose.Cells Product Family
1

Hi,


I’m trying to use Aspose.Cells to save an Excel document to PDF but I’m having problems with currency format and euro sign.
Currency numbers show up as 0 in the PDF, decimal places and “1000 separator (.)” are ignored.
There’s also a problem with the Euro sign (€) that doesn’t respect font size in the PDF file.

I attached the files used for this test.
I also used a trial of the latest version of Aspose.Cells.

Here goes the code used:

var workbook = new Aspose.Cells.Workbook();
workbook.Open(“TestFile.xlsx”);

foreach (Aspose.Cells.Worksheet sheet in workbook.Worksheets)
{
sheet.PageSetup.PaperSize = PaperSizeType.PaperA4;
sheet.PageSetup.FitToPagesTall = 1;
sheet.PageSetup.FitToPagesWide = 1;
sheet.PageSetup.CenterHorizontally = true;
sheet.PageSetup.CenterVertically= true;
sheet.PageSetup.TopMargin = 0;
sheet.PageSetup.BottomMargin = 0;
sheet.PageSetup.LeftMargin = 0;
sheet.PageSetup.RightMargin = 0;
sheet.PageSetup.IsPercentScale = false;
}

//save excel to pdf
workbook.Save(“PDF_From_Excel.pdf”, FileFormatType.Pdf);

Can someone please help me with this issue?

Best regards

Roger
2

Hi,

Please try our latest version Aspose.Cells for .NET (Latest Version).

I have tested using your template file with the simplest code (given below), it works fine.

Sample code:

Workbook wb = new Workbook(@"e:\\test2\\testfile.xlsx");
wb.Save("e:\\test2\\out_testfile.pdf", SaveFormat.Pdf);

The output PDF file is attached.

Thank you.

3

Thanks for your quick support. Version 7.1.2 fixed the problem!


Best regards