How to paste a table in Confluence?

[Deleted user]

Version: Confluence 6.5.2

I am having an issue where I have a large data set where I would like to have a full page scrollable view with a locked header, similar to an excel sheet.  The issue I am having is, when I put a filter on the table, or lock one of the rows, it shortens my view to 2-3 entries.  I have tried expanding the filter box and havent had much luck with it. 

Any ideas?

Thanks!

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hello Alex,

Can you attach a screenshot of the issue?

[Deleted user]

Hi Andrey, thanks for your reply. What ends up happening after I put a filter view on my table, it then limits the number viewable.

i.e., I have 100 number of rows that I can scroll through normally on the page.  As soon as I put a filter on that table, I can now only see the first 5/100 rows inside a pre-sized box.  I can still scroll through all 100 entries however, I can only see 5 at a time or whatever fits inside my filter box

[Andrey Khaneev _StiltSoft_]

I guess you have Freeze first N rows option enabled, clear it to disable this feature.

[Deleted user]

Yeah, I have the freeze N rows selected because when I dont, the header row doest stick to the top of the page while scrolling.  Not sure what is going on

[Andrey Khaneev _StiltSoft_]

Confluence native feature called "table sticky header row" doesn't work if table header row contains merged cells.

[Deleted user]

That is most likely the cause then.  Appreciate your help on this, Andrey