Can't use more than 3 conditional formatting conditions anymore

Hello,

We have some worksheets that need to have 5 conditional formatting conditions. We used to get around the Excel 2003 limitation of 3 by creating a second FormatConditions object and a second CellArea, and applying it to the same range of cells with new conditions. Surprisingly, this worked well for us.

We have since upgraded to Aspose.Cells 2.4.0 and our workaround/hack no longer works. That’s fine, we’re not sure how 5 conditional formatting rules even operated in 2003. Since most/all of our customer base uses Excel 2007 now, we’d like to just get rid of the hack, as Excel 2007 no longer has the 3 conditions limit. However, when saving the workbook as an Excel 2007 document, I get this:

Could not create spreadsheet.: java.lang.IllegalArgumentException: One conditional formatting can only contain 3 conditions

Is it possible your team could remove this limit for 2007 documents in the next release?

Thanks
Sam

Hi Sam,

<!–[if gte mso 9]>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val="–"/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–><!–[if gte mso 10]>

/* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman","serif";}

<![endif]–><span style=“font-size: 11pt; font-family: “Arial”,“sans-serif”;”>We will provide you the supported version. For both Excel2003 and Excel2007 file format,
now we have supported to create more than 3 conditions for one conditional
formatting. You will find the supported version soon here.

Thank you.

Hi Samuel,

The 3-conditions limit for conditional formattings have been removed. Now you can add more than 3 conditions for one conditional formatting for XLS files as well. The generated XLS file will work in a way that if opened by excel2003, only 3 conditions take effect. If opened by excel2007, all conditions take effect.

Please use the updated version Aspose.CellsV2.4.0.5.zip attached.

Thanks,

The issues you have found earlier (filed as 20018) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by aspose.notifier.