load($filename); $sheet = $spreadsheet->getActiveSheet(); self::assertSame(0, $sheet->getRowDimension(1)->getOutlineLevel()); self::assertSame(2, $sheet->getRowDimension(2)->getOutlineLevel()); self::assertFalse($sheet->getRowDimension(2)->getCollapsed()); self::assertTrue($sheet->getRowDimension(2)->getVisible()); self::assertSame('=SUBTOTAL(9,B2:B4)', $sheet->getCell('B5')->getValue()); self::assertSame(2, $sheet->getRowDimension(6)->getOutlineLevel()); self::assertFalse($sheet->getRowDimension(6)->getCollapsed()); self::assertFalse($sheet->getRowDimension(6)->getVisible()); self::assertSame(1, $sheet->getRowDimension(8)->getOutlineLevel()); self::assertTrue($sheet->getRowDimension(8)->getCollapsed()); self::assertTrue($sheet->getRowDimension(8)->getVisible()); $fake = new XlsxReader\ColumnAndRowAttributes($sheet, null); self::assertFalse($fake->load()); $writer = new XlsxWriter($spreadsheet); $writerWorksheet = new XlsxWriter\Worksheet($writer); $data = $writerWorksheet->writeWorksheet($sheet, []); self::assertStringContainsString('