SharePoint QA
WHakos
Member
I have been tasked with putting together a central list in SharePoint combining together a number of different spreadsheets currently held in Excel. While there is a great deal we can do with views, I did get a request to see whether or not it is possible to freeze columns similar to the Excel Freeze Panes.
I see that there was some work done with the Gantt Chart in particular, can this sort of thing be applied to to a generic list as well?
I would recommend you either look at Excel Services (EWA web part) first (if you have Enterprise).
Next, you will need some scripting skills. To "freeze" a row in a SP list, you may want to create an empty div on the page that sits on top of your list. As you select rows to freeze, they are hidden and copied into the custom div.
Like with all things SP, that's not the hard part. Interacting with filters, sorts, and exploding groups will make you cry.
amitoni
Member
Paul,
Can I ask for a huge favor? I want take a shot of doing this for my custom list but need a little push from you.
Can you give the psuedo code on how to freeze it? I promise to share my work once I am done.
Aaron
You can look at what I did for the Gantt Chart Fix.
First, copy the element(s) making the row to a variable.
Then, remove the original row.
Then, insert the stored row as part of the "header".
This requires part of the web part to already be "sticky." So, in my case I added the element below the toolbar.
You have to pay special attention to the widths used and force the new sticky row to be at least as wide as the toolbar but have a fixed width. Changing browser width, loading in different screen resolutions, and testing with really long data are all important.
amitoni
Member
okay, have to admit - I need to sit in one of your jquery workshop to learn this. I read your work on gnatt and still struggling to understand what you did...syntax wise.
Would the logic be the same if we tried to freeze the column instead of rows
Freezing a column would be a lot more difficult simply because there is not already that "sticky" area. The toolbar stays at the top of the list but nothing stays to the left if you scroll right, you'd have to create that then put the column in it. Plus, that would totally break groups for sure.
You must log in to post.
