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