[OfficeUtils] Incompatible with January 2020 patch

Forge Component
Published on 17 Sep by Elena Novozhilova
28 votes
Published on 17 Sep by Elena Novozhilova


The Platform Server January 2020 patch will ship a new version of SharpZipLib (upgrade from 0.86 to 1.1), which is incompatible with NPOI 2.2 that is currently bundled with OfficeUtils.

For the component to continue working, NPOI will have to be upgraded to 2.4. You can read more about it here: https://github.com/icsharpcode/SharpZipLib/issues/270.

I've attached a new version of OfficeUtils that uses NPOI 2.4. However, there was a change in the NPOI API that breaks some of the behavior related to conditional formatting. Hence, I had to remove some code of the ProcessExcelOutput method in the XIF file.

Could you update the component before the release of the next patch? You need some help, don't hesitate to ask.