https://issues.apache.org/bugzilla/show_bug.cgi?id=53729
Thies Wellpott <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Severity|normal |critical --- Comment #1 from Thies Wellpott <[email protected]> --- I can confirm this bug, also for HSSF in POI 3.8. Java source code I use for the test: private static void poiBugTest1() throws IOException { final String filename = "d:\\temp\\POI_Bug_Test.xls"; Workbook wb = new HSSFWorkbook(new FileInputStream(filename), true); System.out.println("WB geladen"); Sheet sh = wb.getSheet("Tab1"); sh.shiftRows(0, sh.getPhysicalNumberOfRows(), 1); OutputStream outStream = new FileOutputStream(filename); wb.write(outStream); outStream.close(); System.out.println("WB geschrieben"); } The used XLS file is added as attachment. After execution of the above code the reference in 'Second'!A1 has changed from "=Tab1!A$3" to "=Tab1!A$4". I changed the bug importance to "critical" because shiftRows() destroys working XLS sheets and this can be a silent destruction nobody recognises. -- 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]
