https://issues.apache.org/bugzilla/show_bug.cgi?id=57332
Bug ID: 57332
Summary: FormulaEvaluator with external references
Product: POI
Version: 3.11-dev
Hardware: PC
OS: Linux
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 32273
--> https://issues.apache.org/bugzilla/attachment.cgi?id=32273&action=edit
Java test code
Hello,
When I go through my worksheet evaluating the value of each cell, I don't get
any error but it doesn't work neither...
When I open my workbook, I have cells with formulas using named range (to
external workbook: test.xlsx).
In my Java code, I change the reference of this named range to another workbook
(test2.xlsx).
But then when I evaluate the value of each cell, it keeps using the old
reference.
I suppose that the evaluation doesn't "evaluate" the value of the new named
range.
I really don't see how I can solve this problem.
I tried to close my workbook before reopen it and evaluate the value of the
formulas.
But I get an error saying that the workbook "test.xlsx" (old reference) is not
a valid workbook in my environment. The error sais also that the valid
references are "main.xlsx" and "test2.xlsx", which is correct.
--
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]
