We are generating Excel templates for our reporting customers. We would like the top-left cell of every tab to be selected and visible when the Excel template is opened.
I use the Cell.setAsActiveCell to select the cell and this works. I then use Shtt.showInPane(0, 0) to set the top row and the left column to 0. However this does not work. I've verified this both visually via Excel and by calling the Sheet.getTopRow() and the Sheet.getLeftCol() methods. I've read somewhere that there should also be setters for the top row and left column properties but I haven't seen them but I assume that the showInPanel() method is supposed to do that. I've tried this in POI versions 3.11, 3.12 and 3.13-beta1 but it doesn't work in any of them. Is this a known bug or have I misunderstood the functionality. Best regards, Bengt Rodehav
