[SOLVED] Output to PDF going nuts...

Topics: User Forum
Jul 6, 2010 at 9:13 PM

I'm trying to output a built spreadsheet to PDF and some of my values are coming out screwed up.

For instance:

I have values that I use setCellValueExplicit to set the type as TYPE_STRING.

These values are:

1660004610707
5120006862046
5120006862046
5120010611349
5330012785284
5120015276963

In the PDF, they are coming out as:

EUR 5120006862046.00
EUR 5120006862046.00
EUR 5120010611349.00
EUR 5330012785284.00

And the last one isn't even printed!

I can output to Excel5/Excel2007 with the only problem being the error about the unreadable, but the data comes out perfectly.

My column widths are all screwed up in PDF output, too...

What the heck is going on around here???

Jul 6, 2010 at 9:37 PM

It is not only output to PDF that does this to the values, HTML output also does it.

I figured out what the problem was with getting the last one printed, though.

Any ideas?

Jul 6, 2010 at 9:43 PM

Able to get it to print correctly using

setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_GENERAL);