Formula support

[sudg6]

I'd like to perform arithmetic operations on columns storing the result in another column

[janisdd]

Yeah, I feel like this is more of an Excel thing...
I think this is out of scope.

[sudg6]

Yeah, I feel like this is more of an Excel thing... I think this is out of scope.

I suppose it's the only feature that's missing from this awesome extension!

[janisdd]

Well thanks.

In principle, the table library (handsontable) supports formulas... However, we are using an older version of Handsontable (because of the license) in which this is not supported.

Some additional thoughts:

• changing has header would invalidate all formulas because one row is added/removed
• when writing the csv back to file, should the formula be written or the result?
  • result: probably what one would expect but then loading the same csv would not longer contain the formula (problem because of auto reload)
  • formula: not useful when using the csv file afterwards because the result is not contained

[janisdd]

After giving it some more thought, I think that this is outside the scope of the plugin. Excel is probably better suited for this.