VBA-Expressions v3.3.0

Rocketed to the moon!

Functions changes

• MROUND: now rounds all elements from the list of arrays.
• FZERO: now allows multi-variate fucntion zeroing. NOT supported by LO BASIC.

Bug fixed

• Infinite loop for some non-typical expressions.

Updates

• Testing frame updated.
• The VarValue property now indetifies arrays inputs.
• Updated users manual.

New methods

• CopyToScope method: returns a new scope holding all the variables from the current scope.

New functions

• BISECTOR: returns an array with two points that defines the bisector of the segment or angle
• INCENTER: returns an array with the incenter's coordinates for the given triangle.
• INCIRCLE: returns an array with the coordinates for the center and the radius for circle inscribed in the given triangle.
• CIRCUMCIRCLE: returns an array with the coordinates for the center and the radius for circle circumscribed by given triangle.
• CIRCLETANG: returns an array with the coordinates for the center and the radius for circle circumscribed by given triangle.
• GETFROMLIST: returns an element from the given list.

VBA-Expressions v3.2.11

Embracing analytic geometry basis!

Setting changes

• The GallopingMode option is disabled by default.

Bug fixed

• Broken tokenization for expressions involving evaluable literal strings.

New functions

• DISTANCE: computes the distance between two Cartesian points.
• LINESINTERSECT: computes the intersection point between two lines defined by two points each.
• PARALLEL: computes two points representing a line parallel to the given one and containing the given point.
• PERPENDICULAR: computes two points representing a line perpendicular to the given one and containing the given point.

VBA-Expressions v3.2.10

A single one

New function

• INSTR

VBA-Expressions v3.2.9

Approaching scripts!

New features

• Support for double equality symbol (==): the library is able to evaluate comparisons using the double equality symbol, commonly used in modern scripting languages. With this addition, it is possible to evaluate expressions such as (a + b == c) & (a + b = c).

VBA-Expressions v3.2.8

Loving spreadsheet formulas!

New Functions

• Added Excel BETA.DIST function for the cumulative distribution function (CDF) and the probabilistic distribution function (PDF) of the Beta distribution.

VBA-Expressions v3.2.7

A note on!

Bug Fix

• Resolved error when parsing literal strings with reserved grammar tokens.

VBA-Expressions v3.2.6

Reaffirmation!

Bug Fix

• Resolved several collisions when analysing expressions with implicit functions and multiplications.

Changes

• Added update notifications the LO extension.

VBA-Expressions v3.2.5

Deflating the code!

Changes

• Unused code removal.
• Reimplementation of functions TINV, TINV_1T and TINV_2T.

VBA-Expressions v3.2.4

Wiping out the intruder!

Bug fixes

• Create method: solved collision with reserved token E.
• Create method: solved collision with grammar reserved tokens {}.

Rebranding

• New logo, all our heart in 4 symbols!

VBA-Expressions v3.2.3

Unleashing the beast!

Improvements

• Multi-expressions evaluation. Now users can provide a list of multiple expressions to be evaluated in a single pass. For example, "YEAR(NOW());ROUND(ERF(0.05);4);UCASE('This String');{-3*4;1-7;-10/5}" is a valid input.