Created attachment 48546 [details]
preview xls file
I tried to figure out what the problem is, i think it's in the named cells.
cell A1 1.5 (given the name euro)
cell A2 23.98213 (just a number)
cell A3 49.023 (just a number)
cell B5 formula: =ROUND(A3+A2/euro,2) --> result 65.01
when I save this file as .ods everything is fine.
when I save this file as .xls the formula in cell B5 changed in: =ROUND(#NAME?+A3/A2,2) and give Err:520.
when I save the .xls file again the formula disappear and cell B5 gives #N/A
*** This bug has been marked as a duplicate of bug 38204 ***