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

Free Support Forum - aspose.com

Convert Spreadsheet to PDF: Cell Showing #####

I am using the code below. The cell values on excel is displaying fine but the PDF is showing ##### for some of the field that’s in MMM-yy format in excel. What can I do with it?

Workbook workbook = new Workbook("workbook.xls");
workbook.save("AsposeConvert.pdf", SaveFormat.PDF);

@Lndsdev,
You may autofit columns in the worksheet that is to be converted to PDF. If all the worksheets are to be rendered to PDF, you may call this function for each worksheet.

Workbook workbook = new Workbook("input.xls");
foreach (var ws in workbook.Worksheets)
    ws.AutoFitColumns();
workbook.Save("output.pdf", SaveFormat.Pdf);

If your issue is not resolved with this code snippet, please share your sample Excel file and program output PDF for our reference.

Thanks. I don’t see issue so far after applying this.

@Lndsdev,
You are welcome.