I noticed when editing a cell with formula Libre can show the other cells being referenced. Can I enable this behavior while I am moving around the spreadsheet without getting into edit mode? It is very useful to troubleshoot formula errors by visualizing it quickly. This is the only feature I noticed in Apple Numbers that is very useful.
To use the ‘Detective’ tool you needn’t enter edit mode for any cell. Having selected the relevant cell while calling the detective will do.
The automatic colouring of referenced ranges only is available during edit.