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 2009/02/07 11:58:17 UTC

DO NOT REPLY [Bug 46670] New: Reference to cell in different workbook not possible

https://issues.apache.org/bugzilla/show_bug.cgi?id=46670

           Summary: Reference to cell in different workbook not possible
           Product: POI
           Version: 3.2-FINAL
          Platform: PC
        OS/Version: Windows Vista
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: wimgoeman@gmail.com


When I try to refer to a cell in a different excel file, I do not get an error,
but when I open the file in Excel, the contents of the cell is #REF!A1 for
example. I used this code:

cell.setCellFormula("folder\\[workbook.xls]sheet!A1");

Since I cannot find anything about this problem, I thought it could be a bug.

Greetings,

Wim


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

[Bug 46670] Reference to cell in different workbook not possible

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

--- Comment #8 from panfil <va...@gmail.com> ---
Is there ANY workaround?

-- 
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 46670] Reference to cell in different workbook not possible

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

--- Comment #11 from Nick Burch <ap...@gagravarr.org> ---
Thanks for the tests

Based on this, I've added in r1633257 something based on your tests for HSSF
only, along with an expanded version for HSSF and XSSF

Bad news - it fails on both, for different reasons... I suspect someone will
need to fix the XSSF case first, as that should be simpler to understand, then
look into why the HSSF one is failing earlier

-- 
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 46670] Reference to cell in different workbook not possible

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

--- Comment #10 from panfil <va...@gmail.com> ---
Created attachment 32116
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=32116&action=edit
Failed test case for 3.11-beta2

I wrote a simple test case for poi 3.11-beta2. I tried to modify some
references to another .xls files, can be accessed locally or over http. The
test failed, when I try to set cell formula with external reference it gives me
#REF all the time.

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

Nick Burch <ni...@alfresco.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|                            |45970

--- Comment #4 from Nick Burch <ni...@alfresco.com> 2010-06-04 10:52:10 EDT ---
This looks to be very similar to bug #45970, except that was for URLs and this
is for local files. I suspect a fix for one will fix the other

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

[Bug 46670] Reference to cell in different workbook not possible

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

Nick Burch <ap...@gagravarr.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |NEEDINFO

--- Comment #9 from Nick Burch <ap...@gagravarr.org> ---
There was a large amount of work done on 3D references (workbook+sheet+cell) in
3.11 beta 1, see http://poi.apache.org/changes.html#3.11-beta1 . A lot of
things that used to fail with these now work. 

It'd therefore be great if someone could re-test this specific issue with 3.11
beta 2, and see if the work in there has fixed this case as well. If not, a
small junit unit test showing how this issue remains would be most helpful!

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

--- Comment #5 from Nico <ni...@gmail.com> 2011-06-07 17:34:17 UTC ---
I got the same problem on POI 3.6, and i see this issue has been opened 2 years
ago. 
This is a very important feature for developers working with excel files. 
I do not understand why is still unsolved...

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

--- Comment #2 from dave.sprague@trintech.com 2010-03-26 21:07:52 UTC ---
Trintech is supplying a zip file with examples. Please review file entitled
2160_1900_801_+_810_XXX_FY10_P05 (2).xls to determine if this issue is related.

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

--- Comment #3 from dave.sprague@trintech.com 2010-03-26 21:10:32 UTC ---
Created an attachment (id=25193)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=25193)
Trintech_POI examples.zip

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

dave.sprague@trintech.com changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |dave.sprague@trintech.com

--- Comment #1 from dave.sprague@trintech.com 2010-03-18 22:42:54 UTC ---
I've discovered an issue (that appears to be similar to this issue) within an
application that we have build (using POI 3.6). I can provide examples as
needed, but is this specific issue slated for inclusion within POI 3.7?

Thanks,

Dave Sprague
Director, Product Management
Trintech

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

--- Comment #7 from Nico <ni...@gmail.com> 2011-06-08 07:43:24 UTC ---
I'm very disappointed with your banal reply. 
I know that this is a volunteer project, in my post I was just pointing out
that in 2 years none has noticed this important issue, and I do not understand
the roughness of your reply.
Greetings

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

[Bug 46670] Reference to cell in different workbook not possible

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

panfil <va...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |valeriy.panfilov@gmail.com

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

--- Comment #6 from Nick Burch <ni...@alfresco.com> 2011-06-07 21:09:16 UTC ---
Apache POI is a volunteer project. If this new feature is important to you,
please do work on it and send in patches!

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

DO NOT REPLY [Bug 46670] Reference to cell in different workbook not possible

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

Bug 46670 depends on bug 45970, which changed state.

Bug 45970 Summary: Unble to read and write the formula string which has "HTTP url"
https://issues.apache.org/bugzilla/show_bug.cgi?id=45970

           What    |Old Value                   |New Value
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED

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