Bug 55755 - Only one SheetConditionalFormatting is found
Summary: Only one SheetConditionalFormatting is found
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: XSSF (show other bugs)
Version: 3.9-FINAL
Hardware: PC All
: P2 normal with 1 vote (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-11-07 13:40 UTC by Reinis
Modified: 2015-01-01 12:59 UTC (History)
0 users



Attachments
An Excel 2013 with three conditional formattings (8.96 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2013-11-07 13:40 UTC, Reinis
Details
Unittest to replicate the issue (2.85 KB, text/plain)
2013-11-07 13:41 UTC, Reinis
Details

Note You need to log in before you can comment on or make changes to this bug.
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...