poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 57332] New: FormulaEvaluator with external references
Date Tue, 09 Dec 2014 08:26:21 GMT
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: dev@poi.apache.org
          Reporter: patrick.avez@gmail.com

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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message