B4A Library [Class] Flexible Table

Sathish VM · Nov 29, 2013

klaus said:
I suppose that your device has a screen density of 0.75.
This would explain why you dont see the grid lines and the bmp.InitializeMutable(1dip, 1dip) error.
Attached you find a project with a new version of the Table class, it's a beta version for the next update.

Hi Klaus,

This works well and I'm now able to see gridlines, thank you so much. I've got another question now however.

In Table class, the SelectionSort method sorts as values as String, so in descending order 1 appears before 13 and 2 appears before 25 and so on. If I have all numbers in a column, can I make this function sort values as numbers.

I tried to modify your SelectionSort to convert strings to float. The result was that it appeared to work fine, till when I realized some values in the table go missing altogether after sort. I think this happens because when string gets converted to float, maybe it doesn't handle -5.1 etc so well?

Would you have any alternate solutions for me to sort as numbers?

B4X:

For i = 0 To Data.Size- 1     
            minIndex = i
            For j = i + 1 To Data.Size - 1         
                Dim values1() As String = Data.get(j)
                Dim f1 As Float = values1(col)
                Dim values2() As String = Data.get(minIndex)
                Dim f2 As Float = values2(col)
                If (dir) Then
                    If f1 <= f2 Then minIndex = j
                Else
                    If f1 > f2 Then minIndex = j
                End If
            Next
            SwapList(i, minIndex)
Next

klaus · Nov 29, 2013

I have never used the SelectionSort method, it was added by melamoud.
Where does your data come from ?
If it's from a database you'd better sort it in a SQL query, that's what I've done in my projects.

SandroB4A · Nov 29, 2013

Hi all, I launched your exmple table1_29.b4a but I got this error:

B4X:

Parsing code.                          0.24
Compiling code.                        Error
Error compiling program.
Error description: Unknown member: cellalignment
Occurred on line: 62
Table1.CellAlignment = Bit.OR(Gravity.LEFT, Gravity.CENTER_VERTICAL)
Word: cellalignment

When I open the project it warning that was made with an earlier version (I have 2.52) may be this the problem?

Sathish VM · Nov 30, 2013

klaus said:
I have never used the SelectionSort method, it was added by melamoud.
Where does your data come from ?
If it's from a database you'd better sort it in a SQL query, that's what I've done in my projects.

Yes, Data comes from database table. I have 5 columns and would like to sort on user selected column. If I'm using SQL to sort then I've requery on user column selection and reload the data to tableview, right?

klaus · Nov 30, 2013

If I'm using SQL to sort then I've requery on user column selection and reload the data to tableview, right?

Yes.
You should also modify in the table class the end of the Header_Click routine like below:

B4X:

If SubExists(Callback, Event & "_HeaderClick") Then
    CallSub2(Callback, Event & "_HeaderClick", col)
Else
    showHeaderSorting(col, dir)  
End If

And in the Main module add:

B4X:

Sub Table1_HeaderClick (Col As Int)
    ' your code
End Sub

Espinosa4 · Dec 1, 2013

Hi Klaus,

I have problems with some mobiles phones in this procedure into the table class.

B4X:

Public Sub Initialize (CallbackModule As Object, EventName As String, vNumberOfColumns As Int, cellAlignement As Int, showStatusL As Boolean)
    SV.Initialize(0, 0, "SV")
    internalPanel.Initialize("IP")
    showStatusLine = showStatusL
    SelectedRows.Initialize
    cAlignment = cellAlignement
'    SV.Panel.Color = cTableColor
    Callback = CallbackModule
    Event = EventName
    innerClearAll(vNumberOfColumns)
    sortingView.Initialize("")
  
    ' used for string width measuements in the LoadSQLiteDB routine
    bmp.InitializeMutable(1dip, 1dip)  
    cvs.Initialize2(bmp)
End Sub

some mobile phones show an error in table.initialize in this line
bmp.InitializeMutable(1dip, 1dip)

java.lang.IllegalArgumentException: width and height must be > 0

Can you help me, please?

Best regards

klaus · Dec 1, 2013

Set it to bmp.InitializeMutable(2dip, 2dip).
On devices with a scale of 0.75, 1dip = 0 which raises the error.
It is amended for the next release.

Espinosa4 · Dec 1, 2013

As ever thank you very much for your replies!

Cheers
Espinosa

lhbrito · Dec 2, 2013

klaus said:
I suppose that your device has a screen density of 0.75.
This would explain why you dont see the grid lines and the bmp.InitializeMutable(1dip, 1dip) error.
Attached you find a project with a new version of the Table class, it's a beta version for the next update.

Hello Klaus,

I made a change in version 1.30 beta to define a column as "autosize" to the table occupy the full width of the panel (parent).

