In the formula of a cell which refers to other cells, the colors assigned to the referred cells become black when the formula is being edited.
It would be expected that the colors remain, since they can prove to be of great visual aid and improve the formula editing process.
Thanks to take time to report this disfunction. Would you be so kind to also provide a document showing the bug?
Created attachment 131813 [details]
file to demonstrate the bug
I have attached a file to demonstrate the bug.
For those wanting to try this out, it is probably much simpler to reproduce the bug in an empty document than by downloading the file: the file is empty except for a formula in the A1 cell which reads "=A2" (unquoted, of course). Upon editing the formula, adding any character to it will remove the color from the A2 reference.
Created attachment 131814 [details]
same document modified
I wanted to be sure we were speaking about the same thing.
I added only +2 to the formula. No color change into result for me with
LO 126.96.36.199 Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut;
Locale : fr-FR (fr_FR); Calc: single
Can you precise which OS you tried?
(In reply to Jacques Guilleron from comment #4)
> Can you precise which OS you tried?
Sure, I'm using Arch Linux 4.9.11-1-ARCH, but would this have any effect? Are we using the same version? The problem is only detectable as you actually edit the formula. When you leave and re-enter the formula, you will see the cell reference colors again.
*** This bug has been marked as a duplicate of bug 38304 ***