Hello,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
I’m having trouble scrolling my worksheet to the top while having frozen panes. Here’s the code snippet I’m using:
Workbook wb = new Workbook();
Worksheet ws = wb.Worksheets;
ws.Cells.ImportDataTable(dt, false, "A5");
ws.ActiveCell = "A5";
ws.FirstVisibleColumn = 0;
ws.FirstVisibleRow = 0;
Anyway, it’s not quite working. Attached is the XLS file I get. Notice that rows 1-4 are frozen, but the sheet is scrolled to row 77. If I open this in Excel, and press Ctrl + Home, it goes to the top of the data "A5" like I want the code to do.
I’ve download and tried the latest DLL 5.1.3.