Save as PDF loses custom style formatting

Aspose.Cells Product Family
1

I have applied custom formatting to some fields to make numbers appear as "in millions" using the following format:

#,##0.00,,

So the number 1,234,567,890 appears as 1,234.57.

The formatting works fine in Excel 2003 and 2007. When Aspose saves to Excel or CSV, the formatting also looks correct. However, when Aspose saves to PDF, the comma disappears. So it looks like 1234.57.

I also noticed that the commas are retained if I apply a currency symbol to the format string ($#,##0.00,,).

Anyone else run into this problem, and/or have a solution?

This message was posted using Aspose.Live 2 Forum
2

Hi,

Please try the attached latest version/fix v5.2.0.5. I have tested with it using your template file to convert to PDF, it works fine. Here is my sample code.

Workbook wb = new Workbook(“e:\test\test.xlsx”);
wb.Save(“e:\test\outtest.pdf”);


Thank you.

3

Thanks, version 5.2.0.5 does correct the issue. (We are currently using 4.9.1.3.) I will talk to our development team about migrating to the latest version.