public class Complex extends java.lang.Object implements FreeRefFunction
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 |
---|---|
static java.lang.String |
DEFAULT_SUFFIX |
static FreeRefFunction |
instance |
static java.lang.String |
SUPPORTED_SUFFIX |
Constructor and Description |
---|
Complex() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex) |
ValueEval |
evaluate(ValueEval[] args, OperationEvaluationContext ec) |
public static final FreeRefFunction instance
public static final java.lang.String DEFAULT_SUFFIX
public static final java.lang.String SUPPORTED_SUFFIX
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num)
Function2Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
evaluate
in interface
Function2Arg
(在接口 Function2Arg 中求值)
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval real_num, ValueEval i_num, ValueEval suffix)
Function3Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
evaluate
in interface
Function3Arg
(在接口 Function3Arg 中求值)
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec)
evaluate
in interface
FreeRefFunction
(在接口 FreeRefFunction 中求值)
args
- the pre-evaluated arguments for this function. args is never
null
, nor are any of its elements.
(args - 此函数的预评估参数。 args 永远不会为空,它的任何元素也不会。)
ec
- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
(ec - 主要用于识别包含正在评估的公式的源单元格。也可用于动态创建参考评估。)
null
. Possibly an instance of
ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
(从不为空。在指定 Excel 错误的情况下可能是 ErrorEval 的一个实例(从不抛出异常来表示 Excel 错误)。)
public final ValueEval evaluate(ValueEval[] args, int srcRowIndex, int srcColumnIndex)
evaluate
in interface
Function
(在接口函数中求值)
args
- the evaluated function arguments. Empty values are represented with
BlankEval
or
MissingArgEval
, never
null
.
(args - 评估的函数参数。空值用 BlankEval 或 MissingArgEval 表示,绝不为 null。)
srcRowIndex
- row index of the cell containing the formula under evaluation
(srcRowIndex - 包含计算公式的单元格的行索引)
srcColumnIndex
- column index of the cell containing the formula under evaluation
(srcColumnIndex - 包含正在评估的公式的单元格的列索引)
ErrorEval
, never
null
.
Note - Excel uses the error code
#NUM! instead of IEEE
NaN, so when numeric functions evaluate to
Double.NaN
be sure to translate the result to
ErrorEval.NUM_ERROR
.
(评估结果,可能是 ErrorEval,绝不为空。注意 - Excel 使用错误代码 #NUM!而不是 IEEE NaN,因此当数值函数计算为 Double.NaN 时,请务必将结果转换为 ErrorEval.NUM_ERROR。)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.