First time here? Check out the FAQ!
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.
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.
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!
Asked: 2012-02-22 11:39:26 +0200
Seen: 314 times
Last updated: Apr 29 '12
Set data point interval in a Calc Chart
how to find and remove duplicates automatically
How to make a chart with sorted values from a column?
Change Dynamic Formulas To Static
LO 4 Calc crashes whenever "=" is typed, or Formula button is clicked. (Linux)
how to change the format of the hyperlink in Calc ?
How do I display labels on minor grid ticks?
why basic code ''ThisComponent.getCurrentSelection.formula" replaces comma with semicolon?
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
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