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

Free Support Forum - aspose.com

Error converting currency and euro sign

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

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.

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


Best regards