You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2014/12/09 09:26:21 UTC

[Bug 57332] New: FormulaEvaluator with external references

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

[Bug 57332] FormulaEvaluator with external references

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57332

--- Comment #3 from patrick.avez@gmail.com ---
Created attachment 32276
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32276&action=edit
Test2.xlsx Excel file

-- 
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

[Bug 57332] FormulaEvaluator with external references

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57332

--- Comment #2 from patrick.avez@gmail.com ---
Created attachment 32275
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32275&action=edit
Test1.xlsx Excel file

-- 
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

[Bug 57332] FormulaEvaluator with external references

Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=57332

--- Comment #1 from patrick.avez@gmail.com ---
Created attachment 32274
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32274&action=edit
Main.xlsx Excel file

-- 
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