getActiveSheet();
$sheet->getPageSetup()->setFitToWidth(1);
$sheet->getPageSetup()->setFitToHeight(0);
$sheet->getPageMargins()->setTop(0.2);
$sheet->getPageMargins()->setRight(0.2);
$sheet->getPageMargins()->setLeft(0.2);
$sheet->getPageMargins()->setBottom(0.5);
$sheet->getColumnDimension('A')->setWidth(20);
$sheet->getColumnDimension('B')->setWidth(20);
$sheet->getStyle('A1')->getFont()
->setSize(12)
->setItalic(true);
$sheet->getStyle('A1')->getAlignment()
->setWrapText(true);
$sheet->setCellValue('A1', "ABC\nDEF\nGHI");
$richText = new RichText();
$run1 = $richText->createTextRun("bold\n");
$run1->getFont()?->setBold(true);
$run3 = $richText->createTextRun('italic');
$run3->getFont()?->setItalic(true);
$sheet->getStyle('B1')->getAlignment()
->setVertical(Alignment::VERTICAL_CENTER)
->setWrapText(true);
$sheet->setCellValue('B1', $richText);
$writer = new HtmlWriter($spreadsheet);
$eol = $writer->getLineEnding();
$content = $writer->generateHtmlAll();
$expected1 = 'ABC
' . $eol . 'DEF
' . $eol . 'GHI | ';
self::assertStringContainsString($expected1, $content, 'br tags without newline in normal text');
$expected2 = 'bold
' . $eol . 'italic | ';
self::assertStringContainsString($expected2, $content, 'only one br tag, plus newline, in rich text');
$spreadsheet->disconnectWorksheets();
}
}