Android Question B4X Table Column Currency Format

[Ryan Pigeon]

How do i enforce currency (2 decimal places) on a column called Retail in a B4XTable?

I have tried formatting it using numberformat when it shows the data but not working. If I change the column type to COLUMN_TYPE_TEXT then it format correctly but then i can't sort the column.

 

[teddybear]

How do i enforce currency (2 decimal places) on a column called Retail in a B4XTable?

I have tried formatting it using numberformat when it shows the data but not working. If I change the column type to COLUMN_TYPE_TEXT then it format correctly but then i can't sort the column.

Which method are you using for numberformat? did you try B4XFormatter?

 

[Erel]

Dim RetailColumn As B4XTableColumn = B4XTable1.AddColumn("Retail", B4XTable1.COLUMN_TYPE_NUMBERS)
Dim formatter As B4XFormatter
formatter.Initialize
formatter.GetDefaultFormat.MaximumFractions = 2
formatter.GetDefaultFormat.MinimumFractions = 2
RetailColumn.Formatter = formatter