This file : http://www.bankofengland.co.uk/publications/Documents/quarterlybulletin/2013/APFcashtransfersupdate.xlsx opens correctly in Excel 2010 Starter and "works". It produces a lot of errors when opened in LO. Might in part be the same problem as https://bugs.freedesktop.org/show_bug.cgi?id=85960 I have noticed a number of #ref errors building up. but may also be due to some Excel/LO function incompatibility. Saving from LO and re-opening makes things worse.
OS > All OSX 10.10, LO Version: 4.4.0.0.alpha2+ Build ID: fe076b977661679842d44ecf21a66fca4d96ce33 TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2014-11-08_01:49:46 Confirmed. e.g. look at "Balanace Sheet" in Excel 2010 it shows fine, in LO lot's of refereences errors.
I think the first errors comes from the sheet monthly payments with the formula: =MATCH(1,INDEX(OFFSET($A$6:$YQ$6,0,B11)>0,0),0)+B11 The question is now what this formula is doing and why it fails. It would be good to reduce this bug document to a minimal reproducer that works with MS Excel and does not work with Calc.
Created attachment 115027 [details] Minimised example So the funky thing that the "Monthly cashflows" sheet is doing is to linearise a horizontal list of values, such that the result is a list of column indices where the value in the source list > 0 Effectively each of those formulae is asking "what is the column index, in the given range, of the next cell to the right of (the column index stored in the result to my left) which has a value greater than zero". Minimised example attached
A quick scan of past versions back to OOo 3.3.0 suggests that this has never worked -> Version: Inherited from OOo
It is working for me perfectly with LO 5.1.4