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 <markbrd...@tiscali.co.uk>: > 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: user-unsubscr...@poi.apache.org > For additional commands, e-mail: user-h...@poi.apache.org > >