https://issues.apache.org/bugzilla/show_bug.cgi?id=49258
Summary: Not existing external links cause crash
Product: POI
Version: 3.7-dev
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
I think, the code should rather check such references, being silent - in case
there are such unresolved references, ignoring them.
Anyway, no sense in such references in Excel 2003- old files and the workbook
may be processed without them.
The benefit would be - compatibility with the old code (jxl, for example) which
ignores them. Now we have backward incompatibility - after porting of the old
code to POI, getting exception in files which were processed without problems
with the old code.
------8<------
java.lang.Class - java.lang.RuntimeException: Could not resolve external
workbook name 'Documents and SettingsuserLocal SettingsTemporary Internet
FilesOLK91097209YE01.xls'. Workbook environment has not been set up.
at
org.apache.poi.ss.formula.OperationEvaluationContext.createExternSheetRefEvaluator(OperationEvaluationContext.java:84)
at
org.apache.poi.ss.formula.OperationEvaluationContext.getRef3DEval(OperationEvaluationContext.java:244)
at
org.apache.poi.ss.formula.WorkbookEvaluator.getEvalForPtg(WorkbookEvaluator.java:554)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateFormula(WorkbookEvaluator.java:440)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluateAny(WorkbookEvaluator.java:261)
at
org.apache.poi.ss.formula.WorkbookEvaluator.evaluate(WorkbookEvaluator.java:207)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluateFormulaCellValue(HSSFFormulaEvaluator.java:317)
at
org.apache.poi.hssf.usermodel.HSSFFormulaEvaluator.evaluate(HSSFFormulaEvaluator.java:179)
at
org.is.jxlpoi.JXLPOIWorkbook.getCellContentAsString(JXLPOIWorkbook.java:172)
------8<------
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
