poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From g3ro81 <gerol...@gmail.com>
Subject Re: ShowInPane with rows locked
Date Thu, 10 Mar 2011 11:53:00 GMT
this is an example:


		HSSFWorkbook wb = new  HSSFWorkbook();

		HSSFSheet sheet = wb.createSheet("Sheet1");

		for( int j = 0; j <= 70; j++ ) {
			HSSFRow titleRow = sheet.createRow(j);
			for (int i = 0; i <= 7; i++) {
				HSSFCell cell = titleRow.createCell(i);
				cell.setCellValue(j + " - " + i);
				if( (j == 10) && (i == 7) ) {
					cell.setAsActiveCell();
					sheet.createFreezePane(2, 8);
					sheet.showInPane((short)4, (short)0);
				}
			}
		}

		String file = "test.xls";
		FileOutputStream out = new FileOutputStream(file);
		wb.write(out);
		out.close();


the function ShowInPane is working on the top pane (with columns headers,
but i want that scrolls the bottom pane)

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/ShowInPane-with-rows-locked-tp3423129p3423172.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message