Problem with new line

Topics: Developer Forum, Project Management Forum, User Forum
May 16, 2013 at 6:49 PM
hello,

i will make:
$objPHPExcel->getActiveSheet()->setCellValueByColumnAndRow(1, 1, "Text\nText");

but in Excelsheet is Textstyle: TextText.

Why is it? I use Excel 2007.

Thanks for your help.
Coordinator
May 16, 2013 at 7:29 PM
Set the cell alignment to wrap text:
$objPHPExcel->getActiveSheet()->getStyle('A1')
    ->getAlignment()
    ->setWrapText(TRUE);
See section 4.6.6 of the Developer Documentation