Controlling OWC Heading and Scrolling

[Henry Eakin]

I am an OWC user and have two different systems, on one system when I scroll
vertically I always see my report headings (like freeze frames in Excel) on
my other system I lose my report headings when I scroll. My question is how
do I control.

 

[Alvin Bruney [MVP]]

There is a freezepane setting you can set in the UI that controls this
behavior

--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley

 

[Pilaslux S.]

Dear Alvin Bruney [MVP],

Could you please explain more in detail about how to do this. I don't know
where to find freezepane setting?

Pilaslux S.

 

[Alvin Bruney [MVP]]

I couldn't understand why you were having problems with this, so I tried it.
Guess what? You are right. Freeze panes isn't available by default - at
least my version 11 on IE7 doesn't have it. The programmer needs to
explicitly set this in code for it be available to you the end-user.

System.Text.StringBuilder scripter = new System.Text.StringBuilder();



//it's safe to use document.all here since this can only run in IE

scripter.Append("\n<script language='javascript'>");

scripter.Append("\nif(document.all.sp != null){");

scripter.Append("\ndocument.all.sp.ActiveWindow.FreezePanes = true");

scripter.Append("\n}\n</script>");


--
Regards,
Alvin Bruney
------------------------------------------------------
Shameless author plug
Excel Services for .NET is coming...
OWC Black book on Amazon and
www.lulu.com/owc
Professional VSTO 2005 - Wrox/Wiley