ExcelWorksheetView.FreezePanes ignoring hidden rows above or columns to the left of freeze point

[jtrent614]

When calling ExcelWorksheetView.FreezePanes(int Row, int Column), the Row and Column coordinates ignore hidden rows/columns and instead count only visible rows/cols.

Steps to reproduce:

• On an empty sheet, hide row 1 and column A
• Call Worksheet.View.FreezePanes(3, 3)
• Expected:
  • Pane frozen at cell C3
• Actual:
  • Pane frozen at cell D4

XML Examples

• Excel (expected):

  <sheetView tabSelected="1" topLeftCell="B2" workbookViewId="0">
      <pane xSplit="1" ySplit="1" topLeftCell="C3" activePane="bottomRight" state="frozen" />
      <selection activeCell="B2" sqref="B2" />
      <selection pane="topRight" activeCell="C2" sqref="C2" />
      <selection pane="bottomLeft" activeCell="B3" sqref="B3" />
      <selection pane="bottomRight" activeCell="B2" sqref="B2" />
  </sheetView>

• EPPlus (unexpected):

    <sheetView tabSelected="1" topLeftCell="B2" workbookViewId="0">
          <pane xSplit="2" ySplit="2" topLeftCell="D4" activePane="bottomRight" state="frozen" />
          <selection pane="topRight" activeCell="C1" sqref="C1" />
          <selection pane="bottomLeft" activeCell="A3" sqref="A3" />
          <selection pane="bottomRight" activeCell="B2" sqref="B2" />
    </sheetView>

  

[JanKallman]

We'll have a look at this.

[jtrent614]

Thanks Jan. I think this may be related to a similar problem I'm having, which is trying to set something like Worksheet.View.TopLeftCell = "B2" where it also has issues with hidden rows/columns. I'll test this a little more and document it.

[JanKallman]

Ok, I tried this...

        [TestMethod]
        public void FreezePanes()
        {
            using (var p = OpenPackage("Freeze.xlsx", true))
            {
                var ws = p.Workbook.Worksheets.Add("Sheet1");
                ws.Column(1).Hidden = true;
                ws.Row(1).Hidden = true;
                ws.View.FreezePanes(3, 3);
                SaveAndCleanup(p);
            }
        }

This seems to work as expected and freezes on C3

[jtrent614]

  // Test 1 (row 1/col A already hidden) - FAIL
  var ws = excelFile.Workbook.Worksheets["Sheet1"];
  ws.View.FreezePanes(3, 3);

  // Test 2 - FAIL
  var ws2 = excelFile.Workbook.Worksheets["Sheet2"];
  ws2.Column(1).Hidden = true;
  ws2.Row(1).Hidden = true;
  ws2.View.FreezePanes(3, 3);

  // Test 3 - PASS
  var ws3 = excelFile.Workbook.Worksheets.Add("Sheet3");
  ws3.Column(1).Hidden = true;
  ws3.Row(1).Hidden = true;
  ws3.View.FreezePanes(3, 3);

Looks like the issue is isolated to when when you have a pre-existing worksheet in the file instead of creating the worksheet first. Forgot to mention this is happening in 6.0.8 and 6.1.2.