You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Rafael Ribeiro Rezende <ra...@gmail.com> on 2012/05/22 19:20:18 UTC

setFormula1 and setFormula2

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