Decimals in % input of a GridComponent

[Borja Albert Gramaje]

Hi I would like to be able to put decimals into a field of a GridComponent, specifically in a % input. This is the settings that I provided to the Grid Input:
<div>
<div> { label: ‘% Margen’, width: 100, dataField: ‘margentarifa’, allowEdit: true, editor: ‘numberInput’, cellsFormat: ‘p2’, cellsAlign: ‘right’ }</div>
</div>
<div></div>
<div>Thanks in advance.</div>
<div></div>
<div>Kind Regards.</div>
<div>
<div></div>
</div>

[Borja Albert Gramaje]

Don’t know why the <div> tags appear, sorry.

[admin]

Hi,

A built-in input in percentage is having that behavior, because the actual number is already a decimal. For example: the data value is 0.2 = 20%. In the Grid you will see and edit 20%, but when you get the value of the cell, it will be 0.2.

To achieve what you need, you can do the following:

  {
                    label: 'City2', dataType: 'number', cellsFormat: 'n2', editor: {
                        template: 'numberInput',
                        numberFormat: {
                            style: 'decimal',
                            minimumFractionDigits: 2
                        }
                    }, formatFunction(settings) {
                        settings.value = settings.value + '%';
                    }, dataField: 'City2', width: 120
                },

Best regards,
Peter Stoev

jQWidgets Team
https://www.jqwidgets.com/

[Borja Albert Gramaje]

Thank you so much!

[Author]

Posts