Recent changes to 4985: Column headers move when scrolling

#4985 Column headers move when scrolling

2015-07-15T14:30:24.179000Z

I confirm this observation

#4985 Column headers move when scrolling

2015-07-15T13:31:46.021000Z

HI Marc,

give this a shot and let me know if it works (i am using firefox).

Dean

#4985 Column headers move when scrolling

2015-07-15T13:00:57.157000Z

Dean,
I only asked for an export containing the table's structure and sample fake data (where you duplicated the headers), no confidential data. This would help most.

#4985 Column headers move when scrolling

2015-07-15T12:10:45.640000Z

Hi Marc,

I am a little reticent to export the data as it is confidential customer data, however i have noticed that the problem seems to be evident in tables where there is no ability to perform INLINE edit, IE no primary or unique key exists in the table. To test this i have copied a table that does not exhibit this column shifting issue into another table, I tested the new table and it doesn't shift columns when i scroll, if i remove the primary and unique keys out of the new table and no longer have the ability to inline edit and start scrolling through the same table, the columns shift as shown in the attached images.

It looks like a calculation issue when no primary key / inline edit ability exists.

I have attached two images to show what i mean.

Does that help?

Dean

#4985 Column headers move when scrolling

2015-07-15T11:40:13.838000Z

Hi Dean,
Ok, I believed it was a case of incorrect repeated headers. Could you attach a small export of your table's structure and your sample data where you inserted the text of headers?

#4985 Column headers move when scrolling

2015-07-15T11:11:46.779000Z

Hi Marc,

The second row of "headers" is data, not headers, i put them in to show where the headers should be in relation to the data.

Dean

#4985 Column headers move when scrolling

2015-07-15T11:09:31.093000Z

I can reproduce by setting $cfg['RepeatCells'] = 10; but what I don't understand in your screenshot is that the second row of headers is not formatted the same way as the first row. When testing with Chrome, my second row of headers has all the headers in blue and they are clickable.

#4985 Column headers move when scrolling

2015-07-15T09:12:44.647000Z

The old BUG REPORT was in #4538

Column headers move when scrolling

2015-07-15T09:02:46.829000Z

Hi,

I reported this bug a long time ago and it got fixed but it seems to have come back again.

When you have a lot of results and start scrolling downwards through the results in PMA 4.4.11 the column headers shift out of position. I have included two images, one showing the columns in the right location BEFORE scrolling, another showing the positions after scrolling. The after position can cause an end user confusion if they don't realise the column headers have moved.

Please fix!