Releases: ws-garcia/VBA-Expressions
Releases · ws-garcia/VBA-Expressions
VBA-Expressions v0.0.7
Bugs fixed:
- Infinite loop when intercepting operators.
VBA-Expressions v0.0.6
- Bug fixed: unable to catch special cases when required to evaluate the like operator.
VBA-Expressions v0.0.5
- Improvement: LIKE operator ($) support. Now, expressions such as
Region $ 'C?????? *a'
can be evaluated successfully.
VBA-Expressions v0.0.4
- Improvement: ability to compare literal strings given in expressions.
VBA-Expressions v0.0.3
- Bug fixed: cannot get correct function name.
- Code update: removed redundant code.
VBA-Expressions v0.0.2
- Minor code and documentation improvements
VBA-Expressions v0.0.1
Advantages
- Easy to use and integrate.
- Basic math operators:
+
-
*
/
\
^
!
- Logical expressions:
& (AND)
| (OR)
|| (XOR)
- Binary relations:
< <= <> >= = >
- More than 20 built-in functions:
Max
,Min
,Avg
,Sin
,Ceil
,Floor
... - Very flexible: variables, constants and user-defined functions (UDFs) support.
- Implied multiplication for variables, constants and functions:
5avg(2;abs(-3-7tan(5));9)-12pi-e+(7/sin(30)-4!)*min(cos(30);cos(150))
is valid expression;5(2)
is not. - Evaluation of arrays of expressions given as text strings, as in Java: curly brackets must be used to define arrays
{{...};{...}}
- Floating point notation input support:
-5E-5
,(1.434E3+1000)*2/3.235E-5
are valid inputs. - Free of external VBA dependencies: does not use dll.