On Tue, 23 Sep 2014, Christian Castelli wrote:
FileInputStream file = new FileInputStream(new File(templateName));
Workbook workbook = format.equals("xls") ? new HSSFWorkbook(file) :
new XSSFWorkbook(file);
Use WorkbookFactory and a File (not inputstream) here, it'll be quicker
and lower memory!
Stacktrace:
org.apache.poi.ss.formula.FormulaParseException: Unused input [!#ref!]
after attempting to parse the formula [#ref!!#ref!]
This looks a pretty messed up formula... I think it might be one where
there was a reference to a named range in another sheet, where both the
sheet and the named range have been deleted
First up, can you try with 3.11 beta 2? There have been some formula fixes
recently that're in there. If that doesn't help, please open a bug in
bugzilla, and upload a small file that shows the issue. We might need a
special case for this kind of orphaned reference
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
