Show Full Decimal Precision in IgxGrid Number Columns

Hi,

I am using igx Data grid Angular UI. For column with datatype ‘number’ how many decimal places can i display in igx-cell of igx grid. Is there any restriction to display the decimal places. If yes, where can i change?

Sample application: https://stackblitz.com/edit/angular-grid-decimal-places?file=src%2Fapp%2Fdata%2FnwindData.ts

Here, in Unit Price column you can see only 3 decimal places being dispalyed/rendered but when u edit the particular column it has more than 3 decimal places.

I want to display all the decimal places as it is and not to round off the same.

Its quite urgent. Need reply ASAP.

Hello Shobhana,

You can apply number formatting to cells using IgxColumnComponent's formatter function.
For example, you can display the decimal digits as it appears in the data by setting the formatter function in onColumnInit event as shown below.

component.html
———————-
    <igx-grid ….. (onColumnInit)="onColumnInit($event)">
…..
    </igx-grid>
———————-

component.ts
———————-
onColumnInit(column: IgxColumnComponent) {
 if(column.field =="UnitPrice")
 {
  column.formatter = (unitPrice => {
     return unitPrice;
  });
 }
}
———————-

You should also be able to restrict the number of digits to be displayed by formatting the return value using toFixed() method in the formatter function above.

Hello Mihoko,

Thank you for your reply. Is there any documentation i can refer to. I will try the same and get back to you in case of any questions.

Hello Shobhana,

This is the document for IgxColumnComponent's formatter property.

https://www.infragistics.com//angular-docs/typescript/latest/classes/igxcolumncomponent.html#formatter

Still not able to see all the decimal places. I have shared a sample. Can u please make changes and share the resolution so that i can know what wrong am i doing?

I have modified your sample in the link below.

stackblitz.com/…/angular-grid-decimal-places-d2unvd

Appreciate your fast reply. It worked!! Thank You Mihoko [emoticon:c4563cd7d5574777a71c318021cbbcc8]