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
Maybe the same as Bug 54500...
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.
Created attachment 30998 [details] BiffViewer output of the file that fails
Created attachment 30999 [details] BiffViewer output of the file that is created by POI and which works