Office can't open xlsx file

Topics: Developer Forum
Mar 31, 2011 at 8:49 AM
Edited Mar 31, 2011 at 8:53 AM

Hi, I tried to set styles using example below, but if I use Exel5 writer it ignores my changes. When I save file as xlsx, my Word shows me error "There is unreadable content in book CVT39a3.tmp .Do you want to restore this content" I translated error from russian so it can sounds strange. I tried to use other zip lib PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP) , but it didt'n help. Could you help me with this problem?

 

$objRichText = new PHPExcel_RichText();
$objRichText->createText('This invoice is ');

$objPayable = $objRichText->createTextRun('payable witsfsdfsf hin thirty days after the end of the month');
$objPayable->getFont()->setBold(true);
$objPayable->getFont()->setItalic(true);
$objPayable->getFont()->setColor( new PHPExcel_Style_Color( PHPExcel_Style_Color::COLOR_DARKGREEN ) );

$objRichText->createText(', unless specified otherwise on the invoice.');

$objPHPExcel->getActiveSheet()->getCell('A18')->setValue($objRichText);