PhpSpreadsheet/tests/PhpSpreadsheetTests/Writer/Html/GridlinesInlineTest.php

<?php

declare(strict_types=1);

namespace PhpOffice\PhpSpreadsheetTests\Writer\Html;

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Html as HtmlWriter;
use PHPUnit\Framework\TestCase;

class GridlinesInlineTest extends TestCase
{
    public function testGridlinesInline(): void
    {
        $spreadsheet = new Spreadsheet();
        $sheet1 = $spreadsheet->getActiveSheet();
        $sheet1->setShowGridlines(false);
        $sheet1->setPrintGridlines(false);
        $sheet1->fromArray([
            [11, 12, 13],
            [14, 15, 16],
        ]);
        $sheet2 = $spreadsheet->createSheet();
        $sheet2->setShowGridlines(false);
        $sheet2->setPrintGridlines(true);
        $sheet2->fromArray([
            [21, 22, 23],
            [24, 25, 26],
        ]);
        $sheet3 = $spreadsheet->createSheet();
        $sheet3->setShowGridlines(true);
        $sheet3->setPrintGridlines(false);
        $sheet3->fromArray([
            [31, 32, 33],
            [34, 35, 36],
        ]);
        $sheet4 = $spreadsheet->createSheet();
        $sheet4->setShowGridlines(true);
        $sheet4->setPrintGridlines(true);
        $sheet4->fromArray([
            [41, 42, 43],
            [44, 45, 46],
        ]);

        $writer = new HtmlWriter($spreadsheet);
        $writer->writeAllSheets();
        $writer->setUseInlineCss(true);
        $html = $writer->generateHtmlAll();
        self::assertStringContainsString(
            '<td style="vertical-align:bottom; color:#000000; font-family:\'Calibri\'; font-size:11pt; text-align:right; width:42pt">11</td>',
            $html,
            'neither gridlines nor gridlinesp'
        );
        self::assertStringContainsString(
            '<td class="gridlinesp" style="vertical-align:bottom; color:#000000; font-family:\'Calibri\'; font-size:11pt; text-align:right; width:42pt">21</td>',
            $html,
            'gridlinesp without gridlines'
        );
        self::assertStringContainsString(
            '<td class="gridlines" style="vertical-align:bottom; color:#000000; font-family:\'Calibri\'; font-size:11pt; text-align:right; width:42pt">31</td>',
            $html,
            'gridlines without gridlinesp'
        );
        self::assertStringContainsString(
            '<td class="gridlines gridlinesp" style="vertical-align:bottom; color:#000000; font-family:\'Calibri\'; font-size:11pt; text-align:right; width:42pt">41</td>',
            $html,
            'gridlines and gridlinesp'
        );
        $count = substr_count($html, 'page-break-before');
        self::assertSame(1, $count);

        $spreadsheet->disconnectWorksheets();
    }

    public function testGridlinesCss(): void
    {
        $spreadsheet = new Spreadsheet();
        $sheet1 = $spreadsheet->getActiveSheet();
        $sheet1->setShowGridlines(false);
        $sheet1->setPrintGridlines(false);
        $sheet1->fromArray([
            [11, 12, 13],
            [14, 15, 16],
        ]);
        $sheet2 = $spreadsheet->createSheet();
        $sheet2->setShowGridlines(false);
        $sheet2->setPrintGridlines(true);
        $sheet2->fromArray([
            [21, 22, 23],
            [24, 25, 26],
        ]);
        $sheet3 = $spreadsheet->createSheet();
        $sheet3->setShowGridlines(true);
        $sheet3->setPrintGridlines(false);
        $sheet3->fromArray([
            [31, 32, 33],
            [34, 35, 36],
        ]);
        $sheet4 = $spreadsheet->createSheet();
        $sheet4->setShowGridlines(true);
        $sheet4->setPrintGridlines(true);
        $sheet4->fromArray([
            [41, 42, 43],
            [44, 45, 46],
        ]);

        $writer = new HtmlWriter($spreadsheet);
        $writer->writeAllSheets();
        $writer->setUseInlineCss(false);
        $html = $writer->generateHtmlAll();
        self::assertStringContainsString(
            "<table id='sheet0' class='sheet0'>",
            $html,
            'neither gridlines nor gridlinesp 1'
        );
        self::assertStringContainsString(
            '<td class="column0 style0 n">11</td>',
            $html,
            'neither gridlines nor gridlinesp 2'
        );
        self::assertStringContainsString(
            "<table id='sheet1' class='sheet1 gridlinesp'>",
            $html,
            'gridlinesp without gridlines 1'
        );
        self::assertStringContainsString(
            '<td class="column0 style0 n">21</td>',
            $html,
            'gridlinesp without gridlines 2'
        );
        self::assertStringContainsString(
            "<table id='sheet2' class='sheet2 gridlines'>",
            $html,
            'gridlines without gridlinesp 1'
        );
        self::assertStringContainsString(
            '<td class="column0 style0 n">31</td>',
            $html,
            'gridlines without gridlinesp 2'
        );
        self::assertStringContainsString(
            "<table id='sheet3' class='sheet3 gridlines gridlinesp'>",
            $html,
            'gridlines and gridlinesp 2'
        );
        self::assertStringContainsString(
            '<td class="column0 style0 n">41</td>',
            $html,
            'gridlines and gridlinesp 2'
        );
        $count = substr_count($html, 'page-break-before');
        self::assertSame(1, $count);

        $spreadsheet->disconnectWorksheets();
    }
}