I was just looking at the documentation and wiki for FreezePanes and I couldn't figure out what the 3rd and 4th parameters do (freezedRows and freezedColumns). I finally figured out it was because I only needed to freeze the first row and first column. It seems there should be overloaded methods for the two available methods that allow you to leave off those two parameters.

It would be nice to be able to do this:

sheet.FreezePanes(1,1)

or this:

sheet.FreezePanes("B2")

If you don't want to hide any rows or columns, the last two parameters have no impact (as long as you don't set them both to 0 and generate an exception):

sheet.FreezePanes(1,1,1,1) is equivalent to sheet.FreezePanes(1,1,50,200) is equivalent to sheet.FreezePanes(1,1,2000,188), etc.

Hi,

Thanks for your suggestion.

Ok, we may analyze your suggestion and get back to you soon.

Thank you.

Hi,

The third and fourth param is not needed only when the start cell is "B2".

If you freeze panes from Row 3(one-based) or Column C, the third and fourth params are used to set how many visible rows and columns there are in the upper-left pane.So your suggested method is only for some special freeze cells.

If the third param is greater than the first param , we will use the first param to replace the third param.

If the fourth param is greater than the second param , we will use the second param to replace the fourth param.

Hi, Warren. Thanks for the reply. I think you may have missed my point. I've been using Excel since it first came out (and Lotus 1-2-3 before that, remember that one?), and it's incredibly rare that I've needed to hide rows and/or columns when freezing panes. I don't understand why the two independent functions are connected into one.

In Excel, if I want to freeze panes I just click in the top-left cell of the scrolling pane, C5 for instance, and choose freeze panes. That's the default behavior. I can then hide some rows or columns if I want, but I don't have to. What I would like is for your product to mimic that default behavior, so I could code sheet.FreezePanes("C5") instead of having to code sheet.FreezePanes("C5",4,2). The latter forces me to count how many rows and columns are above and to the left of cell C5. Granted, I could code sheet.FreezePanes("C5",9999,9999), but that's awfully sloppy.

Warren:

The third and fourth param is not needed only when the start cell is "B2".

I've looked at the overload list for the FreezePanes method and it doesn't look like the 3rd and 4th parameters are optional. Are you saying they are?

Hi,

Thanks for your details,

We will check your justifications and get back to you soon.

Thank you.