delimiter A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string.
If a number is supplied, it will be treated as text.
ignore_empty If TRUE, ignores empty cells.
text1 Text item to be joined. A text string, or array of strings, such as a range of cells.
text2 ... Optional. Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1.
Each can be a text string, or array of strings, such as a range of cells.
| Modifier and Type | Field and Description |
|---|---|
| private ArgumentsEvaluator | |
| public static final FreeRefFunction |
| Access | Constructor and Description |
|---|---|
| private |
| Modifier and Type | Method and Description |
|---|---|
| public ValueEval | evaluate(ValueEval[]
the pre-evaluated arguments for this function. args is never args, OperationEvaluationContext null,
nor are any of its elements.primarily used to identify the source cell containing the formula being evaluated.
may also be used to dynamically create reference evals. ec)Implements org.
|
| private List | |
| private String |
| evaluator | back to summary |
|---|---|
| private ArgumentsEvaluator evaluator | |
| instance | back to summary |
|---|---|
| public static final FreeRefFunction instance | |
| TextJoinFunction | back to summary |
|---|---|
| private TextJoinFunction(ArgumentsEvaluator anEvaluator) | |
| evaluate | back to summary |
|---|---|
| public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) Implements org.
| |
| getValues | back to summary |
|---|---|
| private List | |
| laxValueToString | back to summary |
|---|---|
| private String laxValueToString(ValueEval eval) | |