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

Free Support Forum - aspose.com

Some numbers come as zeros; other are not formatted

I use Aspose.Cells for .NET 5.0.0.0 to convert files from XLS to PDF. One of my files is messed when converted to PDF:

1. Many numbers that are non-zeros in the source XLS come as zeros in the PDF (examples: cells H7, H9, B17, B21).

2. All large numbers have thousands separator in the source XLS but not in the PDF (example: cell B9 is 4,544,439.70 in the XLS but 454439.7 in the PDF)

I have attached my Excel file here (1.xls). Here is my code:

static void Main(string[] args) {

Aspose.Cells.License license1 = new Aspose.Cells.License();
license1.SetLicense(“Aspose.Total.lic”);

string filePath = @“C:\Documents and Settings\ghochman\Desktop\excel\1.xls”;

Workbook wb = new Workbook();
wb.Open(filePath);

foreach (Worksheet ws in wb.Worksheets) {
ws.PageSetup.FitToPagesWide = 1;
ws.PageSetup.FitToPagesTall = 0;
}


string pdfPath = filePath.Replace(".xls", “.pdf”);
wb.Save(pdfPath);
}

I have re-tested this with 5.1.0.0 and it actually works, so the issue is closed.

Have a nice day :slight_smile: