Listbox: adjust column width manually mess up the column

Richard_And_Trisha

I have been working on the listbox and filling up the data from my sqlite file.
when I try to adjust the column width of say column 4, the column 5 will adjust itself but no the same width as before but very tiny column and only showing 2 characters.

say column 4 and 5 is originally "30%, 30%"... after adjusting, "20%, 1%" or "40%, 1%"

Garry

Thanks for reporting this. That is not expected behaviour: manually resizing column 4 should not cause column 5 to collapse to only a couple of characters.

This looks like a possible ListBox resizing bug, but I need a little more information to reproduce it reliably:

Which Objo Studio version and operating system are you using?
What is the complete ColumnWidths value for all columns before resizing?
Are 20%,1% and 40%,1% values returned by ColumnWidths, or estimates of what you see?
Does it happen on the first resize, or only after loading the SQLite rows or resizing the window?
Which column divider are you dragging, and in which direction?
If possible, could you attach a minimal project or a short screen recording?

It would also help to know whether the problem still occurs with the database code removed and just one manually added row. That will tell me whether SQLite is relevant or whether this is purely a five-column layout issue.

Richard_And_Trisha

Garry
I am using Objo Studio 26.8.3on Mac mini Apple M4 Pro with 48GB running on macOS Tahoe 26.6.1

Var v_sql As String
Var v_columnwidths As String
If property_StandardExtended = "Standard" Then
v_sql = """
SELECT RecordNumber, RecordNumber, Reference, 
Category, SubCategory, Ownership, PropertyName, Location, SubLocation,
Field1, Field2, Field3
FROM qryCollectionStandard 
[**WHERE**]
ORDER BY Reference
[**LIMIT**]
"""
v_columnwidths = "3x,5x,15x,15x,15x,15x,15x,15x,30x,30x,30x"
Else
v_sql = """
SELECT RecordNumber, RecordNumber, Reference,  
Field1, Field2, Field3, Field4, Field5, Field6,
Category, SubCategory, Ownership, PropertyName, Location, SubLocation
FROM qryCollectionExtended
[**WHERE**]
ORDER BY Reference
[**LIMIT**]
"""
v_columnwidths = "3x,5x,30x,30x,30x,30x,30x,30x,15x,15x,15x,15x,15x,15x"
End If

Var v_limit As String = ""
Var v_where As String = ""
Select Case p_type
Case "blank"
v_where = ""
v_limit = " LIMIT 0"
Case "find"
v_where = " WHERE StatusEN NOT IN ('Sold')"
v_limit = ""
Case "showall"
v_where = ""
v_limit = ""
End Select
v_sql = v_sql.Replace("[**WHERE**]", v_where)
v_sql = v_sql.Replace("[**LIMIT**]", v_limit)

I was using v_columnwidths = "3x,5x,30x,30x,30x,30x,30x,30x,15x,15x,15x,15x,15x,15x" and then before assigning to the listbox columnwidths, replace all with %

if adjust the column after filling just the column heading by assigning the sql with limit 0, it is the first time adjusting that I see the weird action.

once data has been loaded, everytime I adjust column, I also see the same weird action.

I adjust the divider between the field on the column heading on both left and right

will send you a video of what is happening

rgb

Richard_And_Trisha

Hi,
Total of your "3x,5x,30x,30x,30x,30x,30x,30x,15x,15x,15x,15x,15x,15x" = 288% !!

Try fit all columns in 100% elsewhere you have random value.

Richard_And_Trisha

I know... but I have lots of information to show...

I try without reading in the data and it is working ok

lstResult.FrozenColumnCount = 1
lstResult.SelectionMode = "Multiple"

lstResult.ColumnCount = 3
lstResult.SetHeaderText(0, "Name")
lstResult.SetHeaderText(1, "Age")
lstResult.SetHeaderText(2, "City")
lstResult.ColumnWidths = "33%,43%,60%"

lstResult.AddRow(["Alice", "30", "London"])
lstResult.AddRow(["Bob", "25", "Manchester"])
lstResult.AddRow(["Charlie", "35", "Edinburgh"])

Richard_And_Trisha

if I do the following, the problem only happen once

If property_StandardExtended = "Standard" Then
v_sql = """
SELECT RecordNumber, RecordNumber, Reference, 
Field1, Field2, Field3
FROM qryCollectionStandard 
[**WHERE**]
ORDER BY Reference
[**LIMIT**]
"""
v_columnwidths = "20x,20x,20x,20x,40x"
Else
v_sql = """
SELECT RecordNumber, RecordNumber, 
Field1, Field2, Field3, Field4
FROM qryCollectionExtended
[**WHERE**]
ORDER BY Reference
[**LIMIT**]
"""
v_columnwidths = "20x,20x,20x,20x,40x"
End If

but work perfectly ok if the v_columnwidths is "20x,20x,20x,20x,20x"

Richard_And_Trisha

I just saw the code portion is not indented although when I paste it the objo, It has all the indentation

[edit] oops sorry.. code I copy has the indentation, when I paste anywhere else, it remove the identation.

so must be my Mac OS clipboard problem

[edit] just found out MacOS Tahoe can only take unformatted text. so I need to install clipboard manager. what clipboard manager do you all used?

Richard_And_Trisha

when I use FrozenColumnCount on the listbox

manual data insert to listbox - PASSED
data from sqlite, 100% total column widths - FAILED
data from sqlite, more than 100% total column widths - FAILED

Richard_And_Trisha

[https://www.dropbox.com/scl/fi/f9kixphs2ob0ny8zyx1h2/Screen-Recording-2026-08-14-at-12.29.19.mov?rlkey=0zw67z8kpfhfp17n2rokvn3yv&dl=1](link to screen recording to show the problem)

as you can see from the recording, adjusting the column width using on the header show the next column become tiny column. also it show the frozen column does not work

Garry

Thanks for the detailed follow-up and screen recording. They helped identify two separate ListBox bugs, and both have now been fixed for the next Objo Studio release:

https://feedback.objo.dev/bug/1185
https://feedback.objo.dev/bug/1184

First, percentage column widths greater than 100% are valid and deliberately create a horizontally scrollable ListBox. Manually resizing one column in such a layout was incorrectly converting another percentage column into a fill (*) column. Because the layout was already wider than the ListBox, that fill column had no remaining space and collapsed to its minimum width. The resized column now keeps its new fixed width while the other percentage columns retain their declared widths.

Second, FrozenColumnCount could stop working when an already displayed ListBox had its columns rebuilt during dynamic data loading. The setting itself remained correct, but the replacement native columns were not marked as frozen. Frozen state is now reapplied whenever the columns are rebuilt. This covers both layouts totalling 100% and layouts greater than 100%. SQLite was not the cause—it simply exposed the column-rebuilding lifecycle.

One detail to remember: FrozenColumnCount counts every column from the left, including checkbox columns. If the first column is a checkbox and you also want the following reference/number column pinned, use:

lstResult.FrozenColumnCount = 2

Richard_And_Trisha

currently I put the lstResult.FrozenColumnCount = 2 at the end of data loading.
should it be done in front instead?

i did not set the FrozenColumnCount on the inspector. should I do instead??

Garry

Setting FrozenColumnCount = 2 after loading the data is the correct workaround in Objo Studio 26.8.3. You do not need to set it in the Inspector as well as both approaches set the same property.

In the next release, the fix means you can set it once after ColumnCount is configured, either in the Inspector or in code before loading the data, and it will remain applied when the columns are rebuilt. Since your columns are configured dynamically, keeping it in code is probably clearest.

Richard_And_Trisha

Just tested the frozen column and 0% column width perfectly!
THANKS