https://issues.apache.org/bugzilla/show_bug.cgi?id=49258
--- Comment #2 from Vasili <[email protected]> 2010-05-06 11:14:54 EDT --- (In reply to comment #1) > If you don't have the external files, you can't calculate the formulas > > So, either don't explicitly trigger the calculation of the formulas (use the > cached values instead), or get the files to hand before you trigger the > evaluation I understand the 1st. But we have no control on what users may leave (they may leave references). JXL code processes such 2003 spreadsheets, POI crashes, with the same approach. Isn't it easier - to put try/catch in POI code or to test File.exists(), treating the links as not existing? The problem that the references are resolved inside POI code and our code just evaluates formulas - when it is a formula, calling formulaEvaluator.evaluate()- when formula is found (so has no knowledge that it is a file/reference at all. And the path to the file is resolved inside POI). As I believe - the check File.exists or try/catch and compatibility with the old code (which is still in production) will be only beneficial. -- 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]
