Bug 53832 - setSheetOrder() still breaks inter-sheet references
Summary: setSheetOrder() still breaks inter-sheet references
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-FINAL
Hardware: PC Windows XP
: P2 normal with 2 votes (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-05 15:28 UTC by rozsai.mate
Modified: 2013-11-02 20:27 UTC (History)
1 user (show)



Attachments
java code and xls files to reproduce/check error (3.31 KB, application/zip)
2012-09-05 15:28 UTC, rozsai.mate
Details
BiffViewer output of the file that fails (54.05 KB, text/plain)
2013-11-02 20:25 UTC, Dominik Stadler
Details
BiffViewer output of the file that is created by POI and which works (53.14 KB, text/plain)
2013-11-02 20:27 UTC, Dominik Stadler
Details

Note You need to log in before you can comment on or make changes to this bug.
Description rozsai.mate 2012-09-05 15:28:33 UTC
Created attachment 29336 [details]
java code and xls files to reproduce/check error

Bug 48294 still exists / has reappeared.
I have an xls with 3 sheets which are referencing each other.
If I change the order, it completely destroys now the formulas (it's wrong on all sheets).
Check the files attached.

poi-3.8-20120326
Windows XP
Excel 2003
Java 1.6.0.29
Comment 1 Dominik Stadler 2013-08-21 23:05:10 UTC
Maybe the same as Bug 54500...
Comment 2 Dominik Stadler 2013-11-02 20:25:00 UTC
Hmm, I tried to take a look at this, but it is really strange: 

If I use the provided sample xls-file, it does not work, a unit test fails to see the correct formula as well

If I however construct the exact same content inside POI by using the same formulas, it works! If I write this file, open it with LibreOffice, save it again, it fails again with the same problem.

Seems the file is somehow constructed differently by Excel and LibreOffice in comparison to POI, not sure where to continue looking here currently, I am attaching the two different BiffViewer outputs, maybe someone with more insight can take a look.
Comment 3 Dominik Stadler 2013-11-02 20:25:35 UTC
Created attachment 30998 [details]
BiffViewer output of the file that fails
Comment 4 Dominik Stadler 2013-11-02 20:27:02 UTC
Created attachment 30999 [details]
BiffViewer output of the file that is created by POI and which works