Please report a bug at https://issues.apache.org/bugzilla/enter_bug.cgi?product=POI so we can investigate.
Please also provide information where the Excel file is coming from, i.e. manually created (which version of Excel) or created by some other tool? Thanks... Dominik. On Fri, Feb 7, 2014 at 4:36 PM, Andreas Reichel <[email protected]> wrote: > > 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="/home/are/.manticore/report/fxf_cbn/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. 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 > > > > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
