Hello Steve,
Contributions are always welcome. Check out this page for more
details on how to submit patches:
http://poi.apache.org/getinvolved/index.html
Don't forget unit tests for any functionality you are adding/changing.
Regarding cached values of external cell references, I believe they
are stored in CRNRecords. These records are managed in the LinkTable
and POI currently only supports serialization/deserialization.
Presumably there is a way to navigate from the NameXPtg to the
corresponding CRNRecord but it wasn't immediately obvious to me. I'm
not sure if there is any good documentation on how this should work.
You might have to experiment with BiffViewer on sample files to find
out.
By the way, if all you are concerned about is evaluating
multi-workbook formulas you can do it with the help of this method:
HSSFFormulaEvaluator.setupEnvironment(String[], HSSFFormulaEvaluator[])
There is a test case which serves as an example:
TestWorkbookEvaluator.testEvaluateMultipleWorkbooks()
Of course, multi-workbook evaluation requires all referenced workbooks
to be present. If not, you're stuck with digging the cached results
out of the CRNRecords.
Hope this helps,
Josh
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
