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: 2025-01-23 03:10 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
Comment 7 QA Administrators 2025-01-23 03:10:29 UTC
Dear Peter Schmitt,

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information from Help - About LibreOffice.
 
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug