Bug 58149

Summary: Support Office 2010 extensions to Conditional Formatting
Product: POI Reporter: Nick Burch <apache>
Component: SS CommonAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: enhancement    
Priority: P2    
Version: 3.13-dev   
Target Milestone: ---   
Hardware: PC   
OS: Linux   
Bug Depends on: 56205, 58130    
Bug Blocks:    

Description Nick Burch 2015-07-19 02:36:05 UTC
This is an extension of #58130. Currently, we support the CF12 family of records for HSSF, and the conditionalFormatting / cfRule tags for XSSF. In Office 2010, additional extensions to Conditional Formatting were added, such as picking icons from different icon sets, and more advanced databars.

For HSSF these seem to be encoded in CFEX, for XSSF it's with the ext / x14:conditionalFormattings / http://schemas.microsoft.com/office/spreadsheetml/2009/9/main tags

This will likely need more low level support (records + aggregates for HSSF, low-level xml within the exts for XSSF), then updates to the high level interfaces to expose the additional options

The NewStyleConditionalFormattings.xls{x} files contain these new style CFs, which should help with the testing of this, for when someone has the time to implement it all.