Hi all, I need to open an Excel file and change the formula in some specific Conditional Formatting. For example, instead of Conditional Formatting makes usage of the $A$1 as reference, it should use $B$1.
The problem is: I have the getFormula1()<http://poi.apache.org/apidocs/org/apache/poi/hssf/usermodel/HSSFConditionalFormattingRule.html#getFormula1()>method, but no setFormula1(String formula1). I guess in this case I would need to create a new conditional formatting rule and replace the old one. But is there any special reason to do not have the *setFormula1(String formula1)* and *setFormula2(String formula2)*available? Thanks in advance, -- Rafael R Rezende
