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 ***