Re: [libreoffice-users] [CALC] Detective Trace inadequate display

comments below
On 25/10/13 23:43, Ady wrote:
> Hello,
>
> I'd like to ask for confirmation, whether the following situation
> happens to other users of Calc too.
>
> 1_ Start a new spreadsheet with 2 sheets, with the zoom at %100.
> 2_ On "Sheet2.E20" insert the following formula: "=Sheet1.E20"
> (without quotation marks).
> 3_ Select "Sheet2.E20".
> 4_ Press "Shift+F7", (Trace Precedents). Note the position of the
> trace arrow.Pointing from the upper left into E20
> 5_ Change the zoom, from %100 to either %90 or to %110. Note the
> (new?) position of the trace arrow.arrow points from C17 to D19
> 6_ Change the zoom back to %100. Note the (new?) position of the
> trace arrow.same position
> 7_ Go to Tools -> Detective -> Refresh Traces. Note the (new?)
> position of the trace arrow.back to it's original location
If I place the formula in A1 the arrow disappears when zoom is set to 
90% and doesn't reappear when it is set back to 100%. However "refresh 
traces" does restore the arrow

Hope this helps (Fedora 20 Alpha LO4.1.2.3)

Cheers
> If the test cell is "A1" instead of "E20", the trace arrow might
> disappear from the screen when changing the zoom, until the next
> "Refresh Traces".
>
> In my system, step 5 incorrectly changes the displayed position of
> the trace arrow, step 6 maintains the inadequate position, and step 7
> "corrects" it. Additionally, performing some other tasks (e.g.
> copy+paste) might refresh the trace arrows too (but I'm not sure
> whether *any* task will).
>
> In fact, the initial and/or ending zoom(s) can be any other than %100
> too, as *any* zoom change generates this issue.
>
> In the above steps I used "Trace Precedents". I see the same effect
> when selecting "Sheet1.E20" and using "Trace Dependents" instead.
>
> If this is replicable by other users, IMHO there should be at least
> some way for the user to easily note that the traces should be
> refreshed (because they are not really pointing to/from the adequate
> intended cells). Perhaps by changing the color of the "offset" trace
> arrows? Better yet, this displacement should not even happen,
> specially with "AutoRefresh" (traces) set on, but I guess this is why
> the "Refresh Traces" action exists(?).
>
> Is this happening just in my system?
>
> TIA,
> Ady.


--
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