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.
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.