Click here to Skip to main content
Click here to Skip to main content

Freeze Panes like Excel

, 1 Mar 2008 CPOL
Rate this:
Please Sign up or sign in to vote.
Freeze panes in an HTML table, cross browser using JavaScript.

Introduction

The script described in this article simply hides/unhides columns or rows using scrolling buttons, creating an Excel-like effect.

Background

There are already a few scripts around that demonstrate how to freeze an HTML table top row and first column.

Most of these scripts are specific to Internet Explorer, while a couple I have tried are cross browser compatible using CSS, but require the columns to be set to a specific width... for example, all column widths must be set to 100px wide.

I found this not to be ideal because the columns hide any content that is wider than 100px and there is no way of adjusting the column widths to view the hidden data via an onscreen control....not ideal for dynamically created data from a database.

Another solution I found was quite good but required a very large and complex amount of JavaScript code.

Using the code

The script simply hides/unhides columns or rows using scrolling buttons:

<button title="Up" onmousedown="upp();" onmouseup="upp(1);">Up</button>
<button title="Left" onmousedown="left();" 
        onmouseup="left(1);">&lt;&lt;</button>
<button title="Right" onmousedown="right();" 
        onmouseup="right(1);">&gt;&gt;</button>
<button title="Down" onmousedown="down();" onmouseup="down(1);">Dn</button>

Naturally, images can easily be used for a more attractive display.

Place the JavaScript function in either the head or body of your page. The function setUp() initializes the table the first time one of the buttons is clicked. Make sure to modify:

if(!myTable){myTable=document.getElementById("t1");

to match the ID of your table if it is not "t1". The script could be better optimised, but for demonstration, the code is easy enough to follow.

  var myRow=1;
  var myCol=1;
  var myTable;
  var noRows;
  var myCells,ID;
  
function setUp(){
    if(!myTable){myTable=document.getElementById("t1");}
     myCells = myTable.rows[0].cells.length;
    noRows=myTable.rows.length;

    for( var x = 0; x < myTable.rows[0].cells.length; x++ ) {
        colWdth=myTable.rows[0].cells[x].offsetWidth;
        myTable.rows[0].cells[x].setAttribute("width",colWdth-4);

    } 
}

function right(up){
    if(up){window.clearTimeout(ID);return;}
    if(!myTable){setUp();}

    if(myCol<(myCells)){
        for( var x = 0; x < noRows; x++ ) {
            myTable.rows[x].cells[myCol].style.display="";
        }
        if(myCol >1){myCol--;}

        ID = window.setTimeout('right()',100);
    }
}
  
function left(up){
    if(up){window.clearTimeout(ID);return;}
    if(!myTable){setUp();}

    if(myCol<(myCells-1)){
        for( var x = 0; x < noRows; x++ ) {
            myTable.rows[x].cells[myCol].style.display="none";
        }
        myCol++
        ID = window.setTimeout('left()',100);
        
    }
}
  
function down(up){
    if(up){window.clearTimeout(ID);return;}
    if(!myTable){setUp();}

    if(myRow<(noRows-1)){
            myTable.rows[myRow].style.display="none";
            myRow++    ;
        
            ID = window.setTimeout('down()',100);
    }    
}
 
function upp(up){
    if(up){window.clearTimeout(ID);return;}
    if(!myTable){setUp();}

    if(myRow<=noRows){
        myTable.rows[myRow].style.display="";
        if(myRow >1){myRow--;}
        ID = window.setTimeout('upp()',100);
    }    
}

See a working Freeze Pains Demo here.

Here is an updated version for better layout within a scrollable div, using custom horizontal and verticle scrollbars: demo.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Will66

Australia Australia
No Biography provided

Comments and Discussions

 
GeneralMy vote of 5 PinmemberMember 961177414-Feb-13 6:11 
QuestionTook your code and added some Jquery to it PinmemberMember 961177414-Feb-13 6:11 
AnswerRe: Took your code and added some Jquery to it PinmemberMember 1088420814-Jun-14 3:12 
GeneralMy vote of 5 PinmemberJonAtkins5720-Oct-12 10:31 
QuestionJavascript Pinmemberursatish20-Sep-12 19:17 
GeneralTable inside table problem Pinmemberchadok17-Jun-11 3:43 
Questionfreeze pane error PinmemberLim Tjie Siong, Indo10-Mar-11 0:12 
Generalcss help needed Pinmemberwebber1234563-Jan-11 8:38 
GeneralRe: css help needed PinmemberWill663-Jan-11 17:59 
GeneralRe: css help needed Pinmemberwebber1234569-Jan-11 10:45 
GeneralRe: css help needed PinmemberWill669-Jan-11 13:32 
GeneralRe: css help needed Pinmemberwebber12345610-Jan-11 11:11 
GeneralMy vote of 3 PinmemberNawaz M11-Oct-10 11:18 
Generalhorizontal scroll working only once pls help Pinmembersnigdha123412-Aug-10 1:24 
GeneralRe: horizontal scroll working only once pls help PinmemberWill6612-Aug-10 3:16 
GeneralRe: horizontal scroll working only once pls help Pinmembersnigdha123412-Aug-10 23:09 
GeneralProblem when cells are merged Pinmemberamit12121242-Aug-10 21:45 
GeneralRe: Problem when cells are merged Pinmemberlubos190221-Sep-11 19:29 
GeneralUpdated: now in custom scrollable div PinmemberWill661-Mar-08 3:57 
GeneralRe: Updated: now in custom scrollable div PinmemberMarc Leger1-Mar-08 9:52 
AnswerMultiple Table Solution PinmemberEric Carter28-Feb-08 11:23 
GeneralRe: Multiple Table Solution PinmemberWill661-Mar-08 3:20 
GeneralAnother option (using JQuery) Pinmemberrubensr22-Aug-07 16:33 
GeneralPrint large html table PinmemberElyons0321-Aug-07 15:11 
GeneralTry CSS Pinmembermeteorbites20-Aug-07 20:22 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web04 | 2.8.141022.2 | Last Updated 1 Mar 2008
Article Copyright 2007 by Will66
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid