mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-09-03 05:57:46 +00:00
oleibman
561308b307
The table attributes `border`, `cellspacing`, and `cellpadding` are used in Html Writer. They are deprecated in Html5 in favor of css attributes. Further, their use is redundant or outright wrong. Their use is eliminated. A sample is added to show how equivalents might be used.
59 lines
1.9 KiB
PHP
59 lines
1.9 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Writer\Html;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Reader\Html as HtmlReader;
|
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
|
use PhpOffice\PhpSpreadsheet\Writer\Html as HtmlWriter;
|
|
use PHPUnit\Framework\TestCase;
|
|
|
|
class PrintAreaTest extends TestCase
|
|
{
|
|
public function testPrintArea(): void
|
|
{
|
|
$spreadsheet = new Spreadsheet();
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
$inArray = [
|
|
[1, 2, 3, 4, 5],
|
|
[6, 7, 8, 9, 10],
|
|
[11, 12, 13, 14, 15],
|
|
[16, 17, 18, 19, 20],
|
|
[21, 22, 23, 24, 25],
|
|
[26, 27, 28, 29, 30],
|
|
];
|
|
$sheet->fromArray($inArray);
|
|
$sheet->getPageSetup()->setPrintArea('B2:D4');
|
|
$writer = new HtmlWriter($spreadsheet);
|
|
$eol = $writer->getLineEnding();
|
|
$html = $writer->generateHtmlAll();
|
|
self::assertStringContainsString(
|
|
"<table data-printarea='B2:D4' id='sheet0' class='sheet0 gridlines'>",
|
|
$html
|
|
);
|
|
$expectedArray = [
|
|
'@media print {',
|
|
' table.sheet0 tr.row0 td { display:none }',
|
|
' table.sheet0 tr.row4 td { display:none }',
|
|
' table.sheet0 tr.row5 td { display:none }',
|
|
' table.sheet0 td.column0 { display:none }',
|
|
' table.sheet0 td.column4 { display:none }',
|
|
'}',
|
|
];
|
|
$expectedString = implode($eol, $expectedArray);
|
|
self::assertStringContainsString(
|
|
$expectedString,
|
|
$html
|
|
);
|
|
$spreadsheet->disconnectWorksheets();
|
|
|
|
$reader = new HtmlReader();
|
|
$spreadsheet2 = $reader->loadFromString($html);
|
|
$sheet2 = $spreadsheet2->getActiveSheet();
|
|
self::assertSame('B2:D4', $sheet2->getPageSetup()->getPrintArea());
|
|
self::assertSame($inArray, $sheet2->toArray(null, false, false));
|
|
$spreadsheet2->disconnectWorksheets();
|
|
}
|
|
}
|