Top Description Constructors Methods
org.apache.poi.ss.formula.functions

public final Class Substitute

extends Var3or4ArgFunction
Class Inheritance
Imports
org.apache.poi.ss.formula.eval.ErrorEval, .EvaluationException, .StringEval, .ValueEval
An implementation of the SUBSTITUTE function:

Substitutes text in a text string with new text, some number of times.

Constructor Summary

AccessConstructor and Description
public
Substitute()

Method Summary

Modifier and TypeMethod and Description
public ValueEval
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)

Implements org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

public ValueEval
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)

Implements org.apache.poi.ss.formula.functions.Function4Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

private static String
replaceAllOccurrences(String oldStr, String searchStr, String newStr)

private static String
replaceOneOccurrence(String oldStr, String searchStr, String newStr, int instanceNumber)

Inherited from org.apache.poi.ss.formula.functions.Var3or4ArgFunction:
evaluate

Constructor Detail

Substituteback to summary
public Substitute()

Method Detail

evaluateback to summary
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2)

Implements org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

Doc from org.apache.poi.ss.formula.functions.Function3Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

evaluateback to summary
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval arg0, ValueEval arg1, ValueEval arg2, ValueEval arg3)

Implements org.apache.poi.ss.formula.functions.Function4Arg.evaluate.

Doc from org.apache.poi.ss.formula.functions.Function4Arg.evaluate.

see Function#evaluate(ValueEval[], int, int)

replaceAllOccurrencesback to summary
private static String replaceAllOccurrences(String oldStr, String searchStr, String newStr)
replaceOneOccurrenceback to summary
private static String replaceOneOccurrence(String oldStr, String searchStr, String newStr, int instanceNumber)