search

PHPOffice / PHPExcel

ARCHIVED
Other
11.46k stars 4.2k forks source link

Excel Comment setStrikethrough,setBold doesnt work. #1284

Open ikool-cn opened 6 years ago

ikool-cn commented 6 years ago 
require_once dirname(__FILE__) . '/PHPExcel/Classes/PHPExcel/IOFactory.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '3')->setCellValue('A2', '5')->setCellValue('A3', '=SUM(A1:A2)');

$objPHPExcel->getActiveSheet()->getComment( 'B1')->setAuthor('PHPExcel' );
$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment('B1' )->getText()->createTextRun('PHPExcel:');
$objCommentRichText->getFont()->setBold( false)->setSize(9)->setItalic(false)->setStrikethrough(false);

$objPHPExcel->getActiveSheet()->getComment( 'B1')->getText()->createTextRun("\r\n" );
$objCommentRichText = $objPHPExcel->getActiveSheet()->getComment( 'B1')->getText()->createTextRun('Total amount on the current invoice, including VAT.' );
$objCommentRichText->getFont()->setBold( false)->setSize(16)->setItalic(false)->setStrikethrough(false);

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save(str_replace('.php', '.xlsx', __FILE__));

20170814134219