Created attachment 49330 [details] two versions (one working and one not) Once you refernce a cell via name instead of an absolute reference the interpretation of the formula fails when using the Compatibility-Mode for .xls Talking about Column O. Attached two Verison of the .xls Seems there have a formlua which is not to simple..... Libreoffice 3.4 on Win 7 an others..
I don't see any problems so please provide some more information which cell you think is misinterpreted and how it should look like And if possible please try with 3.4.2RC1 or RC2. I think that I fixed several problems around this for 3.4.1 and 3.4.2
I think it is a duplicate of bug 38113 and bug 38204 that was fixed for 3.4.2 *** This bug has been marked as a duplicate of bug 38204 ***