# Calc formula garbled/re-arranged/differs from formula entered [closed]

Win 8.1, LibreOffice 4.2.8 AND 4.3.5

I enter a long formula (adding cells from multiple sheets) as follows:

=ProvCompRpt.B50+ProvCompRpt.B52+AyusoAdj.B50+AyusoAdj.B52+KimAdj.B50+KimAdj.B52+LandaAdj.B50+LandaAdj.B52+LeboAdj.B50+LeboAdj.B52+MazerAdj.B50+MazerAdj.B52+RooneyAdj.B50+RooneyAdj.B52+HuiAdj.B50+HuiAdj.B52+LuoAdj.B50+LuoAdj.B52+Allergist_1Adj.B50+Allergist_1Adj.B52+Allergist_2Adj.B50+Allergist_2Adj.B52+MiscAdj.B50+MiscAdj.B52+PaymentRvsl.B50+PaymentRvsl.B52

The above is copied from the formula bar, as is the result below. The formula is entered by navigating to the respective cells and pressing +, so there's no mistyping. It's long and inelegant, but it's recognizable as a formula. After pressing enter I get a #NAME error, with the formula bar showing:

huiadj.b50provcomprpt.b50+ProvCompRpt.B52+AyusoAdj.B50+AyusoAdj.B52+KimAdj.B50+KimAdj.B52+LandaAdj.B50+LandaAdj.B52+LeboAdj.B50+LeboAdj.B52+MazerAdj.B50+MazerAdj.B52+RooneyAdj.B50+roonallergist_1adj.b50eyadj.b52++HuiAdj.B52+LuoAdj.B50+LuoAdj.B52++Allergist_1Adj.B52+Allergist_2Adj.B50+Allergist_2Adj.B52+MiscAdj.B50+MiscAdj.B52+PaymentRvsl.B50+PaymentRvsl.B52

Cell is formatted number, cell contents have autoinput off, any hints as to what I may be doing wrong.

I am sorry to have to say so but how can you expect that one can go character by character through 2x4 line long complex string? ----- May I suggest you create an example string with the least characters possibly and add detail explanation on which steps yiou did and what was the result of each step?