Management of decimals in jquery datatable

Navigation
0

How can I add decimals to the columns of my DataTable? For example, I want to show 0.00.

My code 

jQuery('#cuentas').DataTable( {
            data: datos.data,
            "columns": [
                { "data": "codProducto" },
                { "data": "codCuenta" },
                { "data": "nomProducto" },
                { "data": "valSaldo",},
                { "data": "valEfectivo" },
                { "data": "valCheques" },
                { "data": "valBloqueado" }
            ],
    
asked by Luis Garzon 26.07.2018 в 18:41
source

2 answers

2

You can use render to apply to columns 

{ "name": "valSaldo", render: $.fn.dataTable.render.number( ',', '.', 2) }
    
answered by 26.07.2018 / 19:24
source
1

You should use the lenguage

setting 
jQuery('#cuentas').DataTable( {
          "language": {
                      "decimal": ".",//separador decimales
                      "thousands": ","//Separador miles
            },
            data: datos.data,
            "columns": [
                { "data": "codProducto" },
                { "data": "codCuenta" },
                { "data": "nomProducto" },
                { "data": "valSaldo",},
                { "data": "valEfectivo" },
                { "data": "valCheques" },
                { "data": "valBloqueado" }
            ],
    
answered by 26.07.2018 в 18:46
Dynamically create 2 self-excluding check boxes for each row of a table Problems compiling a component in react.js