Bug 47051 - [EDITING] Changing a comment position breaks its link to the commented cell
Summary: [EDITING] Changing a comment position breaks its link to the commented cell
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Comments
  Show dependency tree / graph
 
Reported: 2012-03-07 05:55 UTC by Nicolas Mailhot
Modified: 2023-09-29 21:26 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
testcase (25.98 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-03-07 05:56 UTC, Nicolas Mailhot 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Nicolas Mailhot 2012-03-07 05:55:18 UTC 
In the attached testcase, trying to change the Y position of the first comment to 6,25 cm, makes the arrow pointing to the commented cell move to the document origin (sometimes there are even weirder effects, the comment flies to another place in the document)

Specifying a comment position should not change the place its arrow points to and the comment should be placed at the position the user requested
Comment 1 Nicolas Mailhot 2012-03-07 05:56:03 UTC 
Created attachment 58116 [details]
testcase
Comment 2 sasha.libreoffice 2012-05-30 07:29:45 UTC 
Thanks for bugreport
reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit (on Windows not tested)
Steps to reproduce:
0. Open attachment in Calc
1. Select most upper comment
2. Right mouse click, select "Position and size" from context menu
3. in field "position Y" enter 6 instead of 8,71
4. click OK
Expected: comment binding retains
Actually: comment now connected to non-existing cell (row 0, col 0)

5. Press Ctrl-Z
Expected: comment binding repairs
Actually: only size of comment undone, it still connected to wrong cell
Comment 3 Owen Genat (retired) 2013-03-17 22:35:29 UTC 
Further info reported under Ubuntu v10.04 x86_64 / LO v3.5.7.2 (TDF version), Ubuntu v10.04 x86_64 / LO v4.0.1.2 (TDF version), and Windows 7 / LO v4.0.1.2:
a. Steps 1-4 described in comment #2 result in comment moving attachment as described (confirmed). Cntl-Z (twice) will result in restoration of cell binding - first Cntl-Z restores comment position, second Cntl-Z the binding.
b. If I open the spreadsheet and then click-AND-HOLD the mouse pointer assumes the greyed square outline icon indicating object dragging. After drag/release, again the cell binding is lost as described in comment #2. Cntl-Z does not result in restoration of cell binding.
c. If I open the spreadsheet, click on the comment (select), and THEN subsequently 'grab' the comment (fist mouse icon), the cell binding is retained as expected.
Comment 4 QA Administrators 2015-02-19 15:39:07 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2015-03-07 14:14:03 UTC 
(In reply to sasha.libreoffice from comment #2)
> Thanks for bugreport
> reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit (on Windows not tested)
> Steps to reproduce:
> 0. Open attachment in Calc
> 1. Select most upper comment
> 2. Right mouse click, select "Position and size" from context menu
> 3. in field "position Y" enter 6 instead of 8,71
> 4. click OK
> Expected: comment binding retains
> Actually: comment now connected to non-existing cell (row 0, col 0)
> 
> 5. Press Ctrl-Z
> Expected: comment binding repairs
> Actually: only size of comment undone, it still connected to wrong cell

Reproduced.

Win 7 Pro 64-bit, LibO Version: 4.4.1.2
Build ID: 45e2de17089c24a1fa810c8f975a7171ba4cd432
Locale: fi_FI
Comment 6 tommy27 2016-04-16 07:26:29 UTC Comment hidden (obsolete)
Comment 7 QA Administrators 2019-05-14 02:56:58 UTC Comment hidden (obsolete)
Comment 8 Niha 2020-05-31 06:11:55 UTC Comment hidden (spam)
Comment 9 fidelma 2022-03-10 08:33:33 UTC Comment hidden (spam)
Comment 10 semu mera 2023-05-24 10:11:36 UTC Comment hidden (spam)
Comment 11 john 2023-09-26 09:30:03 UTC Comment hidden (spam)
Comment 12 ifasharo 2023-09-29 21:26:26 UTC Comment hidden (spam)