Calc formula garbled/re-arranged/differs from formula entered

[Edward3]

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.

[ROSt53]

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?

[physicist]

It’s pretty clear that the second line above is different from the original. The second one shows
huiadj.b50provcomprpt.b50
which should at least start with an = sign
=ProvCompRpt.B50

It shouldn’t matter that the cases are changed but it’s damnably hard to figure out how software could change it. Do you have anything anywhere that looks like “huiadj”. Perhaps it’s some Asian version of “equals”. That’s pretty surely where the #NAME error is coming from. Are the names related to different sheets? Do they need ! or $ symbols in front of them?

I would try splitting it in half into two unused cells and then adding them together. Perhaps calc is running into some size limit but I doubt it.