Android Question How to Format column value in Flexgrid

[JhoeyBoy]

For Row = 0 To Quiry_ProfitDeficit.RowCount - 1
        Quiry_ProfitDeficit.Position = Row
        
        FlexGridProfitDeficit.AddRow(Array As Object(RowCounts - Row,Quiry_ProfitDeficit.GetString("TRANS DATE/TIME"), _
                    Quiry_ProfitDeficit.GetDouble("KILOS (D)"), _                               
                    Quiry_ProfitDeficit.GetDouble("PRICE (D)"), _
                    Quiry_ProfitDeficit.GetDouble("AMOUNT (D)"), _
                    Quiry_ProfitDeficit.GetDouble("KILOS (P)"), _                               
                    Quiry_ProfitDeficit.GetDouble("PRICE (P)"), _
                    Quiry_ProfitDeficit.GetDouble("AMOUNT (P)"), _
                    Quiry_ProfitDeficit.GetDouble("SOLD (KLS)"), _
                    Quiry_ProfitDeficit.GetDouble("DIFF"), _
                    Quiry_ProfitDeficit.GetDouble("PROFIT"), _
                    Quiry_ProfitDeficit.GetDouble("DEFICIT"), _
                    sf.AddSpaces(7) & Quiry_ProfitDeficit.GetString("BUYER"), _
                    sf.AddSpaces(5) & Quiry_ProfitDeficit.GetString("CONTROL"), _
                    Quiry_ProfitDeficit.GetString("TYPE")),True)
        
        FlexGridProfitDeficit.SetRowHeight((Row),60dip)       
        
    Next

Is there a simple way to format a value in the column of a FlexGrid, like in Column AMOUNT(D) 3268000.0 it should display 3,268,000.00.

 

[watesoft]

https://www.b4x.com/android/forum/t...lseparator-accroding-to-locale.78035/#content

 

[teddybear]

For Row = 0 To Quiry_ProfitDeficit.RowCount - 1
        Quiry_ProfitDeficit.Position = Row
       
        FlexGridProfitDeficit.AddRow(Array As Object(RowCounts - Row,Quiry_ProfitDeficit.GetString("TRANS DATE/TIME"), _
                    Quiry_ProfitDeficit.GetDouble("KILOS (D)"), _                              
                    Quiry_ProfitDeficit.GetDouble("PRICE (D)"), _
                    Quiry_ProfitDeficit.GetDouble("AMOUNT (D)"), _
                    Quiry_ProfitDeficit.GetDouble("KILOS (P)"), _                              
                    Quiry_ProfitDeficit.GetDouble("PRICE (P)"), _
                    Quiry_ProfitDeficit.GetDouble("AMOUNT (P)"), _
                    Quiry_ProfitDeficit.GetDouble("SOLD (KLS)"), _
                    Quiry_ProfitDeficit.GetDouble("DIFF"), _
                    Quiry_ProfitDeficit.GetDouble("PROFIT"), _
                    Quiry_ProfitDeficit.GetDouble("DEFICIT"), _
                    sf.AddSpaces(7) & Quiry_ProfitDeficit.GetString("BUYER"), _
                    sf.AddSpaces(5) & Quiry_ProfitDeficit.GetString("CONTROL"), _
                    Quiry_ProfitDeficit.GetString("TYPE")),True)
       
        FlexGridProfitDeficit.SetRowHeight((Row),60dip)      
       
    Next

Is there a simple way to format a value in the column of a FlexGrid, like in Column AMOUNT(D) 3268000.0 it should display 3,268,000.00.

NumberFormat(Quiry_ProfitDeficit.GetDouble("KILOS (D)"),0,2)