Bootstrap Table Format Numbers With Comma And Decimal Places

by Greg Esguerra

HTML

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/3.2.0/css/bootstrap.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-table/1.18.0/bootstrap-table.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-table/1.18.0/bootstrap-table.min.js"></script>
<table id="tblDemo" 
  class="table-condensed table-striped">
	<thead>
		<tr>
			<th data-field="id">ID</th>
			<th data-field="name">Name</th>
			<th data-field="value" data-formatter="NumFormatter">Value</th>
		</tr>
	</thead>
</table>

JavaScript

$(function () {
    var $table = $('#tblDemo');
    var mydata = 
    [
        {
            "id": 0,
            "name": "test0",
            "value": "100.411"
        },
        {
            "id": 1,
            "name": "test1",
            "value": "12.47"
        },
        {
            "id": 2,
            "name": "test2",
            "value": "41.85"
        },
        {
            "id": 3,
            "name": "test3",
            "value": "31.14"
        },
        {
            "id": 4,
            "name": "test4",
            "value": "11453.20"
        },
        {
            "id": 5,
            "name": "test5",
            "value": "51.477"
        },
        {
            "id": 6,
            "name": "test6",
            "value": "70.71"
        },
        {
            "id": 7,
            "name": "test7",
            "value": "211.23"
        },
        {
            "id": 8,
            "name": "test8",
            "value": "32.21"
        },
        {
            "id": 9,
            "name": "test9",
            "value": "535.60"
        },
        {
            "id": 10,
            "name": "test10",
            "value": "4390.12"
        }
    ];

    $('#tblDemo').bootstrapTable({
        data: mydata
    });
});

function NumFormatter (data) {
	return parseFloat(data).toLocaleString(undefined, {
		minimumFractionDigits: 2,
		maximumFractionDigits: 2
	});
};