mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-09-03 22:19:19 +00:00
oleibman
ffeaa42583
Xlsx conditional styles cannot be used to change alignment, nor font family, nor font size. Conditional::getStyle currently allocates a new style as an unconditional style; it is changed to do so a conditional ctyle. Border should not be conditionally merged if borderStyle is OMIT. Inline Css was generating `class="gridlines gridlinesp"` for all cells. It is changed to use the worksheet settings to decide which classes to use.
46 lines
2.0 KiB
PHP
46 lines
2.0 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
namespace PhpOffice\PhpSpreadsheetTests\Writer\Html;
|
|
|
|
use PhpOffice\PhpSpreadsheet\Spreadsheet;
|
|
use PhpOffice\PhpSpreadsheet\Style\Fill;
|
|
use PhpOffice\PhpSpreadsheet\Writer\Html;
|
|
use PHPUnit\Framework\TestCase;
|
|
|
|
class Issue3678Test extends TestCase
|
|
{
|
|
public function testInlineAndNot(): void
|
|
{
|
|
$spreadsheet = new Spreadsheet();
|
|
$sheet = $spreadsheet->getActiveSheet();
|
|
$sheet->setShowGridlines(false);
|
|
$sheet->setPrintGridlines(true);
|
|
$sheet->getCell('A1')->setValue(1);
|
|
$styleArray = [
|
|
'fill' => [
|
|
'fillType' => Fill::FILL_SOLID,
|
|
'color' => ['rgb' => 'FFFF00'],
|
|
],
|
|
];
|
|
$sheet->getStyle('A1')->applyFromArray($styleArray);
|
|
$style1 = "vertical-align:bottom; border-bottom:none #000000; border-top:none #000000; border-left:none #000000; border-right:none #000000; color:#000000; font-family:'Calibri'; font-size:11pt; background-color:#FFFF00";
|
|
$style2 = "vertical-align:bottom; color:#000000; font-family:'Calibri'; font-size:11pt; background-color:#FFFF00";
|
|
$style2 .= '; text-align:right; width:42pt';
|
|
$writer = new Html($spreadsheet);
|
|
$html = $writer->generateHtmlAll();
|
|
self::assertStringContainsString('td.style1, th.style1 { ' . $style1 . ' }', $html);
|
|
self::assertStringContainsString('<td class="column0 style1 n">1</td>', $html);
|
|
self::assertStringContainsString('table.sheet0 col.col0 { width:42pt }', $html);
|
|
self::assertStringContainsString('.n { text-align:right }', $html);
|
|
$writer->setUseInlineCss(true);
|
|
$html = $writer->generateHtmlAll();
|
|
self::assertStringContainsString('<td class="gridlinesp" style="' . $style2 . '">1</td>', $html);
|
|
$sheet->setPrintGridlines(false);
|
|
$html = $writer->generateHtmlAll();
|
|
self::assertStringContainsString('<td style="' . $style2 . '">1</td>', $html);
|
|
$spreadsheet->disconnectWorksheets();
|
|
}
|
|
}
|