16.00 6820 19200 32767 32767 False False wide thin thin thin thin normal 3 1 False False EOT; $reader = new Xml(); $spreadsheet = $reader->loadSpreadsheetFromString($xmldata); self::assertEquals(1, $spreadsheet->getSheetCount()); $sheet = $spreadsheet->getActiveSheet(); self::assertSame('Tabelle1', $sheet->getTitle()); self::assertSame('A2', $sheet->getSelectedCells()); $widthMultiplier = 5.4; $expectedWidthBtoE = 25.5 / $widthMultiplier; self::assertEqualsWithDelta($expectedWidthBtoE, $sheet->getColumnDimension('B')->getWidth(), 1E-6, '1st col in span'); self::assertEqualsWithDelta($expectedWidthBtoE, $sheet->getColumnDimension('C')->getWidth(), 1E-6, '2nd col in span'); self::assertEqualsWithDelta($expectedWidthBtoE, $sheet->getColumnDimension('D')->getWidth(), 1E-6, '3rd col in span'); self::assertEqualsWithDelta($expectedWidthBtoE, $sheet->getColumnDimension('E')->getWidth(), 1E-6, '4th col in span'); $expectedWidthA = 76.5 / $widthMultiplier; self::assertEqualsWithDelta($expectedWidthA, $sheet->getColumnDimension('A')->getWidth(), 1E-6, 'width without span'); self::assertEqualsWithDelta(-1.0, $sheet->getColumnDimension('F')->getWidth(), 1E-6, 'default width'); $spreadsheet->disconnectWorksheets(); } }