Syntax:
COMPLEX (real_num,i_num,suffix )
Converts real and imaginary coefficients into a complex number of the form x + yi or x + yj.
All complex number functions accept "i" and "j" for suffix, but neither "I" nor "J". Using uppercase results in the #VALUE! error value. All functions that accept two or more complex numbers require that all suffixes match.
real_num The real coefficient of the complex number. If this argument is nonnumeric, this function returns the #VALUE! error value.
i_num The imaginary coefficient of the complex number. If this argument is nonnumeric, this function returns the #VALUE! error value.
suffix The suffix for the imaginary component of the complex number.
| Modifier and Type | Field and Description |
|---|---|
| public static final String | |
| public static final FreeRefFunction | |
| public static final String |
| Access | Constructor and Description |
|---|---|
| public |
| Modifier and Type | Method and Description |
|---|---|
| public ValueEval | evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num)
Implements org. |
| public ValueEval | evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix)
Implements org. |
| 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 boolean |
| DEFAULT_SUFFIX | back to summary |
|---|---|
| public static final String DEFAULT_SUFFIX | |
| instance | back to summary |
|---|---|
| public static final FreeRefFunction instance | |
| SUPPORTED_SUFFIX | back to summary |
|---|---|
| public static final String SUPPORTED_SUFFIX | |
| Complex | back to summary |
|---|---|
| public Complex() | |
| evaluate | back to summary |
|---|---|
| public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num) Implements org. Doc from org. see
| |
| evaluate | back to summary |
|---|---|
| public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix) Implements org. Doc from org. see
| |
| evaluate | back to summary |
|---|---|
| public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) Implements org.
| |
| isDoubleAnInt | back to summary |
|---|---|
| private boolean isDoubleAnInt(double number) | |