Negative matching of text in conditional formatting

[stollr]

This is:

- [ ] a bug report
- [x] a feature request
- [ ] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

I want some styling to be applied if a cell does NOT contain a specified string.

What is the current behavior?

Currently it is not supported.

What are the steps to reproduce?

<?php
use PhpOffice\PhpSpreadsheet\Style\Conditional;
use PhpOffice\PhpSpreadsheet\Style\Color;

require __DIR__ . '/vendor/autoload.php';

// Create new Spreadsheet object
$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();

$conditional = new Conditional();
$conditional->setConditionType(Conditional::CONDITION_CONTAINSTEXT); // == 'containsText'
$conditional->setOperatorType(Conditional::OPERATOR_NOTCONTAINS); // == 'notContains'
$conditional->setText('published');
$conditional->getStyle()->getFont()->getColor()->setARGB(Color::COLOR_RED);
$conditional->getStyle()->getFont()->setBold(true);

$sheet = $spreadsheet->getActiveSheet();
$cell = $sheet->getCellByColumnAndRow(1, 1);
$cell->setValue('open');
$cell->getStyle()->setConditionalStyles([$this->getConditionalColorForStatus()]);

Which versions of PhpSpreadsheet and PHP are affected?

All.

Explanation

In the above code example I want to style the text in red and bold if the cell does NOT contain the text "published". But this is not possible. At least if you generate an XSLX file.

The OOXML requires the conditional formatting for this case to be defined like this:

	<conditionalFormatting sqref="A1:A1">
		<cfRule type="notContainsText" dxfId="0" priority="3" operator="notContains" text="published">
			<formula>ISERROR(SEARCH("published",A1))</formula>
		</cfRule>
	</conditionalFormatting>

But there is no condition type available to get notContainsText. So this has to be added.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs.
If this is still an issue for you, please try to help by debugging it further and sharing your results.
Thank you for your contributions.

[oleibman]

Fixed by PR #2049 in May 2021.