Bug 49949

Summary: [EDITING, FORMATTING] misdirected/wrong arrow links of comment field regarding to owner cells when importing xls
Product: LibreOffice Reporter: Peter Schmitt <klauspeter.schmitt>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: NEW ---    
Severity: normal CC: stephane.guillou, stgohi-lobugs
Priority: medium    
Version: 3.5.3 release   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=146856
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 101216    
Attachments: Example XLS showing the misdirection effect for comment fields
wmv videoclip showing the effects

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