Owen Leibman 2024-04-25T19:31:48Z 16.00 6510 19200 32767 32767 False False TEST Vertical New Page Last 600 600 200 200 3 2 3 False False 3 2 EOT; public function testZoomAndPageBreaks(): void { $reader = new Xml(); $spreadsheet = $reader->loadSpreadsheetFromString(self::XML_DATA); self::assertEquals(1, $spreadsheet->getSheetCount()); $sheet = $spreadsheet->getActiveSheet(); self::assertEquals('Test', $sheet->getTitle()); self::assertSame(Border::BORDER_DOUBLE, $sheet->getStyle('B2')->getBorders()->getBottom()->getBorderStyle()); self::assertSame(Border::BORDER_MEDIUMDASHDOT, $sheet->getStyle('B2')->getBorders()->getRight()->getBorderStyle()); self::assertSame(Border::BORDER_DASHED, $sheet->getStyle('B2')->getBorders()->getTop()->getBorderStyle()); self::assertSame(Border::BORDER_HAIR, $sheet->getStyle('B2')->getBorders()->getLeft()->getBorderStyle()); self::assertSame(['A2'], array_keys($sheet->getRowBreaks())); self::assertSame(['D1'], array_keys($sheet->getColumnBreaks())); $sheetView = $sheet->getSheetView(); self::assertSame(200, $sheetView->getZoomScale()); self::assertSame(200, $sheetView->getZoomScaleNormal()); self::assertSame(100, $sheetView->getZoomScalePageLayoutView()); self::assertSame(200, $sheetView->getZoomScaleSheetLayoutView()); $spreadsheet->disconnectWorksheets(); } public function testXlsxWriterAndReader(): void { $reader = new Xml(); $spreadsheet = $reader->loadSpreadsheetFromString(self::XML_DATA); $reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xlsx'); $spreadsheet->disconnectWorksheets(); $rsheet = $reloadedSpreadsheet->getActiveSheet(); self::assertSame(['A2'], array_keys($rsheet->getRowBreaks())); self::assertSame(['D1'], array_keys($rsheet->getColumnBreaks())); $rsheetView = $rsheet->getSheetView(); self::assertSame(200, $rsheetView->getZoomScale()); self::assertSame(200, $rsheetView->getZoomScaleNormal()); self::assertSame(100, $rsheetView->getZoomScalePageLayoutView()); self::assertSame(200, $rsheetView->getZoomScaleSheetLayoutView()); $reloadedSpreadsheet->disconnectWorksheets(); } public function testXlsWriterAndReader(): void { $reader = new Xml(); $spreadsheet = $reader->loadSpreadsheetFromString(self::XML_DATA); $reloadedSpreadsheet = $this->writeAndReload($spreadsheet, 'Xls'); $spreadsheet->disconnectWorksheets(); $rsheet = $reloadedSpreadsheet->getActiveSheet(); self::assertSame(['A2'], array_keys($rsheet->getRowBreaks())); self::assertSame(['D1'], array_keys($rsheet->getColumnBreaks())); $rsheetView = $rsheet->getSheetView(); self::assertSame(200, $rsheetView->getZoomScale()); self::assertSame(200, $rsheetView->getZoomScaleNormal()); self::assertSame(100, $rsheetView->getZoomScalePageLayoutView()); self::assertSame(100, $rsheetView->getZoomScaleSheetLayoutView(), 'different value than Xml or Xlsx but I do not see any consequence of that'); $reloadedSpreadsheet->disconnectWorksheets(); } }