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.