Menu
▾
▴
#4170 (ok 4.1.2) Overflow scroll for table grid is not a good solution
I understand the reason for horizonal scrolling of the table grid but if you have many columns and display 100 rows you can't scroll to the right.
you have to scroll the page down, scroll the table grid to the right , scroll the page up
Do you have a better solution? I'm not sure if we can implement a horizontal scroll control, located on top.
What do you think of this example?
http://jsfiddle.net/TBnqw/1/
the example makes no sense, because if you make ist 100 rows high you have the same problem in the middle.
my idea where:
make the table not bigger then the screen.
For height calc I would take $screenheight - $topbarHeight
so it fills the full screen but you still see the scrollbars.
Harald,
when you suggest "not bigger than the screen", do you mean horizontally or vertically?
both ;-)
Something like this: http://jsfiddle.net/yKtDw/
What would happen in your scenario, when the user asks for 100 rows? There would be an inner vertical scroller?
Hmm I had not seen your latest reply.
Last edit: Marc Delisle 2013-12-08
yes, I Updated the jsfiddle: http://jsfiddle.net/yKtDw/1/
What about having a floating horizontal scrollbar as in the demo here http://jsfiddle.net/cowboy/45rEs/show/ ?? I think we should also have fixed table header so that we can see the column name even when we have scrolled deep down.
I just wanted to report that no scrollbar is there. But now I have found them.
That was much better in the 4.0.x versions.
Why this change? Is it possible to undo this change again?
This is a very unpleasant thing with lots of data.
Example: I'm search for a data set an found it in the middle. Now I need the last col. I must go down, move to the right side and searching again... :) Not good...
What's wrong with the earlier version?
Thanks you!
Dennis1993,
this was wrong: https://sourceforge.net/p/phpmyadmin/bugs/4096/
That would be a quick solution (see screenshot):
< div style="position: relative;height: 600px; overflow: scroll;" class="data" >
it would be simple to add the height to the div so it fits in to the screen.
Its not perfect but better as the current state.
Last edit: Harald Leithner 2013-12-13
@Harald: Two vertical scrollbars? That's not good.
Quick and dirty and much better then the unusable version atm.
The complete jQuery and ajax part is useless in so many cases in my opinion and I still use 3.x because 4.x is extrem slow makes strange things. For ex. it gives me a useless error message that the token is expired, instead it should give me a login field. Whatever seams only to be my personal problem.
Adding multiple innovative scrollbars seems overreaching, I suggest keeping it simple and reverting to how it was before fixing bug#4096[1] and just fixing the problem with navigation-resizing that is mentioned there.
[1] https://sourceforge.net/p/phpmyadmin/bugs/4096
Atul,
fine by me; would you like to work on this?
One of our developers came to me with this complaint as well. I'm not adversely affected because I use a combination of arrow keys, shift-mousewheel, and mousewheel click (free-scrolling mode). If the scrollbars are going to remain this way, it would be nice if the column headings were sticky (since this method of scrolling would allow that).
Fixed with these commits on 4.1.1, please confirm.
https://github.com/phpmyadmin/phpmyadmin/commit/286d94d424afb1c25b487bb0563764a1487faaed
https://github.com/phpmyadmin/phpmyadmin/commit/4c1951a06ec8c2ef9d290c1de1387f04c11dc885
https://github.com/phpmyadmin/phpmyadmin/commit/33f8aa43ff79af2d64a12a92691b214bfac8fb2a
You can also use "Download zip" from
https://github.com/phpmyadmin/phpmyadmin/tree/QA_4_1
Last edit: Marc Delisle 2013-12-20
Justin,
Please open a feature request for sticky column headings, sounds like a useful feature, even with the reverted scrolling.
Now its better, with sticky columns it would be perfect.
thx
Last edit: Harald Leithner 2013-12-20