Discussion:
setAsActiveCell problem
g3ro81
2011-03-09 16:31:50 UTC
Permalink
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.
Mark Beardsley
2011-03-10 16:59:39 UTC
Permalink
This really should be logged as a bug through Bugzilla here -
https://issues.apache.org/bugzilla/buglist.cgi?product=POI You will need to
set up an account for yourself before you can log a new bug.

Yours

Mark B

--
View this message in context: http://apache-poi.1045710.n5.nabble.com/setAsActiveCell-problem-tp3415859p3423667.html
Sent from the POI - User mailing list archive at Nabble.com.

Loading...