Created attachment 31024 [details] An Excel 2013 with three conditional formattings In the provided file only one SheetConditionalFormatting is found although there are actually three formattings in the file.
Created attachment 31025 [details] Unittest to replicate the issue
Two of the conditional formattings seem to be stored in the form of an "extension", which POI does not (yet) support. The sheet1.xml in the xlsx has: <conditionalFormatting sqref="G1"> ... </conditionalFormatting> ... <extLst> <ext uri="{78C0D931-6437-407d-A8EE-F0AAD7539E65}" xmlns:x14="http://schemas.microsoft.com/office/spreadsheetml/2009/9/main"> <x14:conditionalFormattings> <x14:conditionalFormatting xmlns:xm="http://schemas.microsoft.com/office/excel/2006/main"> ... </x14:conditionalFormatting> <x14:conditionalFormatting xmlns:xm="http://schemas.microsoft.com/office/excel/2006/main"> </x14:conditionalFormatting> </x14:conditionalFormattings> </ext> </extLst> See http://msdn.microsoft.com/en-us/library/dd905242%28v=office.12%29.aspx for the Extension-URL and http://msdn.microsoft.com/en-us/library/dd910565%28v=office.12%29.aspx for a description of the conditionalFormattings tag.
I tried to have a go at providing support for these extensions, but we do not (yet) have the schema "http://schemas.microsoft.com/office/spreadsheetml/2009/9/main" included in the Office-Schemas that we include in the XMLBeans generated code, so these parts of the XML are not immediately available in the type system of POI, therefore the first step here would be to add this additional schema...