Android Question B4X Table Column Currency Format

Ryan Pigeon

Member
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.
 
Solution
B4X: 
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
Sort by date Sort by votes

teddybear

Well-Known Member
Licensed User
Which method are you using for numberformat? did you try B4XFormatter?
 
Upvote 0

Erel

B4X founder
Staff member
Licensed User
Longtime User
B4X: 
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
 
Upvote 0
Solution
You must log in or register to reply here.

Similar Threads

  • Article
Android Code Snippet Sqlite dataBase UpsizeTable
Replies
0
Views
216
Lello1964
  • Question
Android Question Formatting B4XTable column numbers. Works with B4J but not with B4A
Replies
2
Views
1K
Mahares
M
M
  • Question
Android Question Formatting column in B4XTable
Replies
2
Views
2K
Mario Krsnic
M
P
  • Question
Android Question who currency to normal
Replies
2
Views
1K
puang
P
M
  • Question
Android Question B4XTable Column AutoWidth and Scrollable Vertically and COLUMN_TYPE_DATE
Replies
5
Views
4K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…