Ask Your Question
0

Trace dependents/precedents when in another sheet [closed]

asked 2012-02-22 11:39:26 +0200

Gon gravatar image Gon
1 1 1

updated 2013-02-16 22:30:01 +0200

qubit gravatar image qubit flag of United States
5816 3 50 43

When precedents are in another sheet or file, the symbol we get shows a square and the cursor does not change over it, so there is no way to trace the cell.

delete reopen flag offensive retag edit

Comments

Hi @Gon, did @mikebibo answer your question? If so, please mark his answer as correct. Thanks!

qubit ( 2013-01-20 00:32:42 +0200 )edit

The question has been closed for the following reason "question is not relevant or outdated" by qubit
close date 2013-03-10 10:00:28.500348

1 Answer

Sort by » oldest newest most voted
1

answered 2012-04-29 16:27:18 +0200

mikebibo gravatar image mikebibo
381 3 5

Actually, an old Excel keyboard shortcut seems to work to trace a precedent on another worksheet: Ctrl+[ (Control + left square bracket). This works on Linux and Windows, but I haven't been able to find a mac-equivalent - Command+[ does not work.

link delete flag offensive edit

Donate

LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!

Question tools

Follow

subscribe to rss feed

Stats

Asked: 2012-02-22 11:39:26 +0200

Seen: 314 times

Last updated: Apr 29 '12