Bug 58149 - Support Office 2010 extensions to Conditional Formatting
Summary: Support Office 2010 extensions to Conditional Formatting
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.13-dev
Hardware: PC Linux
: P2 enhancement (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on: 56205 58130
  Show dependency tree
Reported: 2015-07-19 02:36 UTC by Nick Burch
Modified: 2016-06-15 10:04 UTC (History)
0 users


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