g3ro81
2011-03-09 16:31:50 UTC
hi,
i have some problem with the methos setAsActiveCell: it doesn't work.
I create the file with this code:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Sheet1");
for( int j = 0; j < 70; j++ ) {
HSSFRow titleRow = sheet.createRow(j);
for (int i = 1; i <= 7; i++) {
HSSFCell cell = titleRow.createCell(i);
cell.setCellValue(j + " - " + i);
if( (j == 5) && (i == 5) ) {
cell.setAsActiveCell();
}
}
}
String file = "test.xls";
FileOutputStream out = new FileOutputStream(file);
wb.write(out);
out.close();
...but when i open the file with MS Excel the selected cell is A1.
Thanks!
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/setAsActiveCell-problem-tp3415859p3415859.html
Sent from the POI - User mailing list archive at Nabble.com.
i have some problem with the methos setAsActiveCell: it doesn't work.
I create the file with this code:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Sheet1");
for( int j = 0; j < 70; j++ ) {
HSSFRow titleRow = sheet.createRow(j);
for (int i = 1; i <= 7; i++) {
HSSFCell cell = titleRow.createCell(i);
cell.setCellValue(j + " - " + i);
if( (j == 5) && (i == 5) ) {
cell.setAsActiveCell();
}
}
}
String file = "test.xls";
FileOutputStream out = new FileOutputStream(file);
wb.write(out);
out.close();
...but when i open the file with MS Excel the selected cell is A1.
Thanks!
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/setAsActiveCell-problem-tp3415859p3415859.html
Sent from the POI - User mailing list archive at Nabble.com.