I have implemented the REPLACE function for formula cells. I have also filled in the REPLACE "FORMULA" and "EXPECTED VALUE" rows of the file src/scratchpad/testcases/org/apache/poi/hssf/data/FormulaEvalTestData.xls with 17 test cases. All tests pass.
Created attachment 21283 [details] Generated using svn diff > FormulaReplaceFunction.patch This is a patch file, generated by running: svn diff > FormulaReplaceFunction.patch After I finished implementing the REPLACE function.
Created attachment 21284 [details] Contains the files I modified to implement and test the REPLACE function. Contains the files I modified to implement and test the REPLACE function. This tar file contains two files that I modified to implement and test the REPLACE formula function. The first file is: src/scratchpad/src/org/apache/poi/hssf/record/formula/functions/Replace.java This is where the REPLACE function is implemented. The second file is: src/scratchpad/testcases/org/apache/poi/hssf/data/FormulaEvalTestData.xls I modified two rows in this file (rows 1120 and 1121), the "FORMULA" and "EXPECTED VALUE" rows for the replace function. This row contains the test cases for replace. These tests run successfully and are run automatically when the ant task "test" is executed.
Thanks, applied