You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2013/11/07 14:40:20 UTC

[Bug 55755] New: Only one SheetConditionalFormatting is found

https://issues.apache.org/bugzilla/show_bug.cgi?id=55755

            Bug ID: 55755
           Summary: Only one SheetConditionalFormatting is found
           Product: POI
           Version: 3.9
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: XSSF
          Assignee: dev@poi.apache.org
          Reporter: poi@orbit-x.de

Created attachment 31024
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31024&action=edit
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 55755] Only one SheetConditionalFormatting is found

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55755

--- Comment #2 from Dominik Stadler <do...@gmx.at> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 55755] Only one SheetConditionalFormatting is found

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55755

Reinis <po...@orbit-x.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 OS|                            |All

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 55755] Only one SheetConditionalFormatting is found

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55755

--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
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...

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org

[Bug 55755] Only one SheetConditionalFormatting is found

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=55755

--- Comment #1 from Reinis <po...@orbit-x.de> ---
Created attachment 31025
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=31025&action=edit
Unittest to replicate the issue

-- 
You are receiving this mail because:
You are the assignee for the bug.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org