poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 49688] conditional formatting based on formula not (re-)calculated properly
Date Fri, 16 Sep 2011 14:53:29 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=49688

--- Comment #1 from ivano.diana@ext.bhuman.it 2011-09-16 14:53:29 UTC ---
I've been encountering a problem very similar to that described in here. When
setting conditional formatting in a sheet by means of POI, if I choose to set a
rule with a formula that contain a reference to a cell that is not present in
the range defined by "CellRangeAddress" object, the cells included in this
region (the CellRangeAddress object) will not update to the formatting
associated to the rule.
Better to post some code:
-------------------------------------------------------------------
SheetConditionalFormatting sheetCF = heet.getSheetConditionalFormatting();

        ConditionalFormattingRule rule1 = 
sheetCF.createConditionalFormattingRule("$A$15>75");

PatternFormatting fill1 = rule1.createPatternFormatting();
fill1.setFillBackgroundColor(IndexedColors.BLUE.index);
fill1.setFillPattern(PatternFormatting.SOLID_FOREGROUND);

CellRangeAddress[] regions = {CellRangeAddress.valueOf("A18:A20")};

sheetCF.addConditionalFormatting(regions, rule1);
-------------------------------------------------------------------

If I change the formula in "$A$18>75", that is if the cell involved in the
formula is included in the region defined by CellRangeAddress object, opening
the file with excel the cells are formatted correctly.

-- 
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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


Mime
View raw message