Bug 55755

Summary: Only one SheetConditionalFormatting is found
Product: POI Reporter: Reinis <poi>
Component: XSSFAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal    
Priority: P2    
Version: 3.9-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: An Excel 2013 with three conditional formattings
Unittest to replicate the issue

Description Reinis 2013-11-07 13:40:20 UTC
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.
Comment 1 Reinis 2013-11-07 13:41:23 UTC
Created attachment 31025 [details]
Unittest to replicate the issue
Comment 2 Dominik Stadler 2014-01-01 22:58:44 UTC
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.
Comment 3 Dominik Stadler 2015-01-01 12:59:57 UTC
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...