Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 9 of 9
  1. #1
    New Coder
    Join Date
    Jul 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel freeze pane effect in webbrowser

    Hey. First post here. Looking for some advice. Cheers.

    Any Guru web developers out there? I'm sure you know what I mean when I refer to the Excel freeze pane effect. It's not too complicated (I hope) as I only want to freeze the screen horizontally at a certain point.

    I could do this by creating two frames and displaying each, but it's a dynamically generated page and doing this will mean problems elsewhere. I can probably do it, but if there's another way I'd prefer to do it all in one document. I want to do something like below:

    <some text here>
    <table title bar....>
    ***freeze horizontally here***
    <table detail>

    Any ideas? Cheers.
    Last edited by Cringer; 07-07-2003 at 03:56 PM.

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    near Oswestry
    Posts
    4,508
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Not sure if it's exactly what you mean .. but it sounds like a table where the headers are frozen while the content can scroll ..?

    If so, there are a couple of solutions in this thread - one bulky and tag-soup, but it works x-browser, and one lightweight and semantically meaningful, but it only works in mozilla. Note the debate and take your pick
    "Why bother with accessibility? ... Because deep down you know that the web is attractive to people who aren't exactly like you." - Joe Clark

  • #3
    New Coder
    Join Date
    Jul 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'll take a look through that. Thanks for the quick reply!

  • #4
    New Coder
    Join Date
    Jul 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Bingo! Brothercake, you can have your cake and eat it... you are a star!! Now why is this not documented anywhere....?!

  • #5
    New Coder
    Join Date
    May 2003
    Location
    Toronto
    Posts
    59
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Another option that I used for a dynamic table using PHP was to have the table headers on the main page. Then for the body of the table I used an IFRAME which was fully scrollable. This way the headers never moved and the data in the table was easily modified.

  • #6
    New Coder
    Join Date
    Jul 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Yeah i tried that but it didn't like it.... THink I've cracked it though so thanks for the responses.

  • #7
    New Coder
    Join Date
    Jul 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Ok the way I've done this has a problem. It works wonderfully in IE 5.0. I've just found out though from some feedback that it doesn't work at all in IE6. I've used the following syntax around the scrolling table:

    <div style="width: 100%; height: 50%; overflow:auto"><table>...</table></div>

    Has anyone got any ideas why this doesn't work in IE6 and if so, how can I fix it? Cheers very much.


    EDIT: If you need more info to work out why it's not working, please let me know.
    Last edited by Cringer; 07-29-2003 at 10:59 AM.

  • #8
    New Coder
    Join Date
    Jul 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I've been fiddling around with a dummy file. It should be attached. This works fine in IE5. Doesn't work in Netscape 4.79. Can't test it on IE6 right now. Will do that in a moment. I've put it through HTML Tidy and it reports no errors....

    Any ideas?
    Attached Files Attached Files

  • #9
    New Coder
    Join Date
    Jul 2003
    Posts
    28
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Just ignore me..... lol the test file's working in IE6 now. Must mean there's a problem with my page somwhere that I can't find.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •