Ask Your Question

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

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 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.

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

## 1 Answer

Sort by » oldest newest most voted

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.

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.

( 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?

( 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.

( 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 ...

( 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 ...

( 2020-09-29 06:00:19 +0100 )edit

## Stats

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

Seen: 45 times

Last updated: Sep 28