Hi,
I am trying to apply several kinds of formatting in my generated Excel 2007 document, using the latest version of PHPExcel, however I am having trouble to accomplish the following. If any of you could help me shed some light on these problems, I would be
very thankful!
a) Apply rounding
I am trying to make the following to work:
$sheet>setCellValue("F".$i, "=ROUNDUP(D".$i."*(E$".$i."+1);1)");
But this code throws a Formula Error Exception.
My question is, how do you ROUNDUP a cell?
b) I am trying to apply the percentage formatting to a cell with the value "25%", but I can't find that data type:
$sheet>getCell("E".$i)>setValueExplicit("25%", PHPExcel_Cell_DataType::TYPE_PERCENT);
How can you make sure that the cell appears as "25%" and not "0,25"?
Thanks for your all you answers.
Best
Per
