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/11/26 19:41:11 UTC

DO NOT REPLY [Bug 48294] New: setSheetOrder() breaks inter-sheet references

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

           Summary: setSheetOrder() breaks inter-sheet references
           Product: POI
           Version: 3.5-FINAL
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: asf-bugzilla@barillari.org


Created an attachment (id=24625)
 --> (https://issues.apache.org/bugzilla/attachment.cgi?id=24625)
Run this file; a spreadsheet with the problem is dumped to stdout.

If you call setSheetOrder() on sheets on a workbook with inter-sheet references
(e.g., a formula like ='Sheet 2'!A3 on Sheet 1), the references can be broken.
The attached Java file shows how to reproduce the bug.

Tested with POI 3.5-FINAL (poi-bin-3.5-FINAL-20090928.tar.gz) on Debian with
this Java:

java version "1.6.0_16"
Java(TM) SE Runtime Environment (build 1.6.0_16-b01)
Java HotSpot(TM) Server VM (build 14.2-b01, mixed mode)

And OpenOffice.org 3.1.1.

Resolution: I avoided the bug by creating all sheets at once in the order in
which they would stay in the final file. An easy workaround would be to add a
sentence to the documentation of setSheetOrder() warning the user that it may
break references.

-- 
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 48294] setSheetOrder() breaks inter-sheet references

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

--- Comment #1 from Antti Koskimäki <an...@joinex.com> 2011-06-29 04:55:03 UTC ---
Still present (3.8b4). Work-around gives me headache, final sheet-order isn't
always known early enough.

-- 
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 48294] setSheetOrder() breaks inter-sheet references

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

Yegor Kozlov <ye...@dinom.ru> changed:

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

--- Comment #2 from Yegor Kozlov <ye...@dinom.ru> 2011-07-02 13:28:32 UTC ---
Fixed in r1142219

setSheetOrder() now updates cell formulas, defined names and formulas in
conditional formatting. Same rules are involved in Sheet.shiftRows. 

Formulas in data validations aren't updated, but this will require much more
technical efforts. I'm leaving this out for the future.

Yegor

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