Math in Datatable Cell

Webix JS
#1

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.

#2

Any suggestion?

#3

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

#4

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?

#5

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.

#6

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!

#7

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.