Bug 49949 - [EDITING, FORMATTING] misdirected/wrong arrow links of comment field regarding to owner cells when importing xls
Summary: [EDITING, FORMATTING] misdirected/wrong arrow links of comment field regardin...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.5.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Comments
  Show dependency treegraph
 
Reported: 2012-05-15 03:55 UTC by Peter Schmitt
Modified: 2023-01-23 09:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example XLS showing the misdirection effect for comment fields (93.50 KB, application/vnd.ms-excel)
2012-05-15 03:55 UTC, Peter Schmitt
Details
wmv videoclip showing the effects (1.70 MB, video/x-ms-wmv)
2012-05-15 03:58 UTC, Peter Schmitt
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Schmitt 2012-05-15 03:55:38 UTC
Created attachment 61675 [details]
Example XLS showing the misdirection effect for comment fields

The example "misdirected_comment_links.xls" leads in LibO 3.5.3.2 on both "Windows XP SP3" and "Windows 7 Professional 64 bit" to the following irritations as shown in the wmv-videoclip "LibO_3.5.3.2-misdirected_comment_links.wmv".

Cell K278 OK

Cell L348: 
a) on mouse-over: 
arrow points wrongly to L347, the comment field properly placed

b) via context menu "show comment"
arrow points wrongly to L347, the comment field placed "offside" on level L302

Cell L349:
a) on mouse-over: 
arrow points wrongly to L348, the comment field properly placed

b) via contect menu "show comment"
arrow points wrongly to L348, the comment field placed "offside" on level L302


Because of the fact that "linked arrows to cells" are commonly used "eye-catchers" to make information references easy and because of LibreOffice is intended to manage xls format, I would like to state this behavious as critical.
Comment 1 Peter Schmitt 2012-05-15 03:58:43 UTC
Created attachment 61676 [details]
wmv videoclip showing the effects
Comment 2 A (Andy) 2015-01-04 10:37:04 UTC
Reproducible with LO 4.4.0.0.beta1 (Win 8.1) with the attached file

@Peter: Could you please tell how you had created these wrongly placed comments.  Can you reproduce it with a new file and tell what has to be done to reproduce it.  Thank you very much in advance.

As per Prioritizing Bugs Priority Triage Flowchart changed importance to Normal/Medium.
Comment 3 QA Administrators 2016-01-17 20:03:32 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-05-14 02:54:51 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2021-05-14 04:10:37 UTC Comment hidden (obsolete)
Comment 6 Stéphane Guillou (stragu) 2023-01-23 09:56:16 UTC
Reproduced in:

Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 579d144290c1617fdb38d09b30900a6bbe390b8d
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded