https://issues.apache.org/bugzilla/show_bug.cgi?id=56123
Bug ID: 56123
Summary: ShiftRows, Bug in POI 3.10 Beta 2: "Could not find
'internal references' EXTERNALBOOK"
Product: POI
Version: 3.10-dev
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: HSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 31297
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31297&action=edit
CNB_01_all.xls reproduces the bug
Dear All,
the method shift rows always fails for me:
Exception in thread "main" java.lang.RuntimeException: Could not find
'internal references' EXTERNALBOOK
at
org.apache.poi.hssf.model.LinkTable.checkExternSheet(LinkTable.java:433)
at
org.apache.poi.hssf.model.InternalWorkbook.checkExternSheet(InternalWorkbook.java:1796)
at
org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows(HSSFSheet.java:1494)
at
org.apache.poi.hssf.usermodel.HSSFSheet.shiftRows(HSSFSheet.java:1343)
The code is extremely simple:
import java.io.*;
import org.apache.poi.hssf.usermodel.*;
/**
*
* @author are
*/
public class ExcelToolsBug {
public static void main(String[] args) throws FileNotFoundException,
IOException {
String fileName="CNB_01_all.xls";
int rowOffset = 11;
String sheetName = "MBR302";
File file = new File(fileName);
InputStream inputStream = new FileInputStream(file);
final HSSFWorkbook workbook = new HSSFWorkbook(inputStream);
HSSFSheet sheet = workbook.getSheet(sheetName);
for (int r = 0; r < 100; r++) {
sheet.shiftRows(rowOffset+1, sheet.getLastRowNum(), 1,
true, true);
}
}
}
I attached the Excel-File, which reproduces the problem. It was created with
LibreOffice Version: 4.1.4.2 Build ID: Gentoo official package. I also tried to
open/save that file with Excel and the same problem occurred afterwards.
Please can
anyone help me on that? I do not understand unfortunately the purpose
and the functionality of the method "checkExternSheet".
Thank you and best regards
Andreas
--
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]
