Using Freeze Panes with OWC11

[jvn]

Hi, I have a Pivot table component in my web page which queries against the
SQL Server cubes and gets the data.

Some of the queries have more than 10 columns. When user scrolls right
to see the data he loses visibility to the Row Headings. Is there a way we
could use Freeze Panes function of EXCEL in the Pivot component?.

Also, let me know if there is a work around.

I would appreciate any help in this regard.

Thanks

 

[Guest]

Hi,

I do this using the code bellow ( in portuguese ),

<img src="figuras/freeze.jpg" onClick="vbscript:call
Congela()" title="Congelar Painéis" name="figura"
style="cursor:hand">

<script language="VBScript">
Dim varCongela
varCongela = True

Sub Congela()
if varCongela = True then
pt.MaxWidth = 790
pt.MaxHeight = 410
varCongela = False
figura.title = "Descongelar Painéis"
else
pt.MaxWidth = 32000
pt.MaxHeight = 32000
varCongela = True
figura.title = "Congelar Painéis"
end if

pt.AutoFit = True
End Sub

 

[jvn]

Thank you very much, It works great.

Sorry for the delayed response I was not feeling well.

jvn