getActiveSheet();
$rtf = new RichText();
$rtf->createText('~Cell Style~');
$rtf->createTextRun('~RTF Style~')->getFont()?->setItalic(true);
$rtf->createText('~No Style~');
$sheet->getCell('A1')->setValue($rtf);
$sheet->getStyle('A1')->getFont()->setBold(true);
$fontStyle = $sheet->getStyle('A1')->getFont();
self::assertTrue($fontStyle->getBold());
self::assertFalse($fontStyle->getItalic());
$a1Value = $sheet->getCell('A1')->getValue();
self::assertInstanceOf(RichText::class, $a1Value);
$elements = $a1Value->getRichTextElements();
self::assertCount(3, $elements);
self::assertNull($elements[0]->getFont());
$fontStyle = $elements[1]->getFont();
self::assertNotNull($fontStyle);
self::assertFalse($fontStyle->getBold());
self::assertTrue($fontStyle->getItalic());
self::assertNull($elements[0]->getFont());
$writer = new HtmlWriter($spreadsheet);
$html = $writer->generateHtmlAll();
self::assertStringContainsString('td.style1, th.style1 { vertical-align:bottom; border-bottom:none #000000; border-top:none #000000; border-left:none #000000; border-right:none #000000; font-weight:bold; color:#000000; font-family:\'Calibri\'; font-size:11pt }', $html, 'cell style');
self::assertStringContainsString('| ~Cell Style~', $html, 'cell style and first text element');
self::assertStringContainsString('~RTF Style~', $html, 'second text element');
self::assertStringContainsString('~No Style~ | ', $html, 'third text element');
$spreadsheet->disconnectWorksheets();
}
public function testNoFont(): void
{
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$rtf = new RichText();
$rtf->createTextRun('no font')->setFont(null);
$sheet->setCellValue('A1', $rtf);
$writer = new HtmlWriter($spreadsheet);
$html = $writer->generateHtmlAll();
self::assertStringContainsString('no font | ', $html);
$spreadsheet->disconnectWorksheets();
}
}