Ask Your Question
0

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

asked 2014-12-23 20:42:36 +0200

Edward gravatar image

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.

edit retag flag offensive close merge delete

Comments

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?

ROSt52 gravatar imageROSt52 ( 2014-12-24 12:13:53 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2015-01-02 00:32:04 +0200

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2014-12-23 20:42:36 +0200

Seen: 125 times

Last updated: Jan 02 '15