Summary description for MCParser.
Types of Cells
--------------
Value: A number.
Formula: A string that is an expression (see explanation of
expressions below).
General Information
-------------------
Columns range from A to FXSHRXW (2147483647 (int.MaxValue)),
and rows range from 1 to 2147483647.
Expressions
-----------
Cell names in formulas are typed in with the column followed by
the row:
A1+A2
B6^5
To compute the sum of a group of cells, put a colon between the
first cell and the last cell in the group:
A1:A10 - Sum all of cells from A1 to A10 and puts the
result in the current cell.
A1:C10 - Sum of all of cells from A1 to A10, B1 to B10,
and C1 to C10 and puts the result in the current
cell.
Available Constans
-------------------
PI (=3.1415...)
Available Functions
-------------------
Operators
+
-
*
/
^
(
)
Trigonometric.
sin - Sine.
sinh - Hyperbolic sine.
asin - Inverse sine.
asinh - Inverse hyperbolic sine.
cos - Cosine.
cosh - Hyperbolic cosine.
acos - Inverse cosine.
acosh - Inverse hyperbolic cosine.
tan - Tangent.
tanh - Hyperbolic tangent.
atan - Inverse tangent.
atanh - Inverse hyperbolic tangent.
cot - Cotangent.
DegToRad - Radians = Degrees * PI / 180
RadToDeg - Degrees = Radians * 180 / PI
Exponential.
exp - Exponential.
log - Natural logarithm.
log10 - Common (base 10) logarithm.
Pow10 - Base 10 power and scale floating point number.
sqrt - Square root.
sqr - Square x^2
Rounding and remainder.
abs - Absolute value.
fix - Round towards zero.
floor - Round towards minus infinity.
ceil - Round towards plus infinity.
round - Round towards nearest integer.
sign - Signum.
Examples:
FIX(A1)
SQRT(SQR(34.5))
ABS(FIX(B16))
For a list of all members of this type, see MCParser Members.
System.Object
MCParser
public class MCParser
Namespace: Laj.Mathematics Namespace
Assembly: Mathematics.dll