Vertical alignment when generating pdf files always top

Topics: Developer Forum
Oct 9, 2012 at 8:30 PM
Edited Oct 9, 2012 at 9:35 PM

And at the same time Excel files layout is ok.

I test such code: 

$objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->getActiveSheet()->setCellValue('B1', 'Test');

$objPHPExcel->getActiveSheet()->getStyle('B1')->applyFromArray($styles['Header']);

$objPHPExcel->getActiveSheet()->getRowDimension('1')->setRowHeight(100);

$objPHPExcel->getActiveSheet()->getStyle('B1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_BOTTOM);

$objPHPExcel->getActiveSheet()->getStyle('A1:G20')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_BOTTOM);