outputFile !== '') {
unlink($this->outputFile);
$this->outputFile = '';
}
}
public function testIssue4200(): void
{
// ignoredErrors came after legacyDrawing
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->getCell('A1')->setValueExplicit('01', DataType::TYPE_STRING);
$sheet->getCell('A1')
->getIgnoredErrors()
->setNumberStoredAsText(true);
$richText = new RichText();
$richText->createText('hello');
$sheet->getComment('C1')
->setText($richText);
$writer = new XlsxWriter($spreadsheet);
$this->outputFile = File::temporaryFilename();
$writer->save($this->outputFile);
$spreadsheet->disconnectWorksheets();
$zip = new ZipArchive();
$open = $zip->open($this->outputFile, ZipArchive::RDONLY);
if ($open !== true) {
self::fail("zip open failed for {$this->outputFile}");
} else {
$contents = (string) $zip->getFromName('xl/worksheets/sheet1.xml');
self::assertStringContainsString(
'',
$contents
);
}
}
public function testIssue4145(): void
{
// ignoredErrors came after drawing
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->getCell('A1')->setValueExplicit('01', DataType::TYPE_STRING);
$sheet->getCell('A1')
->getIgnoredErrors()
->setNumberStoredAsText(true);
$drawing = new Drawing();
$drawing->setName('Blue Square');
$drawing->setPath('tests/data/Writer/XLSX/blue_square.png');
$drawing->setCoordinates('C1');
$drawing->setWorksheet($sheet);
$writer = new XlsxWriter($spreadsheet);
$this->outputFile = File::temporaryFilename();
$writer->save($this->outputFile);
$spreadsheet->disconnectWorksheets();
$zip = new ZipArchive();
$open = $zip->open($this->outputFile, ZipArchive::RDONLY);
if ($open !== true) {
self::fail("zip open failed for {$this->outputFile}");
} else {
$contents = (string) $zip->getFromName('xl/worksheets/sheet1.xml');
self::assertStringContainsString(
'',
$contents
);
}
}
}