https://bz.apache.org/bugzilla/show_bug.cgi?id=61905

            Bug ID: 61905
           Summary: Sheet.setActiveCell() does nothing
           Product: POI
           Version: 3.17-FINAL
          Hardware: PC
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
          Assignee: [email protected]
          Reporter: [email protected]
  Target Milestone: ---

Created attachment 35612
  --> https://bz.apache.org/bugzilla/attachment.cgi?id=35612&action=edit
active cell is A1, instead of E11

The method setActiceCell seems to be not working on latest stable version. The
same method on XSSF is working as expected. 

Please find a minimal reproducer below:


    @Test
    public void xlsx() throws IOException {
        XSSFWorkbook wb = new XSSFWorkbook();
        XSSFSheet sheet = wb.createSheet("new sheet");
        sheet.setActiveCell(new CellAddress("E11"));
        wb.write(new FileOutputStream("c:/temp/yyy.xlsx"));
        wb.close();
    }

    @Test
    public void xls() throws IOException {
        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet("new sheet");
        sheet.setActiveCell(new CellAddress("E11"));
        wb.write(new FileOutputStream("c:/temp/yyy.xls"));
        wb.close();
    }

-- 
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to