Ask Your Question
0

Why two equal signs in formula ==DEC2HEX(L3,4)?

asked 2020-09-27 19:14:35 +0100

gnuarm1 gravatar image

If I try to remove one of the equal signs it is added back on pressing enter. It seems to work ok, but I've never seen this before and I don't know what it means.

edit retag flag offensive close merge delete

Comments

1

See my answer, however, I can't reproduce the behaviour of when one equal sign is removed it appears again. Which LibreOffice version and OS anyway?

Please do not use the Answer field, edit your original question to provide further details. Thanks.

erAck gravatar imageerAck ( 2020-09-28 00:38:23 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2020-09-28 00:36:36 +0100

erAck gravatar image

updated 2020-09-28 00:37:11 +0100

Cell formulas starting with two equal signs are treated volatile and recalculated on each change of spreadsheet content. Which in this case makes absolutely no sense. The functionality is meant to trigger user provided functions that do not (only) depend on a cell or range.

edit flag offensive delete link more

Comments

Trying, I "discovered" that if you have a cell range beggining with "==" and try to change a middle cell to "=" it is no posible.

Also, if you have cell range beggining with "=" and try to change a middle cell to "==" it is no posible.

Need to test a bit more. If you select at least two cells in a range of four, or the three central or four in a five cell range (I don't tested all the progression) and change accepting with Alt+Enter all cells in the range changes.

New things to learn every day. With me LibreOffice 6.3.6.2 (x86); OS: Windows 6.1.

LeroyG gravatar imageLeroyG ( 2020-09-28 02:55:37 +0100 )edit

just to add some confusion to the confusion ...

two '=='-formula cells are coupled, 'entangled' (quantum physics), if they are one below the other, and referencing cells in the same columns ... in that case the top cell is the leader, and cells below change with it, intentional?

newbie-02 gravatar imagenewbie-02 ( 2020-09-28 12:36:09 +0100 )edit

That may be because in a subsequent column block of identical formulas it is a shared formula and sharing criteria is based on the expression and does not take the extra forced flag (the ==) into account.

erAck gravatar imageerAck ( 2020-09-28 12:43:20 +0100 )edit

would be right to change that to restore the same editability to '=='-formulas as to '='? edits to other shared formulas are accepted ...

newbie-02 gravatar imagenewbie-02 ( 2020-09-28 22:21:00 +0100 )edit

sorry, late eval, @LeroyG is right, '='-formulas are blocked too, imho wrong behaviour, if a user wants to change something it's his decision, proposals for 'other ideas' are ok, but not blocking without notice ...

newbie-02 gravatar imagenewbie-02 ( 2020-09-29 06:00:19 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-09-27 19:14:35 +0100

Seen: 45 times

Last updated: Sep 28