https://issues.apache.org/bugzilla/show_bug.cgi?id=47964
Summary: XSSFSheet.createFreezePane mix up of leftmostColumn
and topRow in call to CellReference
Product: POI
Version: 3.5-FINAL
Platform: PC
OS/Version: Windows Vista
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Noticed unusual display when freezing sheet at cell "B3" :
public void createFreezePane(int colSplit, int rowSplit, int
leftmostColumn, int topRow) {
CTPane pane = getPane();
if (colSplit > 0) pane.setXSplit(colSplit);
if (rowSplit > 0) pane.setYSplit(rowSplit);
pane.setState(STPaneState.FROZEN);
if (rowSplit == 0) {
pane.setTopLeftCell(new CellReference(0, topRow).formatAsString());
pane.setActivePane(STPane.TOP_RIGHT);
} else if (colSplit == 0) {
pane.setTopLeftCell(new CellReference(rowSplit,
0).formatAsString());
pane.setActivePane(STPane.BOTTOM_LEFT);
} else {
pane.setTopLeftCell(new CellReference(leftmostColumn,
topRow).formatAsString());
pane.setActivePane(STPane.BOTTOM_RIGHT);
}
CTSheetView ctView = getDefaultSheetView();
ctView.setSelectionArray(null);
CTSelection sel = ctView.addNewSelection();
sel.setPane(pane.getActivePane());
}
the final else has:
pane.setTopLeftCell(new CellReference(leftmostColumn,
topRow).formatAsString());
but CellReference expects (row, column).
FWIW:
if (rowSplit == 0) {
pane.setTopLeftCell(new CellReference(0, topRow).formatAsString());
also looks like an error.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
