The user should be able to resize a column, with the required width for this being added to or subtracted from the rightmost column. Other columns’ widths should not be affected. At the moment, resizing a column steals from or adds to the width of the next column to the right, which is not ideal as the user didn’t ask for that.
Resizing the listbox (done in software) should increase or decrease the width of the rightmost column, and leave other column widths alone. At the moment, all columns increase or decrease in size proportionately.
Well this is interesting. If I use Eli’s as-is, it fails (1) in my OP but succeeds with (2). If I use “2000” instead of “*”, then both (1) and (2) are satisfied. Of course, that’s a bit of a bodge as the listbox then extends into next-door’s garden, but I don’t expect to ever have a screen that wide.
And yes, I can use ColumnWidths and just use “27, 27, 213, 134, 47, 0, 2000”, that works as well.