public class Bin2Dec extends Fixed1ArgFunction implements FreeRefFunction
Syntax:
Bin2Dec (number)
Converts a binary number to decimal.
Number is the binary number you want to convert. Number cannot contain more than 10 characters (10 bits). The most significant bit of number is the sign bit. The remaining 9 bits are magnitude bits. Negative numbers are represented using two's-complement notation.
Remark If number is not a valid binary number, or if number contains more than 10 characters (10 bits), BIN2DEC returns the #NUM! error value.
(Excel Bin2Dec() 函数的实现。语法:Bin2Dec (number) 将二进制数转换为十进制数。 Number 是要转换的二进制数。数字不能超过 10 个字符(10 位)。数字的最高有效位是符号位。其余 9 位是幅度位。负数使用补码符号表示。备注 如果 number 不是一个有效的二进制数,或者如果 number 包含超过 10 个字符(10 位),BIN2DEC 返回 #NUM!错误值。)Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
instance |
Constructor and Description |
---|
Bin2Dec() |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
see
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
|
ValueEval |
evaluate(ValueEval[] args, OperationEvaluationContext ec) |
evaluate
public static final FreeRefFunction instance
public ValueEval evaluate(int srcRowIndex, int srcColumnIndex, ValueEval numberVE)
Function1Arg
Function.evaluate(ValueEval[], int, int)
(见 Function.evaluate(ValueEval[], int, int))
evaluate
in interface
Function1Arg
(在接口 Function1Arg 中评估)
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 错误)。)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.