I think that's an excellent idea. I did this:

  private void scrollTopLeft(XSSFSheet theSheet) {
    CTWorksheet ctWorksheet = theSheet.getCTWorksheet();
    CTSheetViews ctSheetViews = ctWorksheet.getSheetViews();
    CTSheetView ctSheetView =
ctSheetViews.getSheetViewArray(ctSheetViews.sizeOfSheetViewArray() - 1);
    ctSheetView.setTopLeftCell("A1");
  }

As you mentioned, some error handling should be added since the above could
theoretically throw NPE's. In my case, it doesn't. I'm also thinking that
there might be several sheet views (since there is an array) and perhaps
"setTopLeftCell" should be called for all of them...

/Bengt

2015-10-08 17:31 GMT+02:00 Mark Beardsley <[email protected]>:

> Thanks for letting me know and sorry again that it too so long. Might well
> propose this as an enhance,ent to the api - maybe setTopLeftCell(Sttring
> cellAddress).
>
>
>
> --
> View this message in context:
> http://apache-poi.1045710.n5.nabble.com/showInPane-does-not-work-tp5720321p5720524.html
> Sent from the POI - User mailing list archive at Nabble.com.
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
>

Reply via email to