Math calculations
You can easily calculate values using math formulas. Also you are allowed to edit formulas on the fly by changing values in the quantity column:
Notice that this functionality can be used once you include codebase/ext/dhtmlxgrid_math.js file in the code of your grid.
</> Source
<!DOCTYPE html>
<!--pro-->
<html>
<head>
<title>Math calculations</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=edge"/>
<link rel="stylesheet" type="text/css" href="../../../codebase/fonts/font_roboto/roboto.css"/>
<link rel="stylesheet" type="text/css" href="../../../codebase/dhtmlx.css"/>
<script src="../../../codebase/dhtmlx.js"></script>
<script>
var myGrid;
function doOnLoad(){
myGrid = new dhtmlXGridObject('gridbox');
myGrid.setImagePath("../../../codebase/imgs/");
myGrid.setHeader("Book Title,Author,Price,Quantity,Total");
myGrid.setInitWidths("150,120,80,80,80");
myGrid.setColAlign("left,left,right,right,right");
myGrid.setColTypes("ed,ed,price,ed,ed[=c2*c3]");
myGrid.setColSorting("str,str,int,int,int");
myGrid.setMathRound(2);
myGrid.enableMathEditing(true);
myGrid.enableColumnMove(true);
myGrid.enableAutoWidth(true);
myGrid.enableAutoHeight(true);
myGrid.init();
myGrid.load("../common/grid_math.xml");
}
</script>
</head>
<body onload="doOnLoad()">
<h1>Math calculations</h1>
<p>
You can easily calculate values using math formulas. Also you are allowed to edit formulas on the fly
by changing values in the quantity column:</p>
<div id="gridbox" style="width:600px;height:450px;background-color:white;"></div>
<p>Notice that this functionality can be used once you include codebase/ext/dhtmlxgrid_math.js file in the code of your grid.</p>
</body>
</html>
Documentation
Check documentation to learn how to use the components and easily implement them in your applications.