Issue 83644 - Detective Traces misplaced
Summary: Detective Traces misplaced
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 2.2.1
Hardware: All All
: P3 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-11-14 16:39 UTC by huw
Modified: 2017-05-20 11:13 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Misaligned detective traces in Calc (41.77 KB, image/png)
2009-03-19 17:16 UTC, martenjan
no flags Details
Misaligned detective trace and stretched sheet (338.99 KB, text/plain)
2009-03-20 09:44 UTC, martenjan
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description huw 2007-11-14 16:39:46 UTC
Detective only works correctly with sheets in 10 point Arial, otherwise Traces 
(markers) get out of line with cells they apply to
Comment 1 frank 2007-11-15 11:11:42 UTC
Could not reproduce using OOo2.3. 
Please describe step by step how to reproduce.
Comment 2 huw 2007-11-16 08:47:42 UTC
Zoom sheet to 100% view
Right-click any cell
Set all cells to Default format
Open style pane F11
Modify default style to 7 point arial
in cell A5000 enter =A3000
Trace precedents Shift+F7
Arrow goes from A3059 to 5099

Zooming corrects

Same for any other detective traces including trace error and mark invalid data
Comment 3 frank 2007-11-16 10:45:43 UTC
Hi Niklas,

seems to be yours.

Comment 4 martenjan 2009-03-19 17:12:15 UTC
I encountered the same issue in OOo3.0 via a different path: by modifying the
cell sizes. 
Both horizontal and vertical positions are affected, see screenshot.

Zooming corrects.

Comment 5 martenjan 2009-03-19 17:16:26 UTC
Created attachment 61053 [details]
Misaligned detective traces in Calc
Comment 6 martenjan 2009-03-20 09:44:09 UTC
Created attachment 61063 [details]
Misaligned detective trace and stretched sheet
Comment 7 martenjan 2009-03-20 10:04:30 UTC
The Misaligned detective2.png file needs the following clarifications
* The sheet includes some matrix manipulations
* The sheet includes some labels with subscripts and superscripts
* The sheet stretches when the detective is used. In the picture, the columns L
line up nice, whereas the columns AA are shifted with respect to each other.

The picture is generated as follows:
1. Using Tools > Detective > Fill mode, the traces are applied. 
2. PrintScreen captures the screen
3. The screen print is pasted in Paint
4. In Calc, all traces are removed
5. PrintScreen captures the screen
6. The screen print is pasted in Paint, and saved for submission here.

* The stretching issue occurs visibly only at 100% zoom factor. 
* The stretching issue is reproducable.
* I tested also at 75% and 150%. The misalignment issue occurs also, but
stretching is not visible.
* Changing the zoom factor does not repair the misalignment as it did in the
previous posts in this bug report.

Comment 8 Marcus 2017-05-20 11:13:18 UTC
Reset assigne to the default "".