The main changes were: Added SetAutoSizeCol method (default is none, -1), modified sub SetColumnsWidths and created two variables for internal use.

I modified the demo to show how it works and attached some screens.

If you find it useful you can use for the next version too.

Thanks!

klaus · Dec 2, 2013

Thank you.
I will have a look at it.

lhbrito · Dec 4, 2013

Hi,

I made a new mod.

In my application I have several hidden columns in a table and visually was getting bad. This occurs because hide columns leaves a small part of the visible column.

I verified that the method that hides a column, it changes the size to 1 and "SetColumnsWidths" method size that is visible is the result of "Max (2dip, Widths (col) - 1dip)". Therefore, the size of a hidden column will always be 2dip.

I decided to switch to use the visible property of each view (column). And is visually much better now. (HideCol will really make the column invisible)

With this change in the method unHideCol is no longer necessary to pass the new size, but kept for the purpose of compatibility. If the new size is 0 the column again have the same size it was before hidden.

Attached is the demo with all the changes I'm suggesting.

Thank you.

**** Edit ****
- Added property "Sortable" (boolean, default is True) to set the table is sortable when clicking on the header.
- Moved the update of variables "sortedCol" and "sortingDir" for ShowHeaderSorting () method: Correct the initial state of sorting the table. Example:

B4X:

Table1.LoadSQLiteDB ("select * from table order by 1")
Table1.ShowHeaderSorting (0, -1)

tufanv · Dec 11, 2013

I have a problem here.

I have initialized the table2 in a panel. And every time when clicked on load button, i have

table2.AddRow(Array As String(lbls1.text,lbls2.text,lbls3.text,lbls4.text,lbls5.text))

No problem until here. i can delete and add rows flawlessly

But when i have another table (table3) and initialized it , after i delete an item from the other table (table2) i cant see the changes ( sometimes the row is not deleted , sometimes the selected row is deleted but shows another row's input )

Need help

EDIT : fixed the issue , i was initializing the table 2 times, that was the problem.

enrico · Dec 12, 2013

klaus said:
Set it to bmp.InitializeMutable(2dip, 2dip).
On devices with a scale of 0.75, 1dip = 0 which raises the error.
It is amended for the next release.

But with 2dip I can't see the line separation between columns.

klaus · Dec 12, 2013

This line bmp.InitializeMutable(2dip, 2dip) has nothing to do with the column separarion.

Have you tried version 1.30 beta from post #120 ?

enrico · Dec 12, 2013

Sorry, I didn't see the update. I still have 1.29
Do you recommend using that beta or better wait for a stable version ?
The problem is that I have modified the class for my needs.
What's the part that solves the missing grid issue ?

klaus · Dec 12, 2013

The problem is only with devices with a scale or 0.75.

In the Public Sub SetColumnsWidths routine:

B4X:

Dim v As View
Dim w As Int
For col = 0 To Widths.Length - 1
    v = Header.GetView(col)
    w = Max(2dip, Widths(col) - cLineWidth)
    v.Width = w

And in Public Sub SetHeader(Values()

B4X:

w = Max(2dip, ColumnWidths(i) - cLineWidth)        ' needed to make sure that the width has value >0
Header.AddView(l, Left, 0, w, cRowHeight)

LucaMs · Dec 20, 2013

klaus said:
This thread will be used by Erel, Klaus and myself to discuss / post new releases of the Table class.

The table class is a flexible UI component that enable scrollable table like UI, with sortable columns, multiselect rows etc

the table is very efficient, maintaining labels only for visible rows

old thread with details : http://www.b4x.com/forum/additional...view-supports-tables-any-size.html#post110901

The class depend on StringUtils and Reflection libs and include two images for the column sorting indicators

List of major features
1. scrollable table UI
2. sortable columns
3. select a row, cell or multi select rows
4. callback for selection / click a cell / row
5. callback for long click action
6. read / write to CSV file

Current version --> 1.29

screenshot:

Is this a bug?
..."This thread will be used by Erel, Klaus and myself to discuss"...

Sorry, i need to joke

Erel · Dec 20, 2013

This thread was actually created by a different user (Melamoud). I changed the thread owner to allow Klaus to update the first post...

LucaMs · Dec 20, 2013

Erel said:
This thread was actually created by a different user (Melamoud). I changed the thread owner to allow Klaus to update the first post...

I was hoping to find just a

klaus · Dec 22, 2013

Text changed

!

B4A Library [Class] Flexible Table

Attachments

Member

Expert

Member

Member

Expert

Active Member

Expert

Active Member

Member

Attachments

Expert

Member

Attachments

Expert

Active Member

Expert

Active Member

Expert

Expert

B4X founder

Expert

Expert

Similar Threads