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.

VBA-Expressions v3.2.2

One piece!

Review

• Dead code removal.

Bug Fixed

• FZERO function. The order of the parameters of the base function prevented the correct behaviour of the function.
• Fixed not parsed expressions. Expressions were not correctly parsed when trying to use previous evaluation scopes.