Ask Your Question

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

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

Edward gravatar image

updated 2020-08-14 15:49:16 +0200

Alex Kemp 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:


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:


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

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-14 15:49:43.238704


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

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

Question Tools

1 follower


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

Seen: 198 times

Last updated: Jan 02 '15