I was curious to know the process for simply freezing a specified set of rows at the top.
For example, we have a title section which takes up 7 rows, with each set of cells in a row merged to the number of columns. The variable colSpan would be the number of header columns in the spreadsheet.
worksheet.MergeCells(0, 0, 0, colSpan - 1); // first title segment
worksheet.MergeCells(1, 0, 1, colSpan - 1); // second title segment
...
I simply want to be able to freeze those top rows and be able to scroll both vertically and horizontally through the data below the frozen rows.
using (IWorksheetViewExporter worksheetView = worksheet.CreateWorksheetViewExporter())
{
worksheetView.SetFreezePanes(8, colSpan);
}
However, when I use the freeze panes method, you can scroll vertically through all the content, but the horizontal scrolling starts in the cell at the bottom right of the last title row. How can I achieve horizontal scrolling beginning at the first row and first cell of the rows below the title rows?
Thank you.