load($file);
$sheet = $spreadsheet->getActiveSheet();
$writer = new XlsxWriter($spreadsheet);
$writerWorksheet = new XlsxWriter\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
$expected = '';
self::assertStringContainsString($expected, $data);
$spreadsheet->disconnectWorksheets();
}
public function testWriteRowBreakInPrintAreaWithMax(): void
{
// This test specifies max for setBreak and appears correct.
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
for ($row = 1; $row < 60; ++$row) {
for ($column = 'A'; $column !== 'L'; StringHelper::stringIncrement($column)) {
$cell = $column . $row;
$sheet->getCell($cell)->setValue($cell);
}
}
$sheet->getPageSetup()->setPrintArea('B2:J55');
$sheet->setBreak('A25', Worksheet::BREAK_ROW, Worksheet::BREAK_ROW_MAX_COLUMN);
$writer = new XlsxWriter($spreadsheet);
$writerWorksheet = new XlsxWriter\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
$expected = '';
self::assertStringContainsString($expected, $data);
$spreadsheet->disconnectWorksheets();
}
public function testWriteRowBreakInPrintAreaWithoutMax(): void
{
// This test does not specify max for setBreak,
// and appears incorrect. Probable Excel bug.
// See issue #1275, which now has a fix.
// And I agree that the fix probably indicates an Excel bug.
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
for ($row = 1; $row < 60; ++$row) {
for ($column = 'A'; $column !== 'L'; StringHelper::stringIncrement($column)) {
$cell = $column . $row;
$sheet->getCell($cell)->setValue($cell);
}
}
$sheet->getPageSetup()->setPrintArea('B2:J55');
$sheet->setBreak('A25', Worksheet::BREAK_ROW);
$writer = new XlsxWriter($spreadsheet);
$writerWorksheet = new XlsxWriter\Worksheet($writer);
$data = $writerWorksheet->writeWorksheet($sheet, []);
$expected = '';
self::assertStringContainsString($expected, $data);
$spreadsheet->disconnectWorksheets();
}
}