GeomertyAdjustValueFormulaType Enumeration |
Enumerates the types of geometry adjustment value formulas used.
Namespace: Spire.Xls.Core.Spreadsheet.Shapes
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Members
| Member name | Value | Description | |
|---|---|---|---|
| MultiplyDivide | 0 | Multiply Divide Formula. Arguments: 3 (fmla="*/ x y z"). Usage: "*/ x y z" = ((x * y) / z). | |
| AddSubtract | 1 | Add Subtract Formula. Arguments: 3 (fmla="+- x y z"). Usage: "+- x y z" = ((x + y) - z). | |
| AddDivide | 2 | Add Divide Formula. Arguments: 3 (fmla="+/ x y z"). Usage: "+/ x y z" = ((x + y) / z). | |
| IfElse | 3 | If Else Formula. Arguments: 3 (fmla="?: x y z"). Usage: "?: x y z" = if (x > 0), then y, else z. | |
| AbsoluteValue | 4 |
Absolute Value Formula. Arguments: 1 (fmla="abs x").
Usage: "abs x" = if (x < 0), then (-1) * x, else x. |
|
| ArcTanFormula | 5 | ArcTan Formula. Arguments: 2 (fmla="at2 x y"). Usage: "at2 x y" = arctan(y / x). | |
| CosineArcTan | 6 | Cosine ArcTan Formula. Arguments: 3 (fmla="cat2 x y z"). Usage: "cat2 x y z" = (x * (cos(arctan(z / y)))). | |
| Cosine | 7 | Cosine Formula. Arguments: 2 (fmla="cos x y"). Usage: "cos x y" = (x * cos(y)). | |
| MaximumValue | 8 | Maximum Value Formula. Arguments: 2 (fmla="max x y"). Usage: "max x y" = if (x > y), then x, else y. | |
| MinimumValue | 9 | Minimum Value Formula. Arguments: 2 (fmla="min x y"). Usage: "min x y" = if (x < y), then x, else y. | |
| Modulo | 10 | Modulo Formula. Arguments: 3 (fmla="mod x y z"). Usage: "mod x y z" = sqrt(x^2 + y^2 + z^2). | |
| PinTo | 11 | Pin To Formula. Arguments: 3 (fmla="pin x y z"). Usage: "pin x y z" = if (y < x), then x, else if (y > z), then z, else y. | |
| SineArcTan | 12 | Sine ArcTan Formula. Arguments: 3 (fmla="sat2 x y z"). Usage: "sat2 x y z" = (x * sin(arctan(z / y))). | |
| Sine | 13 | Sine Formula. Arguments: 2 (fmla="sin x y"). Usage: "sin x y" = (x * sin(y)). | |
| SquareRoot | 14 | Square Root Formula. Arguments: 1 (fmla="sqrt x"). Usage: "sqrt x" = sqrt(x). | |
| Tangent | 15 | Tangent Formula. Arguments: 2 (fmla="tan x y"). Usage: "tan x y" = (x * tan(y)). | |
| LiteralValue | 16 | Literal Value Formula. Arguments: 1 (fmla="val x"). Usage: "val x" = x. |
See Also
