Bug 47051

Summary:	[EDITING] Changing a comment position breaks its link to the commented cell
Product:	LibreOffice	Reporter:	Nicolas Mailhot <nicolas.mailhot>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	normal
Priority:	medium	CC:	sasha.libreoffice
Version:	3.3.4 release
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:
Attachments:	testcase

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 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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.