I have a grid with a lot of columns.
4 Columns show "who and when" and the rest shows quantities.
So the idea is to freeze the first 4 columns and enable the others to scroll.
I tried this - but there are a lot of "strange things" going on - it's not usable.
I guess (not sure) these problems occur because the columns have a different width.
To see what I mean I prepared a video:
Normally each grid has some 100 rows - I reduced (and modified) the data because it is sensible.
If I set the width of the scrolling columns to equal values - two columns are missing :)
The first 4 columns have different size in this case...
I can compensate this by adding two "dummy columns".
If I set all columns to the same width - all columns are there - but the last one is "to small" (about half the width I set).
I can compensate this by setting the last column to a larger width.
But than the column is gone - again I have to add a dummy column.
To be more precise:
As you can see from my video the first column is about 130px the next is 70px and the next two are 60px.
This gives 320 pixels for the first four (the static one) columns.
My widest column has to be 135 pixels.
If I set all columns to the same width - this would mean that I need 540 pixels for the first 4 columns.
That's more than half of the space I have - 900 pixels.
In other words - setting all columns to the same width brings (visible at one time):
4 static + 2.5 scrolling columns.
With different column sizes I see 4 static plus 8 (!!) scrollable columns.
To see 8 out of 11 is ok - but 2.5 is more than useless.
a.) Am I right that for horizontal scrolling all columns must have the same width?
b.) if a.) is true - is there (a simple) way to fix this (workaround)?
- it must be really simple (the customer is used to scroll the whole grid - no frozen columns)
-----so frozen columns is more or less a "free addition" for the new version of the project
- it must be a solution that is flexible (number and needed width of the value columns changes).