Ask Your Question

"Show references in color" sometimes broken

asked 2015-08-24 14:06:46 +0200

RonJohn63 gravatar image

updated 2015-08-24 15:54:08 +0200

Alex Kemp gravatar image


LO v5.0.0.5 from on Xubuntu 14.04

On the two multi-tab spreadsheets that I use, none of the formulas in one of the tabs shows formula references in color when I press F2. It's just the formula in B&W in the cell. All other tabs work as expected.

Is this a bug or am I misconfiguring something?


edit retag flag offensive close merge delete


Upgrade to with sudo add-apt-repository ppa:libreoffice/ppa and sudo aptitude update || sudo apt-get update and sudo aptitude full-upgrade || sudo apt-get upgrade !

rautamiekka gravatar imagerautamiekka ( 2015-10-06 18:01:31 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2015-10-06 16:44:27 +0200

pierre-yves samyn gravatar image


There is an option: Tools Options Calc View Show references in color


edit flag offensive delete link more

answered 2015-10-06 15:35:06 +0200

Alex Kemp gravatar image

Hi RonJohn63

LO-5 is from LibreOffice Fresh & as such may be buggy. You need to get used to using Bugzilla (or the Bug Assistant).

The alternative is to use LibreOffice Still (more stable, less exciting).

If this helps then please tick the answer (✔)
...and/or show you like it with an uptick ()

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-08-24 14:06:46 +0200

Seen: 284 times

Last updated: Oct 06 '15