Hi,
LibreOffice 4.0.3.3 on Windows XP.
- In cell A1 type in 100. In cell A2 type in =A1*10. In cell A3 type in =A2-10.
- Tools | Detective | Trace Precedents.
There is trace displayed on cells A2 and A3.
- If clicked on A2 and repeat step 2 then trace is also displayed for cell A1 to A2.
Is there a way to have this multi-step dependencies trace done in one step? If there are multiple cascading cells dependencies, this multi-step is time consuming. Is there a way to do this multi-dependencies detective trace in one step?
Thanks