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 2008/05/20 17:28:58 UTC

DO NOT REPLY [Bug 45046] New: Cell References for Macro Function are moved after saving

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

           Summary: Cell References for Macro Function are moved after
                    saving
           Product: POI
           Version: 3.0
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: major
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: bernhard.schwager@komaxgroup.com


Created an attachment (id=21984)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=21984)
after saving this file some cell references from myfunction are pointing to a
different cell

If I open and store an xls-file (no changes) with hssf some cell references are
moved to a different location. Only cell references from macro functions are
affected.

I attached an example xls. After saving this file with poi some cell references
point at a different cell. 

Build & Platform
poi-3.0.1-FINAL-20070705 on Win XP SP2


-- 
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 45046] Cell References for Macro Function are moved after saving

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


Josh Micich <jo...@gildedtree.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED




--- Comment #1 from Josh Micich <jo...@gildedtree.com>  2008-05-22 22:30:23 PST ---
There were a few POI bugs that needed fixing here.

The initial report "some cell references point at a different cell" is probably
a duplicate of bug 41726 (which was fixed before 3.0.2-FINAL.

However, since then the LinkTable has been abstracted and it had an assumption
that NameRecord(DEFINEDNAME-0x18) would not occur by itself, but only after a
SupBook(EXTERNALBOOK-0x1AE) and an ExternalSheet(EXTERNSHEET-0x17) record.

The supplied file just has a NameRecord all by itself, and Excel seems to be OK
with this.  The fix was relatively simple and was applied in svn r659429.

There were much worse problems which were fixed separately in bug 45066.


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