RedNeath / ExcelFormulaCalculationEngine

A pure C library that works as an interface to compute Excel formulas, given a data context. It is a recreation of Excel's language calculation engine, with an extra level of abstraction to separate it from the sheet context; allowing lightweight integration within smaller systems.
MIT License
1 stars 0 forks source link

Formula pre-processor #3

Open RedNeath opened 5 months ago

RedNeath commented 5 months ago

The pre-processor will be called by the processor before to process each node. Its role will be to make sure the operator (a function or a standard operator) is coherent with all the involved operands (the data it will have to process). In case it's not, it will flag an error, such as a type incoherence (when trying to concatenate two numbers, or adding a string to another...), and the processor will throw it back to the user.

Calculation will not continue, and the memory allocated will be freed.

RedNeath commented 3 months ago

Here are a few tables showing how operators

Negation

Image

Percent

Image

Power

Image

Multiplication

Image

Division

Image

Addition

Image

Subtraction

Image

Concatenation

Image

Comparison

Image Image Image Image Image Image

RedNeath commented 3 months ago

Development phase finished, now in review & testing