Re: [libreoffice-users] calc: highlight cells referenced by formula

At 06:47 05/11/2015 +0100, Sandro Santilli wrote:
> I'm looking for a way to speedup the process of looking at each cell 
> cells referenced by a formula. Right now I'm doing this manually, 
> which requires going back and forth
> between the formula cell and each of the referenced cells (which 
> I've to find with my eyes). Someone on IRC told me there's no 
> built-in support for highlighting referenced cells and that it'd 
> take a macro to do that.

Do you need just Tools | Detective > | Trace Precedents (or 
Shift+F7)? This will display the links through which a formula 
harvests its parameters. There is also Tools | Detective > | Trace 
Dependents (or Shift+F5) to do the same thing in reverse.

> While writing this mail I'm thinking it would be even better not 
> just to highlight but to either allow cycling over each cell with a 
> keystroke...

You could use the arrow keys to move between cells and then Shift+F7 
at each cell to have its precedents indicated. You might also wish to 
experiment with repeating Shift+F7 on the same cell: this appears to 
mark the precedents of the cell's own precedents. If you start at the 
end of a calculation, pressing Shift+F7 repeatedly may be a very 
quick way to show what you need.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted