Format value

[Benjamim Goulart Bessa]

Hi, 

I have a grid that have a cell that may contains two types of formats, based in lengtn of your value.

How can I correctly set my cell format?

The formats are: when value length is 14: 00.000.000/0000-00 and when is 11: 000.000.000-00.

[Pavithra Subramaniyam]

Hi Benjamim, 

 

Greetings from Syncfusion, 

 

You can achieve your requirement by using the column.valueAccessor property of Grid component. Please refer to the below code example, documentation link and sample link for more information. 

 

[component.ts] 

@Component({ 

    selector: 'control-content', 

    template: '  <ejs-grid [dataSource]='data' height='350'> 

        <e-columns> 

            <e-column field='OrderID' headerText='Order ID' [valueAccessor]='valueAccess' width='120' textAlign='Right'></e-column> 

             .   .   . 

        </e-columns> 

    </ejs-grid>' 

}) 

export class DefaultComponent implements OnInit { 

    public data: Object[] = []; 

      

    public valueAccess = (field: string, data: Object, column: Object) => {      

        return data[field].toString().length == 5 ? this.format("###0.##0#",data[field]):this.format("0000 %",data[field]); 

    } 

    ngOnInit(): void { 

        this.data = orderDetails; 

    } 

    format(format,value){ 

       let intl: Internationalization = new Internationalization(); 

       let nParser: Function =  intl.getNumberParser({ format:format}); 

       let val: string = intl.formatNumber(value,{format: format }) 

      return val; 

    }} 

 

Documentation : https://ej2.syncfusion.com/angular/documentation/grid/columns/#valueaccessor  

                               https://ej2.syncfusion.com/angular/documentation/common/internationalization/#manipulating-numbers  

 

Sample               : https://stackblitz.com/edit/angular-davotb-suinef?file=default.component.ts  

 

Please get back to us, if you need further assistance. 

 

Regards, 

Pavithra S.