XLSX reader HTML writer does not support conditional formatting if using inline CSS

[ccchapman]

If you use the XLSX reader and HTML writer with the inline CSS option, conditional formatting color scale support is lost.

<?php

require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Writer\Html;

$spreadsheet = IOFactory::load('example.xlsx');

$writer = new Html($spreadsheet);
$writer->setConditionalFormatting(true);
$writer->setUseInlineCss(true);

echo 'With `setUseInlineCss(true);`';

echo $writer->generateSheetData();

$writer->setUseInlineCss(false);

echo 'With `setUseInlineCss(false);`';

echo $writer->generateSheetData();

Steps to reproduce:

1. Download the .zip attached here
2. Run php -S 0.0.0.0:8080

spreadsheet-test.zip

Related: #4412

[oleibman]

Code seems to write style attribute twice (different values) for inline, which is an error and leads to this problem. I will see what I can do.

[Shivam140902]

Hi, I’d like to work on this issue. Can I proceed?

[ccchapman]

@Shivam140902 The pull request to fix the issue is already open (#4541.)