Formula evaluation

Formula evaluation provider

Currently the ReoGrid only provides a formula and script handler by using ReoScript, which is an ECMAScript-like language engine, only works with ECMAScript syntax, and that the VBA in Excel uses syntax of VisualBasic, that is only use ReoScript will not able to give same effect if compare to the Excel.

Provide the script handler which is fully same as VBA will be very difficult, even impossible job. But make a formula handler which does same things to the Excel is not impossible.

There is a plan to provide an interface, called formula evaluation provider, or formula handler, which allows to specify a provider into ReoGrid, to decide the formula will be handled by what types. Now ReoScript provides the ECMAScript expression evaluation it is available. Next thing to do is make a formula handler that is same as Excel available.

Last edited Jan 14, 2014 at 12:17 AM by unvell, version 1