Freeze Pane Issue in Excel 2007

Question

While Freezing rows and column in Excel 2007, the freeze rows and columns are gettin repeated using C# code.

Using the following code:

Pane pane1 = new Pane() { HorizontalSplit = 0D, VerticalSplit = 1D, TopLeftCell = topLeftCell, ActivePane = PaneValues.BottomRight, State = PaneStateValues.Frozen };

In this case the first row is getting repeated.But while scrolling down the duplicate row is removed

Answer 1

Hi Kriinfra,

Thank you for posting.

What do you mean about " the freeze rows and columns are gettin repeated using C# code." ?

Can you show us the screenshot?

It will be better if you can share us the whole code snippet which can make us reproduce your problem more quickly.

Best Regards,

---

Bruce Song [MSFT]
MSDN Community Support | Feedback to us