https://bugs.documentfoundation.org/show_bug.cgi?id=170570
--- Comment #7 from ady <[email protected]> --- I should mention that Tracing Dependents in Calc has always been a problem, not a new thing. And it doesn't really matter if you are opening a file that already has (some) Dependents to be shown, or that you have an already-opened file and you activate the action to Trace Dependents on some cell; both cases can take a long time (sometimes making Calc "Not Responding" for several minutes). The problem with Dependents is that the user does not know in advance how many of them there are. If the workbook is complex, it might take some time and then there might be just a couple of Dependents on the specific selected cell, or there might be hundreds of them. Moreover, the feature is only useful for Dependents located on the same spreadsheet; when the Dependents are located on other spreadsheets (even on the same workbook), its practical usefulness is very, very limited (see tdf 63087). When using Calc, I tend to limit myself regarding the relations between spreadsheets just because of the limitations of the Trace Dependents feature. If this feature were usable in practice for those relations, I would structure my workbooks differently. The reason I mention all this here is because investing resources on improving the way the arrows are displayed or providing some alternative display is probably not enough for users to be able to take real advantage of the feature anyway. Improving the performance would indeed help – no doubt about that – but improving the feature itself (so as to adequately support relations to other spreadsheets) might be worth of consideration too. -- You are receiving this mail because: You are on the CC list for the bug.
