freezePanes dosen't work as expectation

[jtz]

I has a spreadsheet in IE,I need to freeze the first column and the first
row,so I use scripts as below
spreadsheet1.range("A1").select
spreadsheet1.ActiveWindow.FreezePanes=true
but it dosen't work as I expect,I found two bug
1 . it doesn't freeze at all at first,you has to press F5 to refresh the
page to make it freeze.
2 .it doesn't freeze the right column and the right row.I want the first
column and the first row to be frozen,but it freeze the 4th column and the
14th row .
what shall I do to get "freezePanes" work as I expect?

 

[jtz]

the first row was hidden,so the spreadsheet couldn't freeze the right row,but
why it will freeze the 4th row just for the first row is hidden?It doesn't
give a sense,and the first bug I can't find the reason by now
,confuseding.....