getActiveSheet(); $sheet->getDefaultRowDimension()->setRowHeight(20); $sheet->setCellValue('A1', 'hello there world 1'); $sheet->getStyle('A1')->getAlignment()->setWrapText(true); $sheet->getRowDimension(1)->setCustomFormat(true); $sheet->setCellValue('A2', 'hello there world 2'); $sheet->setCellValue('A4', 'hello there world 4'); $writer = new OdsWriter($spreadsheet); $writerWorksheet = new OdsWriter\Content($writer); $data = $writerWorksheet->write(); self::assertStringContainsString( '', $data ); self::assertStringContainsString( 'hello there world 1', $data ); self::assertStringContainsString( 'hello there world 2', $data ); self::assertStringContainsString( 'hello there world 4', $data ); $spreadsheet->disconnectWorksheets(); } }