Hi,

I want to do math-calculations in Datatable cells.

For example 100*1.1 or 100+50.

Is that possible anyway?

Already set amth and editMath to true, but it doesn’t seem to be all of the settings to be done.

Hi,

I want to do math-calculations in Datatable cells.

For example 100*1.1 or 100+50.

Is that possible anyway?

Already set amth and editMath to true, but it doesn’t seem to be all of the settings to be done.

Any suggestion?

Hi,

Yes, Datatable supports basic math operations. The feature is described in the related article

Here’s also a quick sample: http://webix.com/snippet/d7cae952

Yes I know this article. But I want to click into an editable cell und then type in something like 100+200 or 200 * 1.5 .

But cant’t get it to work?

Do I need a operator like ‘=’ to et this to work?

Exactly. If you open editor on a cell with formula, you’ll see something like `=expression`

But unfortunately, we found a bug here (editor opens the formula only for the first time). Thank you for drawing attention to it.

No problem. I need this for my current project. It would be very nice from you, if you could post a code-snippet where I can calculate into a cell.

Thank you very much!

To edit formulas, you need to set three properties:

```
editable:true,
math:true,
editMath:true
```

and specify a `"text"`

editor for the column in question. Try to edit “Revenue” column (something like `=2+2’) in the following snippet

http://webix.com/snippet/2a4fae0c

But please note that because of the mentioned bug, `editMath`

won’t open a formula in the editor. Despite this issue, you can still type a formula, apply it and the calculation will work.