Conditional formatting that spans two sheets is read incorrectly

[jpaul3rdl]

test.xlsx

When this file is read and then written, the rules that reference only one sheet are lost.

I believe those rules are overwritten by the other rule here and I think it has to do with them having the same cell range.

https://github.com/PHPOffice/PhpSpreadsheet/blob/fb51c3d964f7e03b48ccf19bd2098109b137ba97/src/PhpSpreadsheet/Reader/Xlsx.php#L847

Also, the rule that references both sheets loses its font color and its 'stop if true' value.

PHP 8.2
PHPSpreadsheet 1.29

[oleibman]

Confirmed. For whatever reason, MS has 2 different ways of specifying conditional formatting, and this spreadsheet uses both. We handle both, but, as you conjectured, if they refer to the same range, we are not handling it correctly. I cannot say what will be needed to reconcile this situation. I will add it to my to-do list. Fair warning - if I am able to solve this, the fix will not be applied to the release of PhpSpreadsheet which you are using. You should upgrade.